Difference between revisions of "Table differences between migrated and non-migrated databases"
From IMSMA Wiki
Line 7: | Line 7: | ||
| align="center" style="background:#f0f0f0;"|'''Migrated DB''' | | align="center" style="background:#f0f0f0;"|'''Migrated DB''' | ||
|- | |- | ||
− | | hazard | + | | hazard || medicalfacilitylevel1 || varchar(50)|| text |
|- | |- | ||
− | | hazard | + | | hazard || medicalfacilitylevel2 || varchar(50)|| text |
|- | |- | ||
− | | hazreduc | + | | hazreduc || medicalfacilitylevel1 || varchar(50)|| text |
|- | |- | ||
− | | hazreduc | + | | hazreduc || medicalfacilitylevel2 || varchar(50)|| text |
|- | |- | ||
− | | hazreduc | + | | hazreduc || teamid ||varchar(38) || varchar(50) |
|- | |- | ||
− | | hazreduc | + | | hazreduc || teamlocation || varchar(50) || text |
|- | |- | ||
| translation || translation || varchar(250 )|| text | | translation || translation || varchar(250 )|| text | ||
Line 27: | Line 27: | ||
| 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;"|'''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 || text | + | | fieldreport||reportedby || text || tinytext || text || text |
|- | |- | ||
− | | geopoint||pointdescription || tinytext | + | | geopoint||pointdescription || tinytext || text || text || text |
|- | |- | ||
− | | hazreduc | + | | hazreduc ||qacomments || tinytext || text || text || text |
|- | |- | ||
− | | hazreduc | + | | hazreduc ||vistor || tinytext || text || text || text |
|- | |- | ||
− | | impactsurvey | + | | impactsurvey ||minehistorycomments || tinytext || text || text || text |
|} | |} | ||
− | {{NavBox | + | {{NavBox Data Dictionary}} |
− | + | ||
[[Category:NAA]] | [[Category:NAA]] |
Latest revision as of 18:48, 10 August 2016
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 |
|