 |
|||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||
Tables and Columns
NRCAN_ELEVATIONS
| station_number | A six-digit number normally referred to as the "MEDS" station number. Presently "MEDS" station numbers are only 5 digits, the six digit field will allow for future expansion. | NUMBER (6) Foreign Key |
| benchmark_number | A 16-character field to indicate the identification stamped on the physical monument. | VARCHAR2 (16) Foreign Key Mandatory |
| unique_number | An 8 character NRCan style unique identifier for the monument. Note: Although the year identifier in the Unique Number is only 2 digits, the century is covered by the character used to identify the province. i.e. the province identifier will change for BMs installed in the year 2000. | VARCHAR2 (8) Mandatory |
| nrcan_elevations_id | An autogenerated number identifying a unique NRCAN elevation. Note: Although the year identifier in the Unique Number is only 2 digits, the century is covered by the character used to identify the province. i.e. the province identifier will change for BMs installed in the year 2000. | NUMBER (6) |
| account | This field is system set with user account info for update and delete privileges. | VARCHAR2 (16) |
| DBE_TIME | Database Entry Time - System set. | DATE |
| DBU_TIME | Database Update Time - System set. | DATE |
| cgvd28_elevation | cgvd28 elevation. | NUMBER (8,3) |
| navd88_elevation | navd88 elevation. | NUMBER (8,3) |
| xorder | order. | VARCHAR2 (16) |
| method | method. | VARCHAR2 (16) |
| published | year published. | NUMBER (4) |
| Last Updated: 2009-09-10 |
▲ Site Map |
Webmaster Important Notices |