Introduction
This document is a section of the Migration Guide.
LexEVS database enhancements: overview
To support the LexEVS 2009/01 Model, numerous changes to the database were necessary. Although the database is not exposed to the user, it is important to take note of the changes. A 2009/01 sample database (Microsoft Access format) can be found at the model and scheme page.
LexEVS database enhancements: details
codingScheme* tables
Table Name |
Column Name |
Changes |
codingScheme |
formalName |
Can be null |
defaultLangauge |
Can be null |
|
codingSchemeURI |
renamed from registeredName |
|
modifiedInRelease |
removed |
|
codingSchemeSupportedAttrib |
uri |
renamed from urn |
codingSchemeProp |
isActive |
added |
entity* tables
Table Name |
Column Name |
Changes |
entity |
codingSchemeName |
renamed from codingSchemeId |
(table renamed from concept) |
entityCodeNamespace |
added, primaryKey |
entityCode |
renamed from id |
|
modifiedInRelease |
removed |
|
entityType |
codingSchemeName |
added |
(new table) |
entityCodeNamespace |
added |
entityProperty |
codingSchemeName |
renamed from codingSchemeId |
entityCode |
renamed from entityId |
|
entityCodeNamespace |
added, primaryKey |
|
entityPropertyLink |
codingSchemeName |
renamed from codingSchemeId |
entityCodeNamespace |
added, primaryKey |
|
entityPropertyMultiAttrib |
codingSchemeName |
renamed from codingSchemeId |
entityCodeNamespace |
added, primaryKey |
|
relation table
Table Name |
Column Name |
Changes |
relation |
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
|
association table
Table Name |
Column Name |
Changes |
association |
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
|
entityCode |
renamed from id |
|
entityAssnsTo* tables
Table Name |
Column Name |
Changes |
entityAssnsToEntity |
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
|
entityCode |
renamed from associationId |
|
sourceEntityCodeNamespace |
renamed from sourceCodingSchemeId |
|
sourceEntityCode |
renamed from sourceId |
|
targetEntityCodeNamespace |
renamed from targetCodingSchemeId |
|
targetEntityCode |
renamed from targetId |
|
modifiedInRelease |
removed |
|
associationInstanceId |
renamed from multiAttributesKey |
|
entityAssnsToEQuals |
codingSchemeName |
renamed from codingSchemeId |
entityAssnsToData |
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
|
entityCode |
renamed from associationId |
|
sourceEntityCodeNamespace |
renamed from sourceCodingSchemeId |
|
sourceEntityCode |
renamed from sourceId |
|
associationInstanceId |
renamed from multiAttributesKey |
|
modifiedInRelease |
removed |
|
entityAssnsToDQuals |
codingSchemeName |
renamed from codingSchemeId |
entityAssnsToEntityTr |
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
|
entityCode |
renamed from associationId |
|
sourceEntityCodeNamespace |
renamed from sourceCodingSchemeId |
|
sourceEntityCode |
renamed from sourceId |
|
targetEntityCodeNamespace |
renamed from targetCodingSchemeId |
|
targetEntityCode |
renamed from targetId |
|
nciThesHist table
Table Name |
Column Name |
Changes |
nciThesHist |
entityCode |
renamed from entityId |