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
codingScheme
Column Name |
Changes |
|---|---|
formalName |
Can be null |
defaultLangauge |
Can be null |
codingSchemeURI |
renamed from registeredName |
isActive |
added |
releaseURI |
added |
firstRelease |
removed |
modifiedInRelease |
removed |
deprecated |
removed |
codingSchemeSupportedAttrib
Column Name |
Changes |
|---|---|
uri |
renamed from urn |
codingSchemeProp
Column Name |
Changes |
|---|---|
isActive |
added |
entity tables
entity (table renamed from concept)
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityCodeNamespace |
added, primaryKey |
entityCode |
renamed from id |
firstRelease |
removed |
modifiedInRelease |
removed |
deprecated |
removed |
isInferred |
removed |
entityType (new table)
Column Name |
Changes |
|---|---|
codingSchemeName |
added |
entityCodeNamespace |
added |
entityCode |
added |
entityType |
added |
entityProperty
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityType |
removed |
entityCode |
renamed from entityId |
format |
removed |
entityCodeNamespace |
added, primaryKey |
isActive |
added |
entityPropertyLink
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityType |
removed |
entityCodeNamespace |
added, primaryKey |
entityPropertyMultiAttrib
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityType |
removed |
entityCodeNamespace |
added, primaryKey |
qualType |
added |
relation table
Table name is relation.
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
association table
Table name is association.
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
containerName |
renamed from containerDC |
entityCode |
renamed from id |
associationName |
added |
entityAssnsTo tables
entityAssnsToEntity
Column Name |
Changes |
|---|---|
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
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityAssnsToData
Column Name |
Changes |
|---|---|
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
Column Name |
Changes |
|---|---|
codingSchemeName |
renamed from codingSchemeId |
entityAssnsToEntityTr
Column Name |
Changes |
|---|---|
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 is nciThesHist.
Column Name |
Changes |
|---|---|
entityCode |
renamed from entityId |
