dbTable: VESSEL_VISIT_LOG

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

MYSQL CODE