generated from NEFSC/NEFSC-Template
-
Notifications
You must be signed in to change notification settings - Fork 1
dbTable: CONTACT_AFFILIATIONS
George Maynard edited this page Aug 2, 2022
·
1 revision
This table links eMOLT participants to industry associations, fishing companies, research institutions, etc.
| 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 |