Responses table
The Responses table stores responses to categorical and integer questions, and for responses to questions of other data types, a reference (
OtherID) that identifies an entry in the
OtherData table. The Responses table is used only in the RDB DSC schema.
Columns
Serial
The identifier for the respondent associated with this response. The identifier is unique within each project within the database. The Serial column stores the Respondent.Serial system variable. When a record is written, Relational MR Database CDSC generates an error if the serial number already exists for the same project within the database, and generates a new serial number if Respondent.Serial does not exist or is blank.
Key: Yes
Column type: Integer
Linked: No
VariableID
The ID of the variable to which this response corresponds.
Key: Yes
Column type: Smallint
Linked: Variables.VariableID
OrderChosen
For categorical variables, the order in which responses are chosen. The value is auto-incrementing and provides a unique primary key. No conclusions should be drawn from the numbers in this column (the order is not consistently assigned). The order is indexed from 0. For non-categorical responses, this should always be set to 0.
Key: Yes
Column type: Smallint
Linked: No
Response
The actual response for responses of type Categorical and Long.
Key: No
Column type: Integer
Linked: No
OtherID
The ID of the record in the OtherData table that holds the Real, Text, Date, or Object data associated with this response. This is set to NULL for Categorical and Long type responses.
Key: No
Column type: Integer
Linked: OtherData.OtherID
Status
Indicates the status of the response. This always has a value of 0, which indicates that the question was asked, answered, and was on path.
Key: No
Column type: Integer
Linked: No
See also