dbTable: FUNDING

PURPOSE

This table stores information that will assist in tracking how eMOLT is funded

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
FUNDING_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	A unique identifier used in this database only
FUNDING_AGENCY	varchar(50)	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Human readable identifier of funding agency
START_DATE	datetime	NULL	YES		NULL		select,insert,update,references	When the funding becomes available
END_DATE	datetime	NULL	YES		NULL		select,insert,update,references	When the funding should be used by
FUNDING_AMOUNT_USD	int	NULL	NO		NULL		select,insert,update,references	How much funding was received (in US Dollars)
PROPOSAL_LINK	varchar(255)	utf8mb4_0900_ai_ci	YES		NULL		select,insert,update,references	Google drive link to funding proposal

MYSQL CODE