Difference between revisions of "Table differences between migrated and non-migrated databases"

From IMSMA Wiki
Jump to: navigation, search
 
(One intermediate revision by the same user not shown)
Line 7: Line 7:
 
| align="center" style="background:#f0f0f0;"|'''Migrated DB'''
 
| align="center" style="background:#f0f0f0;"|'''Migrated DB'''
 
|-
 
|-
| hazard & hazardinfoversion || medicalfacilitylevel1 || varchar(50)|| text
+
| hazard || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
| hazard & hazardinfoversion || medicalfacilitylevel2 || varchar(50)|| text
+
| hazard || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
| hazreduc & hazreducinfoversion || medicalfacilitylevel1 || varchar(50)|| text
+
| hazreduc || medicalfacilitylevel1 || varchar(50)|| text
 
|-
 
|-
| hazreduc & hazreducinfoversion || medicalfacilitylevel2 || varchar(50)|| text
+
| hazreduc || medicalfacilitylevel2 || varchar(50)|| text
 
|-
 
|-
| hazreduc & hazreducinfoversion || teamid ||varchar(38) || varchar(50)
+
| hazreduc || teamid ||varchar(38) || varchar(50)
 
|-
 
|-
| hazreduc & hazreducinfoversion || teamlocation || varchar(50) || text
+
| hazreduc || teamlocation || varchar(50) || text
 
|-
 
|-
 
| translation || translation || varchar(250 )|| text
 
| translation || translation || varchar(250 )|| text
Line 26: Line 26:
 
| align="center" style="background:#f0f0f0;"|'''Table'''
 
| align="center" style="background:#f0f0f0;"|'''Table'''
 
| align="center" style="background:#f0f0f0;"|'''Column'''
 
| align="center" style="background:#f0f0f0;"|'''Column'''
 +
| align="center" style="background:#f0f0f0;"|'''Initial 5.x DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Migrated 5.x DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Initial 6.0 DB'''
 +
| align="center" style="background:#f0f0f0;"|'''Upgraded migrated DB'''
 
|-
 
|-
| fieldreport||reportedby
+
| fieldreport||reportedby || text || tinytext || text || text
 
|-
 
|-
| geopoint||pointdescription
+
| geopoint||pointdescription || tinytext || text || text || text
 
|-
 
|-
| hazreduc & hazreducinfoversion||qacomments
+
| hazreduc ||qacomments || tinytext || text || text || text
 
|-
 
|-
| hazreduc & hazreducinfoversion||vistor
+
| hazreduc ||vistor || tinytext || text || text || text
 
|-
 
|-
| impactsurvey & impactsurveyversion||minehistorycomments
+
| impactsurvey ||minehistorycomments || tinytext || text || text || text
  
 
|}
 
|}
{{NavBox Hub}}
+
{{NavBox Data Dictionary}}
[[Category:NoPublic]]
+
 
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 17:48, 10 August 2016

Warning.jpg Depending on if a database is originally created with 5.x or 6.0 there are also differences in Foreign keys' CASCADE on delete.

If a database has been migrated from Legacy (at least from 2010) then some columns have been changed.

Table Column Initial 6.0 DB Migrated DB
hazard medicalfacilitylevel1 varchar(50) text
hazard medicalfacilitylevel2 varchar(50) text
hazreduc medicalfacilitylevel1 varchar(50) text
hazreduc medicalfacilitylevel2 varchar(50) text
hazreduc teamid varchar(38) varchar(50)
hazreduc teamlocation varchar(50) text
translation translation varchar(250 ) text

I can see in the migration scripts that previously also the following columns were different.

Table Column Initial 5.x DB Migrated 5.x DB Initial 6.0 DB Upgraded migrated DB
fieldreport reportedby text tinytext text text
geopoint pointdescription tinytext text text text
hazreduc qacomments tinytext text text text
hazreduc vistor tinytext text text text
impactsurvey minehistorycomments tinytext text text text