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
Key: Yes
Column type: Integer
Linked: No
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.
VariableID
Key : Yes
Column type: Smallint
Linked: Variables.VariableID
The ID of the variable to which this response corresponds.
OrderChosen
Key: Yes
Column type: Smallint
Linked: No
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.
Response
Key: No
Column type: Integer
Linked: No
The actual response for responses of type Categorical and Long.
OtherID
Key: No
Column type: Integer
Linked: OtherData.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.
Status
Key : No
Column type: Integer
Linked: No
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. In future versions of the UNICOM Intelligence Data Model, it is planned to extend the possible values; for example, so you can distinguish between responses that were on and off path.
See also