Page History

{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}