dbTable: EQUIPMENT_CHANGE

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

MYSQL CODE