dbTable: VESSEL_PROGRAM - GMaynard1/emolt_serverside GitHub Wiki
Purpose
This table stores information tying vessels to specific programs. A single vessel may participate in multiple programs over time.
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| VP_RECORD_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| VESSEL_ID | int | NULL | NO | MUL | NULL | select,insert,update,references | References VESSELS.VESSEL_ID | |
| PROGRAM_ID | int | NULL | NO | MUL | NULL | select,insert,update,references | References PROGRAMS.PROGRAM_ID | |
| VP_START_DATE | datetime | NULL | NO | NULL | select,insert,update,references | The approximate date when the vessel joined a particular program | ||
| VP_END_DATE | datetime | NULL | YES | NULL | select,insert,update,references | The approximaate date when the vessel left a particular program (NULL for still active) |