Data Model > Available DSCs > Relational MR database (RDB) CDSC > Relational MR Database CDSC schema > OtherData table
 
OtherData table
The OtherData table stores text, real, date, and object responses. The OtherData table is used only in the RDB DSC schema.
Columns
OtherID
Key: Yes
Column type: Integer
Linked: No
The unique identifier for the record in the OtherData table.
RealVal
Key: No
Column type: Float
Linked: No
The value for Real type responses.
DateVal
Key: No
Column type: Datetime
Linked: No
The value for Date type responses.
TextVal
Key: No
Column type: Nvarchar
Linked: No
The value for Text type responses. The limit is the SQL Server limit of 8000 bytes (4000 characters).
ObjectVal
Key: No
Column type: Image
Linked: No
The value for Object type responses. The actual database type for this column varies. In SQL Server it is an image column.
ExtOtherID
Key: No
Column type: Integer
Linked: No
Reserved for future use.
ParentOtherID
Key: No
Column type: Integer
Linked: No
Reserved for future use.
See also
Variables table
Responses2 table
OtherData2 table
ResponseSerial table
SchemaVersion table
Responses table
OtherID table
LevelResponseX table
LevelOtherDataX table
LevelSerial table
Categories table
CategoriesLookup table
Relational MR Database CDSC schema