dbTable: FUNDING - GMaynard1/emolt_serverside GitHub Wiki
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 |