dbTable: PORTS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
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.
TABLE DEFINITIONS
| 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) |