dbTable: CONTACTS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table stores contact information for eMOLT participants and support staff
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| CONTACT_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| FIRST_NAME | varchar(100) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Given name of contact | ||
| LAST_NAME | varchar(100) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Surname of contact | ||
| PHONE | varchar(10) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Phone number in format xxxxxxxxxx | ||
| varchar(50) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Email address | |||
| PREFERRED_CONTACT | set('CALL_PHONE','TXT_PHONE','EMAIL','MAIL','NO CONTACT') | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Preferred method of contact | ||
| STREET_1 | varchar(100) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Street address line 1 | ||
| STREET_2 | varchar(100) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Street address line 2 (if applicable) | ||
| CITY | varchar(50) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | City of addressee | ||
| STATE_POSTAL | varchar(2) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Two character abbreviation of state or province used by postal service | ||
| ZIP | varchar(6) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Postal code, 5 characters for USA and 6 for Canada | ||
| ROLE | set('ACTIVE_SUPPORT','ACTIVE_INDUSTRY','ACTIVE_ADMIN','INACTIVE','DATA_USER') | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | A way of categorizing contacts |