Difference between revisions of "Table differences between migrated and non-migrated databases"
From IMSMA Wiki
(Created page with "If a database has been migrated from Legacy (at least from 2010) then some columns have been changed. {| class="wikitable" | align="center" style="background:#f0f0f0;"|'''Tabl...") |
|||
Line 5: | Line 5: | ||
| align="center" style="background:#f0f0f0;"|'''Initial 6.0 DB''' | | align="center" style="background:#f0f0f0;"|'''Initial 6.0 DB''' | ||
| align="center" style="background:#f0f0f0;"|'''Migrated DB''' | | align="center" style="background:#f0f0f0;"|'''Migrated DB''' | ||
− | |||
− | |||
|- | |- | ||
| hazard||medicalfacilitylevel1||varchar(50)||text | | hazard||medicalfacilitylevel1||varchar(50)||text | ||
Line 31: | Line 29: | ||
|- | |- | ||
| hazreducinfoversion||teamlocation||varchar(50)||text | | hazreducinfoversion||teamlocation||varchar(50)||text | ||
+ | |- | ||
+ | | translation||translation||varchar(250)||text | ||
|} | |} | ||
Line 37: | Line 37: | ||
| align="center" style="background:#f0f0f0;"|'''Table''' | | align="center" style="background:#f0f0f0;"|'''Table''' | ||
| align="center" style="background:#f0f0f0;"|'''Column''' | | align="center" style="background:#f0f0f0;"|'''Column''' | ||
+ | |- | ||
+ | | fieldreport||reportedby | ||
|- | |- | ||
| geopoint||pointdescription | | geopoint||pointdescription | ||
− | |||
− | |||
|- | |- | ||
| hazreduc||qacomments | | hazreduc||qacomments | ||
|- | |- | ||
− | | | + | | hazreducinfoversion||qacomments |
|- | |- | ||
| hazreduc||vistor | | hazreduc||vistor | ||
− | + | |- | |
+ | | hazreducinfoversion||vistor | ||
+ | |- | ||
+ | | impactsurvey||minehistorycomments | ||
+ | |- | ||
+ | | impactsurveyversion||minehistorycomments | ||
|} | |} | ||
{{NavBox Hub}} | {{NavBox Hub}} | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:NAA]] | [[Category:NAA]] |
Revision as of 21:29, 1 August 2015
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 |
hazardinfoversion | medicalfacilitylevel1 | varchar(50) | text |
hazard | medicalfacilitylevel2 | varchar(50) | text |
hazardinfoversion | medicalfacilitylevel2 | varchar(50) | text |
hazreduc | medicalfacilitylevel1 | varchar(50) | text |
hazreducinfoversion | medicalfacilitylevel1 | varchar(50) | text |
hazreduc | medicalfacilitylevel2 | varchar(50) | text |
hazreducinfoversion | medicalfacilitylevel2 | varchar(50) | text |
hazreduc | teamid | varchar(38) | varchar(50) |
hazreducinfoversion | teamid | varchar(38) | varchar(50) |
hazreduc | teamlocation | varchar(50) | text |
hazreducinfoversion | 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 |
fieldreport | reportedby |
geopoint | pointdescription |
hazreduc | qacomments |
hazreducinfoversion | qacomments |
hazreduc | vistor |
hazreducinfoversion | vistor |
impactsurvey | minehistorycomments |
impactsurveyversion | minehistorycomments |