|
year
|
Fishing Year
|
char(2)
|
2
|
|
1
|
YES
|
|
flag_code
|
Vessel Flag
|
char(2)
|
2
|
|
2
|
YES
|
|
vessel_name
|
Vessel Name
|
varchar(120)
|
120
|
|
3
|
YES
|
|
depart_date
|
Date of port departure
|
date
|
|
|
4
|
YES
|
|
return_date
|
Date of port return
|
date
|
|
|
5
|
YES
|
|
logdate
|
Date the catch is logged
|
date
|
|
|
6
|
YES
|
|
month
|
Month of the fishing set
|
int(11)
|
|
|
7
|
YES
|
|
lat_dms
|
Latitude of the fishing set
|
varchar(255)
|
255
|
|
8
|
YES
|
|
lon_dms
|
Longitude of the fishing set
|
varchar(255)
|
255
|
|
9
|
YES
|
|
lat
|
Latitude in decimal degrees
|
decimal(11,8)
|
|
|
10
|
YES
|
|
lon
|
Longditude in decimal degrees
|
decimal(11,8)
|
|
|
11
|
YES
|
|
set_start
|
Time of the fishing set
|
time
|
|
|
12
|
YES
|
|
school_id
|
School ID
|
tinyint(4)
|
|
|
13
|
YES
|
|
eez_code
|
The EEZ of the fishing set
|
char(2)
|
2
|
|
14
|
YES
|
|
activity_code
|
The Activity code as set in the SPC/FFA regional logsheet
|
tinyint(4)
|
|
MUL
|
15
|
YES
|
|
skj_mt
|
The amount of skipjack in metric tonnes
|
decimal(11,3)
|
|
|
16
|
YES
|
|
bet_mt
|
The amount of big eye tuna in metric tonnes
|
decimal(11,3)
|
|
|
17
|
YES
|
|
yft_mt
|
the amount of yellow fin in metric tonnes
|
decimal(11,3)
|
|
|
18
|
YES
|