generated from NEFSC/NEFSC-Template
-
Notifications
You must be signed in to change notification settings - Fork 1
dbTable: PORTS
George Maynard edited this page Aug 2, 2022
·
1 revision
This table is primarily read in from FVTR.FVTR_PORTS@sole, with the exception of lat/lon and region which much be manually added for each port.
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
FIPS_STATE_CODE | varchar(2) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
FIPS_PLACE_CODE | varchar(5) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
FIPS_COUNTY_CODE | varchar(3) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
PORT | varchar(6) | utf8mb4_0900_ai_ci | NO | PRI | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | |
PORT_NAME | varchar(60) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
STATE_POSTAL | varchar(2) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
COUNTY_NAME | varchar(30) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Comes in from FVTR.FVTR_PORTS@sole | ||
LATITUDE | decimal(10,5) | NULL | YES | NULL | select,insert,update,references | Port latitude in decimal degrees. This number is manually generated for the purposes of eMOLT. | ||
LONGITUDE | decimal(10,5) | NULL | YES | NULL | select,insert,update,references | Port longitude in decimal degrees. This number is manually generated for the purposes of eMOLT. | ||
EMOLT_REGION | set('New Jersey','Rhode Island','New Bedford','Cape Cod','North Shore','Maine','New York','Alaska','Canada') | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Administrative regions of eMOLT (i.e., where support staff exist) |