NIH | National Cancer Institute | NCI Wiki  

Contents of this Page

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

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