Page History
Wiki Markup |
---|
{scrollbar:icons=false} h1. {page-info: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} |