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 codingScheme | |
---|---|---|
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 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 (new table)
Column Name | Changes | |
---|---|---|
codingSchemeName | added | |
(new table) | 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 relation |
---|---|
codingSchemeName | renamed from codingSchemeId |
containerName | renamed from containerDC |
association table
Table
...
name is association.
Column Name | Changes | |
---|---|---|
association | codingSchemeName | renamed from codingSchemeId |
containerName | renamed from containerDC | |
| entityCode | renamed from id |
| associationName | added |
entityAssnsTo tables
...
entityAssnsToEntity
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
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 nciThesHist |
---|---|
entityCode | renamed from entityId |
...