dbTable: TOWS_SUMMARY

PURPOSE

This table stores summary values of observations 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
TS_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	UID for this table
TOW_ID	int	NULL	NO	MUL	NULL		select,insert,update,references	Ties summary data to a tow
TS_MEAN_VALUE	decimal(10,5)	NULL	NO		NULL		select,insert,update,references	Mean value of parameter over tow duration
TS_RANGE_VALUE	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	Absolute value of maximum observed value minus minimum observed value over the tow duration
TS_STD_VALUE	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	Standard deviation of parameter over tow duration
TS_PARAMETER	set('TEMP','DEPTH','DO','PH','SPEED','DIR','N_VELO','E_VELO','YAW','PITCH','ROLL','HEADING','TILT_FROM_VERT','TURBIDITY','CONDUCTIVITY','PAR')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Parameters that can be measured
TS_UOM	set('DEGREES CELSIUS','m','PERCENT','mg/L','pH','cm/s','BEARING DEGREES','FTU','uS','umol/s')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Units of measure parameter values are recorded in
TS_SOURCE	set('TELEMETRY','CALCULATED')	utf8mb4_0900_ai_ci	YES		NULL		select,insert,update,references	Whether the values were delivered from the field by satellite or calculated after the fact.
TS_INSTRUMENT	int	NULL	YES	MUL	NULL		select,insert,update,references	Ties summary data to a logger

MYSQL CODE