Changes to the data model for Oracle
Tables
The following new tables have been added:
- ID_REFERENCE
Indexes
The following new indexes have been added on the ID_REFERENCE table:
- CC_ID_UI on columns(OBJ_ID, CATEGORY, KEY)
- CC_ID_VAL on columns(VALUE, CATEGORY, KEY, CREATED, OBJ_ID)
Columns
The following existing table columns have been altered:
- The CLASSIFICATION.CODE column changed from CHAR(40) to CHAR(150)
- The H_CLASSIFICATION.CODE column changed from CHAR(40) to CHAR(150)