NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
{{Warning | 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.
{| class="wikitable"
| align="center" style="background:#f0f0f0;"|'''Migrated DB'''
|-
| translationhazard ||translationmedicalfacilitylevel1 ||varchar(25050)||text
|-
| hazard ||medicalfacilitylevel1medicalfacilitylevel2 ||varchar(50)||text
|-
| hazardinfoversionhazreduc ||medicalfacilitylevel1||varchar(50)||text
|-
| hazardhazreduc ||medicalfacilitylevel2||varchar(50)||text
|-
| hazardinfoversionhazreduc ||medicalfacilitylevel2teamid ||varchar(5038)||textvarchar(50)
|-
| hazreduc ||medicalfacilitylevel1teamlocation ||varchar(50)||text
|-
| hazreducinfoversiontranslation ||medicalfacilitylevel1translation ||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(50250 )||text
|}
| align="center" style="background:#f0f0f0;"|'''Table'''
| 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'''
|-
| geopointfieldreport||pointdescriptionreportedby || text || tinytext || text || text
|-
| impactsurveygeopoint||minehistorycommentspointdescription || tinytext || text || text || text
|-
| hazreduc||qacomments|| tinytext || text || text || text
|-
| fieldreporthazreduc ||reportedbyvistor || tinytext || text || text || text
|-
| hazreducimpactsurvey ||vistorminehistorycomments || tinytext || text || text || text
|}
{{NavBox HubData Dictionary}}[[Category:NoPublic]]
[[Category:NAA]]
