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