SchemaVersion table in the RDB CDSC
The SchemaVersion table is a single-row table that records version information about the UNICOM Intelligence Data Model components, to facilitate future enhancements to the schema. The SchemaVersion table is used in both the RDB DSC 2 and RDB DSC schemas.
Columns
CurVersionMajor
The current major UNICOM Intelligence Data Model version number. For example, for UNICOM Intelligence Data Model 4.5, this is 4.
Column type: Smallint
CurVersionMinor
The current minor UNICOM Intelligence Data Model version number. For example, for UNICOM Intelligence Data Model 4.5, this is 5.
Column type: Smallint
CurVersionComponent
The current version number of the Relational MR Database CDSC component (mrRdbDsc.dll).
Column type: Smallint
CurVersionBuild
The current UNICOM Intelligence Data Model build number.
Column type: Smallint
MinVersionMajor
The minimum major UNICOM Intelligence Data Model version number required to operate on the database.
Column type: Smallint
MinVersionMinor
The minimum minor UNICOM Intelligence Data Model version number required to operate on the database.
Column type: Smallint
MinVersionComponent
The minimum version number of the Relational MR Database CDSC component required to operate on the database.
Column type: Smallint
MinVersionBuild
The minimum UNICOM Intelligence Data Model build number required to operate on the database.
Column type: Smallint
Notes
The Relational MR Database CDSC updates the minimum version details in the SchemaVersion table before updating the database schema. Before Relational MR Database CDSC subsequently attempts to update the database, it checks the minimum version details in the SchemaVersion table. If Relational MR Database CDSC is the same or a later version, it inserts its version details in the current version columns.
See also