|
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
|