dbTable: TOW_SENSORS

PURPOSE

This table describes which instruments were used on which tows

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
TOW_SENSOR_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	Links this table to the TOWS table
INVENTORY_ID	int	NULL	NO	MUL	NULL		select,insert,update,references	Links this table to the EQUIPMENT_INVENTORY table
UPLOAD_TIME	datetime	NULL	YES		NULL		select,insert,update,references	Timestamp (UTC) for the most recent upload from this tow
UPLOAD_SOURCE	set('SAT','WIFI','CELL','MANUAL')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	Describes whether the data were uploaded directly by satellite as summary information or loaded in their raw format via another transmission method (requiring summary stats be calculated after the fact)
DATAFILE	varchar(255)	utf8mb4_0900_ai_ci	YES		NULL		select,insert,update,references	Raw data filename (if applicable, NULL for satellite transmission)

MYSQL CODE