dbTable: PARTNER_GROUPS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table stores contact information for industry associations, fishing companies, research institutions, etc. that eMOLT participants are affiliated with.
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| PARTNER_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| PARTNER_NAME | varchar(100) | utf8mb4_0900_ai_ci | NO | NULL | select,insert,update,references | Organization name | ||
| PARTNER_STREET | varchar(100) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Partner street address | ||
| PARTNER_CITY | varchar(50) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | City where mailing address is located | ||
| PARTNER_STATE | varchar(2) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Two character abbreviation of state or province used by postal service | ||
| PARTNER_ZIP | varchar(6) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Postal code, 5 characters for USA and 6 for Canada | ||
| PARTNER_PHONE | varchar(10) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Phone number in format xxxxxxxxxx | ||
| PARTNER_EMAIL | varchar(100) | utf8mb4_0900_ai_ci | YES | NULL | select,insert,update,references | Email address of partner organization |