dbTable: VESSEL_PROGRAM

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)

MYSQL CODE