Page History
Wiki Markup |
---|
{scrollbar:icons=false}
h1. { |
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.
Column Name | Changes |
---|---|
entityCode | renamed from entityId |
Wiki Markup |
---|
:title}
{panel:title=Contents of this Page}
{toc:minLevel=2}
{panel}
h2. Introduction
This document is a section of the [Migration Guide|LexEVS 5.x Migration Guide].
h2. 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|LexGrid Model and Schema].
h2. LexEVS Database Enhancements: Details
h3. codingScheme Tables
h4. 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 |
h4. codingSchemeSupportedAttrib
|| Column Name || Changes ||
| uri | renamed from urn |
h4.codingSchemeProp
|| Column Name || Changes ||
| isActive | added |
h3. entity tables
h4. 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 |
h4. entityType (new table)
|| Column Name || Changes ||
| codingSchemeName | added |
| entityCodeNamespace | added |
| entityCode | added |
| entityType | added |
h4. entityProperty
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
| entityType | removed |
| entityCode | renamed from entityId |
| format | removed |
| entityCodeNamespace | added, primaryKey |
| isActive | added |
h4. entityPropertyLink
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
| entityType | removed |
| entityCodeNamespace | added, primaryKey |
h4. entityPropertyMultiAttrib
|| Column Name || Changes |
| codingSchemeName | renamed from codingSchemeId |
| entityType | removed |
| entityCodeNamespace | added, primaryKey |
| qualType | added |
h3. relation table
Table name is relation.
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
| containerName | renamed from containerDC |
h3. association table
Table name is association.
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
| containerName | renamed from containerDC |
| entityCode | renamed from id |
| associationName | added |
h3. entityAssnsTo tables
h4. 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 |
h4. entityAssnsToEQuals
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
h4. 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 |
h4. entityAssnsToDQuals
|| Column Name || Changes ||
| codingSchemeName | renamed from codingSchemeId |
h4. 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 |
h3. nciThesHist table
Table name is nciThesHist.
|| Column Name || Changes ||
| entityCode | renamed from entityId |
\\
{scrollbar:icons=false} |