dbTable: TOW_SEGMENTS - GMaynard1/emolt_serverside GitHub Wiki
PURPOSE
This table stores information about when tows can be broken into distinct segments (e.g., downcast vs. retrieval) and how those breakpoints are applied
TABLE DEFINITIONS
Field | Type | Collation | Null | Key | Default | Extra | Privileges | Comment |
---|---|---|---|---|---|---|---|---|
TOW_SEGMENT_ID | int | NULL | NO | PRI | NULL | auto_increment | select,insert,update,references | UID for this table |
TOW_SENSOR_ID | int | NULL | NO | MUL | NULL | select,insert,update,references | Links to the TOWS table | |
SEGMENT_START_TIME | datetime | NULL | NO | NULL | select,insert,update,references | The timestamp that delineates the beginning of the segment | ||
SEGMENT_END_TIME | datetime | NULL | NO | NULL | select,insert,update,references | The timestamp that delineates the end of the segment | ||
SEGMENT_TYPE | int | NULL | NO | MUL | NULL | select,insert,update,references | Links to the SEGMENT_TYPES table | |
SEGMENTATION_METHOD | int | NULL | NO | MUL | NULL | select,insert,update,references | Links to the SEGMENTATION_METHODS table |