Fisheries and Oceans Canada
www.dfo-mpo.gc.ca
Home > Science > Data and Products > TCWL > Data Archive > Field and Format Descriptions > MICROFILM_DATA
MICROFILM_DATA
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) |