dbTable: VESSEL_STATUS - GMaynard1/emolt_serverside GitHub Wiki

PURPOSE

This table stores information about where vessels are located and indicators of the status of different systems onboard.

TABLE DEFINITIONS

Field	Type	Collation	Null	Key	Default	Extra	Privileges	Comment
REPORT_ID	int	NULL	NO	PRI	NULL	auto_increment	select,insert,update,references	UID for this table
VESSEL_ID	int	NULL	NO	MUL	NULL		select,insert,update,references	Ties status report to vessel
REPORT_TYPE	set('RAW_DATA','SUMMARY_DATA','SHORT_STATUS','LONG_STATUS','MANUAL')	utf8mb4_0900_ai_ci	NO		NULL		select,insert,update,references	The type of status report. Data means that data were transmitted. Status means an automated status report. Manual means the report was triggered manually by an end user
LATITUDE	decimal(10,5)	NULL	NO		NULL		select,insert,update,references	Latitude of status report
LONGITUDE	decimal(10,5)	NULL	NO		NULL		select,insert,update,references	Longitude of status report
TIMESTAMP	datetime	NULL	NO		NULL		select,insert,update,references	When the reportt was transmitted
GPS_SATS	int	NULL	YES		NULL		select,insert,update,references	The number of GPS satellites in view
IRID_SATS	int	NULL	YES		NULL		select,insert,update,references	The number of iridium satellites in view (if available)
UPTIME	int	NULL	YES		NULL		select,insert,update,references	The number of minutes the system has been powered on
CELL_STRENGTH	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	The signal strength of the cellular network (if available)
WIFI_STRENGTH	decimal(10,5)	NULL	YES		NULL		select,insert,update,references	The signal strength of the wifi network (if available)
LAST_DOWNLOAD	datetime	NULL	YES		NULL		select,insert,update,references	The most recent successful download from a probe
DATA_USAGE	decimal(10,2)	NULL	YES		NULL		select,insert,update,references	Amount of data (MB) transmitted via cellular network since the last status report (if available)
DISTANCE_TRAVELED	decimal(10,2)	NULL	YES		NULL		select,insert,update,references	Straight line distance traveled (km) from location of last status report (Haversine method)

MYSQL CODE