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