Tables and Columns

md_id A one to six digit number identifying a specific row of microfilm data NUMBER (6) Primary Key
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) Mandatory
account This field is system set with user account info for update and delete privileges. VARCHAR2 (16)
year   NUMBER (4) Mandatory
period_of_record   VARCHAR2 (255)
film_number   VARCHAR2 (20)
counter   VARCHAR2 (50)
location_tabulated_data   VARCHAR2(32)