Data Model > Available DSCs > Relational MR database (RDB) CDSC > Relational MR Database CDSC schema > LevelSerial table
 
LevelSerial table
The LevelSerial table stores the maximum serial number for each unexpanded loop variable in use for each database project. The Variables table is used in both the RDB DSC 2 and RDB DSC schemas.
Columns
TableVariableID
Key: Yes
Column type: Integer
Holds the VariableID of the Unexpanded loop variable for the project.
MaxSerialID
Key: No
Column type: Integer
Holds the current maximum serial number in use.
UNICOM Intelligence Data Model uses the rdb_ReserveLevelSerial stored procedure to retrieve the next serial number for each unexpanded loop variable in use by each project. rdb_ReserveLevelSerial locks the entire Responses table to find the maximum value of the serial number, increments it, inserts the new serial number into the LevelResponsesX table, and returns the number to the client. For more information, see Stored procedures.
See also
Variables table
Responses2 table
OtherData2 table
ResponseSerial table
SchemaVersion table
Responses table
OtherData table
OtherID table
LevelResponseX table
LevelOtherDataX table
Categories table
CategoriesLookup table
Relational MR Database CDSC schema