Documemtation

TABLE vms_track_data
TABLE COMMENT Vessel tracks from FFA
ROWS 66022
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
id Pacific Islands Forum Fisheries issued vessel identifier int(11) PRI 1 NO
name Vessel Name varchar(255) 255 2 YES
ircs International Radio Call Sign varchar(255) 255 3 YES
flag Vessel Flag State varchar(255) 255 4 YES
dtg Date and time of GPS position being sent datetime PRI 5 NO
latitude Latitude of vessel double PRI 6 NO
longitude Longitude of the vessel double PRI 7 NO
type Type of VMS position code int(11) 8 YES
Course Course heading of the vessel int(11) 9 YES
Speed Speed of the vessel int(11) 10 YES
Position Type Type of position varchar(255) 255 11 YES
Position Source Source of position data varchar(255) 255 12 YES
Vessel Type Type of vessel varchar(255) 255 13 YES