dbTable: PARTNER_GROUPS

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

MYSQL CODE