NIH | National Cancer Institute | NCI Wiki  

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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

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

...

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

...