Documemtation

TABLE purse_seine_catch
TABLE COMMENT Purse Seine Catches
ROWS 15670
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
year Fishing Year char(2) 2 1 YES
flag_code Vessel Flag char(2) 2 2 YES
vessel_name Vessel Name varchar(255) 255 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 Latitude of the fishing set varchar(255) 255 8 YES
lon Longitude of the fishing set varchar(255) 255 9 YES
latd Latitude in decimal degrees decimal(11,8) 10 YES
lond 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) 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