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)