S Provinces table: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
m New page: The '''S Provinces''' table contains the possible values for the Province Field field on the PDA and in the CCMDB.mdb. == to do before de-stubbing == * explain data structure ...
 
mNo edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
The '''S Provinces''' table contains the possible values for the [[Province Field]] field on the PDA and in the [[CCMDB.mdb]].  
{{DISPLAYTITLE:s_Provinces table}}The '''s_Provinces''' table contains the possible values for the [[Province field]].  


== to do before de-stubbing ==
== Structure ==
* explain data structure
* code
* Province
* active - logical delete
* sorter - allows MB to sort to top


== Log ==
* 2014/10/22 - added column "active", made old entry Neufoundland NF inactive


== Related articles ==
{{Related Articles}}


{{stub}}
[[Category: Data structure]]
[[Category: Data structure]]

Latest revision as of 15:14, 2023 May 17

The s_Provinces table contains the possible values for the Province field.

Structure

  • code
  • Province
  • active - logical delete
  • sorter - allows MB to sort to top

Log

  • 2014/10/22 - added column "active", made old entry Neufoundland NF inactive

Related articles

Related articles: