Data Model > Available DSCs > Relational MR database (RDB) CDSC > Relational MR Database CDSC schema > Variables table
 
Variables table
The Variables table stores the names and data types of all of the variables in the survey. The Variables table is used in both the RDB DSC 2 and RDB DSC schemas.
Columns
VariableID
Key: Yes
Column type: Integer
Linked: No
The unique identifier for the variable. Note that the column type is Smallint in the RDB DSC schema.
VariableName
Key: No
Column type: Nvarchar(255)
Linked: No
The variable name.
Type
Key: No
Column type: Smallint
Linked: No
The variable type. These types match the values for the MDM data type enumeration: mtNone, mtDouble, mtLong, mtText, mtCategorical, mtObject, and mtDate.
Project
Key: No
Column type: Nvarchar(255)
Linked: No
The project identifier for the variable. This is set to NULL for the default project.
ParentID
Key: No
Column type: Smallint
Linked: Variables.VariableID
A link to the parent variable for a hierarchical variable. This is set to NULL for variables that exist at the root level. It is not possible to delete variables that are still referenced as a parent.
See also
Responses2 table
OtherData2 table
ResponseSerial table
SchemaVersion table
Responses table
OtherData table
OtherID table
LevelResponseX table
LevelOtherDataX table
LevelSerial table
Categories table
CategoriesLookup table
Relational MR Database CDSC schema