dbTable: VESSELS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table stores information about vessels involved in the program, who owns and operates them, where they are based, and what fisheries they participate in.
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| VESSEL_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| EMOLT_NUM | int | NULL | YES | NULL | select,insert,update,references | These numbers have been used to identify vessels within eMOLT data processing scripts but will likely be phased out over time | ||
| VESSEL_NAME | varchar(50) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | This field is not unique and should not be used exclusively to identify vessels | ||
| PORT | varchar(6) | utf8mb4_0900_ai_ci | NO | MUL | NULL | select,insert,update,references | This field is the standard PORT code used by NEFSC / ACCSP available at FVTR.FVTR_PORTS@sole | |
| OWNER | int | NULL | YES | MUL | NULL | select,insert,update,references | This field references CONTACTS.CONTACT_ID and identifies the owner of a vessel | |
| OPERATOR | int | NULL | YES | MUL | NULL | select,insert,update,references | This field references CONTACTS.CONTACT_ID and identifies the operator of a vessel | |
| PRIMARY_CONTACT | int | NULL | NO | MUL | NULL | select,insert,update,references | This field references CONTACTS.CONTACT_ID and identifies the best contact person for a vessel which could be the owner, the operator, or a fleet manager, Study Fleet tech, etc. | |
| TECHNICAL_CONTACT | int | NULL | NO | MUL | NULL | select,insert,update,references | This field references CONTACTS.CONTACT_ID and identifies the best tech support person for a vessel which could be the owner, the operator, or a fleet manager, Study Fleet tech, etc. | |
| PRIMARY_GEAR | varchar(6) | utf8mb4_0900_ai_ci | YES | MUL | NULL | select,insert,update,references | This field is the type of gear fished by the vessel most often and is the concatenation of ACCSP and VTR gear codes used to map gears between the two data sets available at FVTR.FVTR_GEAR_CODES@sole | |
| PRIMARY_FISHERY | varchar(50) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | The primary fishery prosecuted by the vessel | ||
| HULL_NUMBER | varchar(30) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | The vessel number issued by the federal or state government |