dbTable: VESSEL_VISIT_LOG - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table records visits of technicians to ports to service eMOLT systems or install new systems.
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| VISIT_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. Which vessel was visited. | |
| VISIT_DATE | datetime | NULL | NO | NULL | select,insert,update,references | The date when the vessel was visited. | ||
| LEAD_TECH | int | NULL | NO | MUL | NULL | select,insert,update,references | Who was the senior technician on site during the visit? References CONTACTS.CONTACT_ID | |
| PORT | varchar(6) | utf8mb4_0900_ai_ci | NO | MUL | NULL | select,insert,update,references | Where the visit took place | |
| VISIT_NOTES | text | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Any additional notes about the visit |