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
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 |
...