Tables and Columns

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
account This field is system set with user account info for update and delete privileges. VARCHAR2 (16)
alt_name_id Autogenerated Unique Number. NUMBER (6)
DBE_TIME Database Entry Time - System set. DATE
DBU_TIME Database Update Time - System set. DATE
alt_name A geographically descriptive name for the gauging station. The province doesn't have to be included in this field. VARCHAR2 (32) Mandatory