Page History
Scrollbar | ||
---|---|---|
|
Page info | ||||
---|---|---|---|---|
|
Panel | ||||
---|---|---|---|---|
| ||||
|
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.
...