dbTable: CONTACT_AFFILIATIONS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table links eMOLT participants to industry associations, fishing companies, research institutions, etc.
TABLE DEFINITIONS
| Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
|---|---|---|---|---|---|---|---|---|
| AFFILIATION_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | A unique identifier used in this database only |
| PARTNER_ID | int | NULL | NO | MUL | NULL | select,insert,update,references | References PARTNER_GROUPS.PARTNER_ID | |
| CONTACT_ID | int | NULL | NO | MUL | NULL | select,insert,update,references | References CONTACTS.CONTACT_ID |