dbTable: EQUIPMENT_CHANGE - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table tracks equipment installations, change outs, and removals from vessels.
TABLE DEFINITIONS
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
EQUIPMENT_CHANGE_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
START_INVENTORY_ID | int | NULL | YES | MUL | NULL | select,insert,update,references | The piece of equipment initially on the vessel. NULL if new install. | |
END_INVENTORY_ID | int | NULL | YES | MUL | NULL | select,insert,update,references | The piece of equipment installed on the vessel. NULL if equipment removed. | |
VISIT_ID | int | NULL | YES | MUL | NULL | select,insert,update,references | Visit ID number for when the install / removal / swap occurred |