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 |
|
isActive |
added |
|
releaseURI |
added |
|
firstRelease |
removed |
|
modifiedInRelease |
removed |
|
deprecated |
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 |
|
firstRelease |
removed |
|
modifiedInRelease |
removed |
|
deprecated |
removed |
|
isInferred |
removed |
entityType |
codingSchemeName |
added |
(new table) |
entityCodeNamespace |
added |
|
entityCode |
added |
|
entityType |
added |
entityProperty |
codingSchemeName |
renamed from codingSchemeId |
|
entityType |
removed |
|
entityCode |
renamed from entityId |
|
format |
removed |
|
entityCodeNamespace |
added, primaryKey |
|
isActive |
added |
entityPropertyLink |
codingSchemeName |
renamed from codingSchemeId |
|
entityType |
removed |
|
entityCodeNamespace |
added, primaryKey |
entityPropertyMultiAttrib |
codingSchemeName |
renamed from codingSchemeId |
|
entityType |
removed |
|
entityCodeNamespace |
added, primaryKey |
|
qualType |
added |
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 |
|
associationName |
added |
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 |
|
sourceType |
removed |
|
targetEntityCodeNamespace |
renamed from targetCodingSchemeId |
|
targetEntityCode |
renamed from targetId |
|
targetType |
removed |
|
firstRelease |
removed |
|
modifiedInRelease |
removed |
|
deprecated |
removed |
|
associationInstanceId |
renamed from multiAttributesKey |
|
isDefining |
added |
|
isInferred |
added |
|
isActive |
added |
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 |
|
isDefining |
added |
|
isInferred |
added |
|
isActive |
added |
|
firstRelease |
removed |
|
modifiedInRelease |
removed |
|
deprecated |
removed |
|
dataId |
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 |
|
sourceType |
removed |
|
targetEntityCodeNamespace |
renamed from targetCodingSchemeId |
|
targetEntityCode |
renamed from targetId |
nciThesHist table
Table Name |
Column Name |
Changes |
---|---|---|
nciThesHist |
entityCode |
renamed from entityId |