 |
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 | codingSchemeSupportedAttrib Changes |
|---|---|
uri | renamed from urn |
...
codingSchemeProp
Column Name | Changes codingSchemeProp |
|---|---|
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 entityType |
|---|---|
codingSchemeName | added (new table) |
entityCodeNamespace | added |
...
entityCode | added |
...
entityType | added |
entityProperty
...
Column Name | entityProperty Changes |
|---|---|
codingSchemeName | renamed from codingSchemeId |
...
entityType | removed |
...
entityCode | renamed from entityId |
...
format | removed |
...
entityCodeNamespace | added, primaryKey |
...
isActive | added |
...
entityPropertyLink
Column Name | Changes entityPropertyLink |
|---|---|
codingSchemeName | renamed from codingSchemeId |
...
entityType | removed |
...
entityCodeNamespace | added, primaryKey |
entityPropertyMultiAttrib
...
Column Name | entityPropertyMultiAttrib 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 | entityAssnsToEQuals Changes |
|---|---|
codingSchemeName | renamed from codingSchemeId |
entityAssnsToData
...
Column Name | entityAssnsToData 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 entityAssnsToDQuals |
|---|---|
codingSchemeName | renamed from codingSchemeId |
entityAssnsToEntityTr
...
Column Name | entityAssnsToEntityTr 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 |
| Scrollbar | ||
|---|---|---|
|
