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