Developer Documentation Library > 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
The unique identifier for the record in the OtherData table.
Key: Yes
Column type: Integer
Linked: No
RealVal
The value for Real type responses.
Key: No
Column type: Float
Linked: No
DateVal
The value for Date type responses.
Key: No
Column type: Datetime
Linked: No
TextVal
The value for Text type responses. The limit is the SQL Server limit of 8000 bytes (4000 characters).
Key: No
Column type: Nvarchar
Linked: No
ObjectVal
The value for Object type responses. The actual database type for this column varies. In SQL Server, it is an image column.
Key: No
Column type: Image
Linked: No
ExtOtherID
Reserved for future use.
Key: No
Column type: Integer
Linked: No
ParentOtherID
Reserved for future use.
Key: No
Column type: Integer
Linked: No
See also
Variables table
Responses2 table
OtherData2 table
ResponseSerial table
SchemaVersion table in the RDB CDSC
Responses table
OtherID table
LevelResponseX table
LevelOtherDataX table
LevelSerial table
Categories table
CategoriesLookup table
Relational MR Database CDSC schema