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
The unique identifier for the variable.
Key: Yes
Column type: Integer. The column type is Smallint in the RDB DSC schema.
Linked: No
VariableName
The variable name.
Key: No
Column type: Nvarchar(255)
Linked: No
Type
The variable type. These types match the values for the MDM data type enumeration: mtNone, mtDouble, mtLong, mtText, mtCategorical, mtObject, and mtDate.
Key: No
Column type: Smallint
Linked: No
Project
The project identifier for the variable. This is set to NULL for the default project.
Key: No
Column type: Nvarchar(255)
Linked: No
ParentID
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.
Key: No
Column type: Smallint
Linked: Variables.VariableID
See also