dbTable: TOWS

PURPOSE

This table stores metadata from individual tows or hauls of fishing gear. Tow and haul are used to mean the same thing, although in common parlance, "tows" are taken with mobile gear and "hauls" are made with fixed gear. Both gear types "soak" in the water.

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
TOW_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	UID for this table
VESSEL_ID	int	NULL	NO	MUL	NULL		select,insert,update,references	Ties tow or haul data to vessel table
MEAN_LATITUDE	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	Haul-averaged latitude
MEAN_LONGITUDE	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	Haul-averaged longitude
SOAK_TIME	int	NULL	YES		NULL		select,insert,update,references	Tow or soak time (minutes)
MEAN_TIME	datetime	NULL	YES		NULL		select,insert,update,references	The temporal midpoint of the tow or soak

MYSQL CODE