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