dbTable: PROGRAMS

PURPOSE

This table is used to explain which flavor(s) of eMOLT each vessel is associated with

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
PROGRAM_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	A unique identifier used in this database only
PROGRAM_NAME	varchar(100)	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	The human-readable name of the program
START_DATE	datetime	NULL	NO		NULL		select,insert,update,references	When the program began or is scheduled to begin
END_DATE	datetime	NULL	YES		NULL		select,insert,update,references	When the program ended (leave NULL for ongoing)
LEAD_CONTACT	int	NULL	NO	MUL	NULL		select,insert,update,references	References CONTACTS.CONTACT_ID

MYSQL CODE