Documemtation

TABLE reference_vessel_license
TABLE COMMENT A reference list of fishing licenses issued by NORMA
ROWS 5801
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
id int(11) PRI 1 NO
date_created datetime 2 YES
date_updated datetime 3 YES
Status varchar(60) 60 4 YES
Vessel_Type varchar(120) 120 5 YES
Vessel_Name varchar(255) 255 6 YES
Licence_Number varchar(30) 30 7 YES
Start date 8 YES
Expiry date 9 YES
Issued date 10 YES
Company varchar(255) 255 11 YES
Company_Code varchar(20) 20 12 YES
FFA_VID int(11) 13 YES
IRCS varchar(20) 20 14 YES
IMO int(11) 15 YES
WCPFC_VID int(11) 16 YES
MMSI int(11) 17 YES
Flag_State varchar(255) 255 18 YES
Flag_State_Number varchar(30) 30 19 YES
GRT decimal(11,4) 20 YES
LOA varchar(11) 11 21 YES
Fishing_Areas varchar(255) 255 22 YES
Target_Species varchar(255) 255 23 YES
Agreement_Name varchar(120) 120 24 YES
Agreement_Code varchar(30) 30 25 YES
Agreement_Start date 26 YES
Agreement_Expiry date 27 YES
Applicant_Email varchar(255) 255 28 YES