dbTable: TOWS_SUMMARY - GMaynard1/emolt_serverside GitHub Wiki
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 |