Page History
...
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 |
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
...
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 |
...