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(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
catch_id SPC issued catch id in GUID format char(36) 36 1 YES
year Fishing Year e.g. 2020 char(4) 4 2 YES
flag_code Vessel Flag e.g. TW char(2) 2 3 YES
vessel_name Vessel Name e.g. NIKKO MARU NO. 1 varchar(120) 120 4 YES
depart_date Date of port departure e.g. 31/11/2019 date 5 YES
return_date Date of port return e.g. 31/12/2019 date 6 YES
logdate Date the catch is logged e.g. 21/12/2019 date 7 YES
month Month of the fishing set e.g. 12 int(11) 8 YES
lat Latitude in decimal degrees e.g. 3.17961666666667 decimal(11,8) 9 YES
lon Longditude in decimal degrees e.g. 155.394783333333 decimal(11,8) 10 YES
set_start Time of the fishing set e.g. 1755 time 11 YES
school_id School ID e.g. 4 tinyint(4) 12 YES
eez_code The EEZ of the fishing set e.g. FM char(2) 2 13 YES
activity_code The Activity code as set in the SPC/FFA regional logsheet e.g. 2 tinyint(4) MUL 14 YES
skj_mt The amount of skipjack in metric tonnes e.g. 20.23 decimal(11,3) 15 YES
bet_mt The amount of big eye tuna in metric tonnes e.g. 106.29 decimal(11,3) 16 YES
yft_mt the amount of yellow fin in metric tonnes e.g. 50.10 decimal(11,3) 17 YES
ffa_vid The unique vessel id issued by FFA to the vessel int(11) 18 YES
wcpfc_vid The unique vessel id issued by the WCPFC to the vessel int(11) 19 YES
mmsi The Maritime Mobile Service Identity (MMSI) is a nine-digit number that uniquely identifies the vessel char(9) 9 20 YES
ID Unique ID given to Seaport entry int(11) PRI 1 NO
Country The ISO Alpha 2 letter code of the country the Sea Port resides in varchar(255) 255 2 YES
Location The "LOCODE" 3-character code for the location derived from the United Nations Code for Trade and Transport Locations varchar(255) 255 3 YES
Name The name of the location the seaport resides in varchar(255) 255 MUL 4 YES
NameWoDiacritics names of the location of seaport which have been allocated a UN/LOCODE without diacritic signs. varchar(255) 255 5 YES
Subdivision contains the ISO 1-3 character alphabetic and/or numeric code for the administrative division of the country concerned (state, province, department, etc.), as included in International Standard ISO 3166-2/1998 and when deemed desirable to enhance the use of the code, or when requested by the country concerned. varchar(255) 255 6 YES
Status indicates the status of the entry by a 2-character code, e.g. whether approved by Government, by Customs, or based on a user requirement not necessarily recognised by an authority, etc. It is also intended to show the status of checking, e.g. that function indicators are not verified. varchar(255) 255 7 YES
Function contains a 8-digit function classifier code for the location, where: 0 A value "0" in the first position specifies that the functional use of a location is not known and is to be specified. 1 Specifies that the location is a Port, as defined in UN/ECE Recommendation 16. 2 Specifies that the location is a Rail terminal. 3 Specifies that the location is a Road terminal. 4 Specifies that the location is an Airport. 5 Specifies that the location is a Postal exchange office. 6 Value reserved for multimodal functions, ICDs etc. 7 Value reserved for fixed transport functions (e.g. oil platform). B Specifies that the location is Border crossing varchar(255) 255 8 YES
Date displays the last date when the location was updated/entered double 9 YES
IATA varchar(255) 255 10 YES
Coordinates varchar(255) 255 11 YES
Remarks varchar(255) 255 12 YES
Enabled char(1) 1 13 YES
lat double(11,7) 14 YES
lon double(11,7) 15 YES
userlevelid The ID of the user level int(11) PRI 1 NO
tablename The name of the database table varchar(80) 80 PRI 2 NO
permission The permissions that the user level has int(11) 3 NO
yr The Catch Year date 1 YES
gr_id Gear char(1) 1 2 YES
flag_id Flag State of the vessel char(2) 2 3 YES
fleet_id The Flag State of the Fleet char(2) 2 4 YES
ez_id The EEZ of the Catch char(2) 2 5 YES
days The number of days int(11) 6 YES
skj_c Skip Jack Catch int(11) 7 YES
yft_c Yellow Fin Catch int(11) 8 YES
bet_c Big Eye Catch int(11) 9 YES
days_arch int(11) 10 YES
skj_arch_c int(11) 11 YES
yft_arch_c int(11) 12 YES
bet_arch_c int(11) 13 YES
alb_c Albacore Catch int(11) 14 YES
bum_c int(11) 15 YES
blm_c int(11) 16 YES
mls_c int(11) 17 YES
swo_c Swordfish Catch int(11) 18 YES
TABLE varchar(64) 64 1 NO
COLUMN varchar(64) 64 2 NO
COMMENT varchar(1024) 1024 3 NO
TYPE longtext 4294967295 4 NO
LENGTH bigint(21) unsigned 5 YES
COLUMN_KEY varchar(3) 3 6 NO
POSITION bigint(21) unsigned 7 NO
IS_NULL varchar(3) 3 8 NO
ROWS bigint(21) unsigned 1 YES
ENGINE varchar(64) 64 2 YES
TABLE_NAME varchar(64) 64 3 NO
TABLE_COMMENT varchar(2048) 2048 4 NO
id Unique ID for fee entry int(11) unsigned PRI 1 NO
fee_type The distinct name given for a type of payment varchar(80) 80 2 NO
id Unique ID for FFA memeber entry int(11) PRI 1 NO
country_name The name of the participating country varchar(255) 255 2 YES
country_code_2 The ISO-Alpha 2 -letter code for the participating country char(2) 2 3 YES
country_code_3 The ISO-Alpha 3 -letter code for the participating country char(3) 3 4 YES
currency_code three-letter ISO currency code for the participating country char(10) 10 5 YES
fisheries_authority_name The Name of the Fisheries Authority for the participating country varchar(255) 255 6 YES
fisheries_authority_code The acronym for the name of the Fisheries Authority for the participating country varchar(15) 15 7 YES
id Unique ID used to identify entry int(11) PRI 1 NO
doc_type_code 3-Letter code used to identify document type char(3) 3 2 YES
doc_type The type of document being issued by the system varchar(180) 180 3 YES
doc_description A short description of the document varchar(255) 255 4 YES
id The database issued unique identifier int(11) unsigned PRI 1 NO
event The name of the activity varchar(255) 255 2 NO
event_category the category of the activity enum('SEA','PORT','DRY DOCK','FACTORY','CONTAINER') 9 3 YES
id Unique Identifier int(10) unsigned PRI 1 NO
function Name of the Governance Function varchar(255) 255 2 NO
code 3 charcater code for the function char(5) 5 3 NO
type The Type of Governance Function enum('CONTROL','MONITOR','SURVIEL','ENFORCE','ANALYSE') 7 4 YES
flag_code Vessel Flag char(2) 2 1 YES
vessel_name Vessel Name varchar(120) 120 2 YES
depart_date Date of port departure date 3 YES
return_date Date of port return date 4 YES
lat Latitude in decimal degrees decimal(11,8) 5 YES
lon Longditude in decimal degrees decimal(11,8) 6 YES
set_start Time of the fishing set time 7 YES
eez_code The EEZ of the fishing set char(2) 2 8 YES
skj_mt The amount of skipjack in metric tonnes decimal(11,3) 9 YES
bet_mt The amount of big eye tuna in metric tonnes decimal(11,3) 10 YES
yft_mt the amount of yellow fin in metric tonnes decimal(11,3) 11 YES
total_mt decimal(13,3) 12 YES
logdate Date the catch is logged date 13 YES
activity Activity Description varchar(255) 255 14 YES
school varchar(255) 255 15 YES
userlevelid ID of the User Level int(11) PRI 1 NO
userlevelname Name of the user level varchar(80) 80 2 NO
id int(11) unsigned PRI 1 NO
Code The ISO-Alpha 2 -letter code for the participating country in which the fishing areas is part of char(2) 2 2 NO
Description Description given to fishing areas entry varchar(180) 180 3 YES
Color Color given to describe the fishing areas entry varchar(60) 60 4 YES
Area_Type The ocean zones code as defined in the United Nations Convention on the Law of the Sea char(2) 2 5 YES
IMS_Name varchar(40) 40 6 YES
id int(10) unsigned PRI 1 NO
product_state varchar(255) 255 2 YES
product_state_code char(2) 2 3 YES
ISO3166-1-numeric Three-digit country codes defined in ISO 3166-1 int(4) PRI 1 NO
ISO4217-currency_numeric_code a standard published by International Organization for Standardization (ISO) for the represenation of currencies int(11) 2 NO
ISO4217-currency_alphabetic_code alphabetic code standard published by International Organization for Standardization (ISO) for the represenation of currencies char(20) 20 3 NO
ISO4217-currency_name name of currency from standard published by International Organization for Standardization (ISO) for the represenation of currencies varchar(255) 255 4 NO
ISO3166-1-Alpha-2 Two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard[1] published by the International Organization for Standardization (ISO), to represent countries, dependent territories, and special areas of geographical interest char(2) 2 5 NO
ISO4217-currency_minor_unit minor units of a currency published by International Organization for Standardization (ISO) int(2) 6 YES
id int(11) PRI 1 NO
date_updated varchar(255) 255 2 YES
Species varchar(255) 255 3 YES
ISSCAAP int(11) 4 YES
Tax_Code varchar(20) 20 5 YES
Scientific_Name varchar(255) 255 6 YES
A_Code char(3) 3 7 YES
Author varchar(255) 255 8 YES
Family varchar(120) 120 9 YES
Order varchar(255) 255 10 YES
Stats_Data varchar(3) 3 11 YES
id Unique ID given to specific License Type int(11) PRI 1 NO
license_type Name given to specifc type of License issues by Fisheries Authority varchar(130) 130 2 YES
id Primary Key for country entries int(4) PRI 1 NO
CLDR display name Common Locale Data Repository provides key building blocks for software to support the world's languages, with the largest and most extensive standard repository of locale data available varchar(255) 255 2 YES
ISO3166-1-numeric Three-digit country codes defined in ISO 3166-1 published by the International Organization for Standardization (ISO) int(11) 3 YES
ISO3166-1-Alpha-2 Two-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO) char(2) 2 4 YES
ISO3166-1-Alpha-3 Three-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO) char(3) 3 5 YES
official_name_ar Official recognized country name in the Arabic language varchar(255) 255 6 YES
official_name_cn Official recognized country name in the Chinese/Mandarin language varchar(255) 255 7 YES
official_name_en Official recognized country name in the English language varchar(255) 255 8 YES
official_name_es Official recognized country name in the Spanish language varchar(255) 255 9 YES
official_name_ru Official recognized country name in the Russian language varchar(255) 255 10 YES
official_name_fr Official recognized country name in the French language varchar(255) 255 11 YES
ISO4217-currency_alphabetic_code Standard published by International Organization for Standardization (ISO) that represents currency char(255) 255 12 YES
ISO4217-currency_country_name standard published by International Organization for Standardization (ISO) that represents Country of currency varchar(255) 255 13 YES
ISO4217-currency_minor_unit Minor Unit of currency for standard published by International Organization for Standardization (ISO) that char(5) 5 14 YES
ISO4217-currency_name Name of currency for standard published by International Organization for Standardization (ISO) that varchar(255) 255 15 YES
ISO4217-currency_numeric_code Numeric Code for standard published by International Organization for Standardization (ISO) that char(6) 6 16 YES
M49 UN M49 or the Standard Country or Area Codes for Statistical Use is a standard for area codes used by the United Nations for statistical purposes, developed and maintained by the United Nations Statistics Division char(3) 3 17 YES
UNTERM Arabic Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Name varchar(255) 255 18 YES
UNTERM Arabic Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Name varchar(255) 255 19 YES
UNTERM Chinese Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Country Name varchar(255) 255 20 YES
UNTERM Chinese Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Short Country Name varchar(255) 255 21 YES
UNTERM English Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Country Name varchar(255) 255 22 YES
UNTERM English Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Short Country Name varchar(255) 255 23 YES
UNTERM French Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Country Name varchar(255) 255 24 YES
UNTERM French Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Short Country Name varchar(255) 255 25 YES
UNTERM Russian Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Country Name varchar(255) 255 26 YES
UNTERM Russian Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Short Country Name varchar(255) 255 27 YES
UNTERM Spanish Formal UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Country Name varchar(255) 255 28 YES
UNTERM Spanish Short UNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Short Country Name varchar(255) 255 29 YES
Capital Name of Official Capital for Country varchar(255) 255 30 YES
Continent The Continent Code the Country presides in char(2) 2 31 YES
DS code used for "distinquishing Signs" for Convention on Road Traffic (Geneva, 1949) varchar(3) 3 32 YES
Developed / Developing Countries Country falls under Developed or Developing Category varchar(30) 30 33 YES
Dial Unique Dial Code for respective Country varchar(10) 10 34 YES
EDGAR SEC EDGAR filing codes are used to submit documents to the EDGAR system in addition to accessing online tools and web sites. These codes are created and provided when a company or insider registers with the SEC as an EDGAR filer varchar(255) 255 35 YES
FIFA 3 letter country code assigned by FIFA International Federation of Association Football char(3) 3 36 YES
FIPS 2 letter country code assigned by the Federal Information Processing Standards (FIPS) char(3) 3 37 YES
GAUL GAUL is a relatively new initiative from the FAO (Food and Agriculture Organization), a specialized agency of the U.N. It aims to codify all the world's statoids and their changes, char(10) 10 38 YES
Geoname ID ID to identify country in GeoNames databases varchar(20) 20 39 YES
Global Code (Global Code) is a set of global principles of good practice in the foreign exchange market, developed to provide a common set of guidelines to promote the integrity and effective functioning of the wholesale foreign exchange market. varchar(10) 10 40 YES
Global Name Global name for country varchar(10) 10 41 YES
IOC 3-letter codes assigned to country by the International Olympic Comittee (IOC) char(3) 3 42 YES
ITU letetr codes assigned to country by the International Telecommunication Union (ITU) char(3) 3 43 YES
Intermediate Region Code Code for the Smaller geographical subregions that the country is part of created by the United Nations int(11) 44 YES
Intermediate Region Name Smaller geographical subregions that the country is part of created by the United Nations varchar(255) 255 45 YES
Land Locked Developing Countries (LLDC) Landlocked developing countries (LLDC) are developing countries that are landlocked char(1) 1 46 YES
Languages Language codes of the country varchar(30) 30 47 YES
Least Developed Countries (LDC) Least developed countries (LDCs) are low-income countries confronting severe structural impediments to sustainable development. They are highly vulnerable to economic and environmental shocks and have low levels of human assets. char(1) 1 48 YES
MARC MARC is a standard for encoding bibliographic materials in electronic form. The Library of Congress maintains the MARC code list for countries char(2) 2 49 YES
Region Code UN M49 or the Standard Country or Area Codes for Statistical Use (Series M, No. 49) is a standard for area codes used by the United Nations for statistical purposes, developed and maintained by the United Nations Statistics Division int(11) 50 YES
Region Name Name of the Region Based on the UN M49 list varchar(60) 60 51 YES
Small Island Developing States (SIDS) Small Island Developing States (SIDS) are a distinct group of 38 UN Member States and 20 Non-UN Members/Associate Members of United Nations regional commissions that face unique social, economic and environmental vulnerabilities. char(1) 1 52 YES
Sub-region Code code that corresponds to the UN Region Code List int(11) 53 YES
Sub-region Name Name that corresponds to the UN Region Codelist varchar(60) 60 54 YES
TLD top-level domain (TLD) for a country char(3) 3 55 YES
WMO Meteorological codes are defined by the World Meteorological Organization in WMO char(2) 2 56 YES
is_independent Field is reserved to indicate the country's political sovereignty varchar(30) 30 57 YES
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
id int(10) unsigned PRI 1 NO
product_form varchar(255) 255 2 NO
product_form_code char(2) 2 3 NO
ID int(11) PRI 1 NO
Key double MUL 2 YES
IDENTIFIER varchar(255) 255 MUL 3 YES
GEAR varchar(255) 255 4 YES
CODE varchar(255) 255 MUL 5 YES
ISSCFG_NAME varchar(255) 255 6 YES
ELOG_CODE varchar(255) 255 MUL 7 YES
ELOG_NAME varchar(255) 255 8 YES
IMS_NAME varchar(255) 255 9 YES
IMS_vty_id int(11) 10 YES
id int(11) PRI 1 NO
school varchar(255) 255 MUL 2 YES
id Activity Code int(11) PRI 1 NO
activity Activity Description varchar(255) 255 MUL 2 YES
Submitted by CCM The CCM (Cooperating Members, Cooperating non-members and. Participating Territories (of the WCPFC)) that submitted the information to WCPFC varchar(255) 255 1 YES
VID Unique Vessel Identification Number assigned by WCPFC int(11) PRI 2 NO
Vessel Name Name of the Vessel varchar(120) 120 3 NO
Flag Flag State of the Vessel varchar(120) 120 4 YES
Registration Number Flag State Registration Number of the Vessel varchar(120) 120 5 YES
WIN WCPFC Identification Number (WIN) based on their International Telecommunication Union Radio Call Signs (IRCS) or characters allocated by the International Telecommunication Union (ITU) varchar(40) 40 6 YES
Previous Names Previous Name of the Vessel varchar(300) 300 7 YES
Reg Port Port where the vessel was registered varchar(60) 60 8 YES
Owner Name Name of the the vessel owner varchar(240) 240 9 YES
Owner Address Address of the vessel owner varchar(255) 255 10 YES
Master Name Name of the vessel Captain / Master varchar(240) 240 11 YES
Master Nationality Nationality of the vessel Captain / Master varchar(120) 120 12 YES
Previous Flags Previous Flag of the vessel varchar(120) 120 13 YES
IRCS International Radio Call Sign of the Vessel varchar(255) 255 14 YES
Communication Details WCPFC Identification Number (WIN) based on their International Telecommunication Union Radio Call Signs (IRCS) or characters allocated by the International Telecommunication Union (ITU) varchar(255) 255 15 YES
Built in Country Country the bessel was built in varchar(120) 120 16 YES
Built in Year The year the vessel was built in int(11) 17 YES
Vessel Type Type of vessel e.g. Purse Seiner, Longliner, Pole and Line, Bunker, Carrier etc varchar(60) 60 18 YES
Crew Crew Compliment, how many crew aboard the vessel int(11) 19 YES
Fishing Methods Fishing method of the vessel varchar(255) 255 20 YES
Length Length of vessel. This typically the Length Overall. Length overall is the maximum length of a vessel's hull measured parallel to the waterline. This length is important while docking the ship. It is the most commonly used way of expressing the size of a ship, and is also used for calculating the cost of a marina berth. LOA is usually measured on the hull alone. double 21 YES
Length Type Type of length being measured e.g. Length Overall (LOA) varchar(30) 30 22 YES
Length Units Unit of measurement for length varchar(30) 30 23 YES
Moulded Depth Moulded Depth is the vertical distance measured from the top of the keel to the underside of the upper deck at side of the vessel double 24 YES
Moulded Depth Units The measurement unit that is used to measure the vessels depth varchar(30) 30 25 YES
Beam The beam of a vessel is its width at its widest point. double 26 YES
Beam Units The measurement unit is used to measure the vessels beam varchar(30) 30 27 YES
Tonnage The tonnage refers to a calculation of the volume or cargo volume of a ship int(11) 28 YES
Tonnage Type The type of tonnage being measured. Typically this is the gross registered tonnage (GRT). Gross Registered Tonnage (GRT) is the volume of space within the hull and enclosed space above the deck of a merchant ship which are available for cargo, stores, fuel, passengers and crew. varchar(30) 30 29 YES
Engine Power The amount of power that the engine can generate to propel a vessel int(11) 30 YES
Power Units The unit of measurement used to measure the vessels power varchar(255) 255 31 YES
Freezer Types The type of freezers aboard the vessel varchar(150) 150 32 YES
Freezing Capacity The total storage capacity of the vessels int(11) 33 YES
Freezing Capacity Units The unit of measurement used to measure freezing capacity varchar(120) 120 34 YES
Number of Freezers The number of vessels abaord the vessel int(11) 35 YES
FishHold Capacity The total storage capacity of the fish holds aboard a vessel int(11) 36 YES
FishHold Cap Units The measurement units used to measure fish hold capacity varchar(30) 30 37 YES
Auth Type Type of authoriation granted to the vessel varchar(255) 255 38 YES
Auth Number The unique identifier for the authorisation varchar(255) 255 39 YES
Auth Area The area the vessel is allwed to operate in varchar(255) 255 40 YES
Auth Species The species that the vessel is authorised to catch varchar(255) 255 41 YES
Auth Period From The start of the authorised period varchar(255) 255 42 YES
Auth Period To The end of the authorised period varchar(255) 255 43 YES
Purse seine vessel authorised to tranship at sea Is the purse seine vessel authorised to tranship at sea varchar(255) 255 44 YES
IMO-LR The unique identifier issued by the International Maritime Organisation (IMO)-Loyds Register(LR). It is now used as the vessels UVI (Unique Vessel Identifier) int(11) 45 YES
Authorisation to tranship on the high seas Is the vessel have authorisation to tranship in the high seas? varchar(255) 255 46 YES
Under Charter Is the vessel under charter varchar(255) 255 47 YES
Charterer Name Name of the individual or organisation that is chartering the vessel varchar(255) 255 48 YES
Chartering CCM The CCM (Commission Members, Cooperating Non-Members, and Participating Territories of the WCPFC) chartering the vessel varchar(255) 255 49 YES
Address of Charter The physical address of the individual or organisation that has chartered the vessel varchar(255) 255 50 YES
Charter Start Date The start date of the vessel charter date 51 YES
Charter End Date The end date of the vessel charter date 52 YES
id Unique ID for gear type attribute entry int(10) unsigned PRI 1 NO
gear_type_id Id that corresponds with the specific gear type int(11) 2 YES
gear_type_attribute Name of gear type attribute varchar(255) 255 3 NO
gear_type_attribute_description Description of gear type attribute varchar(255) 255 4 YES
id Unique ID used to identify document entry int(11) PRI 1 NO
doc_type The type of document being issued by the system found in the reference_doc_type table varchar(30) 30 2 YES
identification_type name of identifiable document varchar(255) 255 3 YES
id int(11) PRI 1 NO
date_created datetime 2 YES
date_updated datetime 3 YES
Case varchar(255) 255 4 YES
Case_Outcome varchar(120) 120 5 YES
Flag_State varchar(255) 255 6 YES
Jurisdiction varchar(255) 255 7 YES
Flag_State_Code char(2) 2 8 YES
Jurisdiction_Code char(2) 2 9 YES
Plaintiff varchar(255) 255 10 YES
Defendant varchar(255) 255 11 YES
Judges_Name varchar(255) 255 12 YES
Date_of_Judgement__Settlement date 13 YES
Settlement_Amount decimal(32,4) 14 YES
Submitted_By_First_Name varchar(255) 255 15 YES
Submitted_By_Last_Name varchar(255) 255 16 YES
Email varchar(255) 255 17 YES
Vessel_Name varchar(255) 255 18 YES
Registry_Vessel_Name varchar(255) 255 19 YES
Vessel_Type varchar(255) 255 20 YES
Year_Built int(11) 21 YES
IMO int(11) 22 YES
MMSI int(11) 23 YES
IRCS varchar(20) 20 24 YES
VRMFID int(11) PRI 1 NO
Source varchar(20) 20 2 YES
DateUpdated datetime 3 YES
VesselID varchar(30) 30 MUL 4 YES
TUVI int(11) 5 YES
VesselName varchar(80) 80 MUL 6 YES
FlagCode char(3) 3 7 YES
ParentVesselTypeCode varchar(3) 3 8 YES
ParentVesselType varchar(255) 255 9 YES
VesselTypeCode varchar(3) 3 10 YES
VesselType varchar(255) 255 11 YES
GearTypeCode varchar(3) 3 12 YES
GearType varchar(255) 255 13 YES
Length decimal(11,4) 14 YES
LengthTypeCode varchar(5) 5 15 YES
IRCS char(35) 35 MUL 16 YES
NRN varchar(100) 100 17 YES
IMO int(11) MUL 18 YES
Tonnage decimal(11,4) 19 YES
TonnageTypeCode varchar(255) 255 20 YES
PreviousName varchar(255) 255 21 YES
PreviousNameDate datetime 22 YES
PreviousFlagCode varchar(3) 3 23 YES
PreviousFlagCodeDate date 24 YES
AutStatus varchar(255) 255 25 YES
DateAutStart datetime 26 YES
DateAutEnd datetime 27 YES
DateAutTerm datetime 28 YES
AutTermCode int(11) 29 YES
AutTermDescription varchar(255) 255 30 YES
AutTermReason varchar(255) 255 31 YES
URLID int(11) 32 YES
id System generated unique identifier for the user int(11) unsigned PRI 1 NO
user_name Name of the user varchar(255) 255 2 YES
user_email Users email address. This is used as the user name to log into the system varchar(255) 255 3 NO
user_password Users password varchar(255) 255 4 NO
user_enabled Has the user been enabled in the system tinyint(1) 5 YES
user_notes Any notes that you may have about the user text 65535 6 YES
user_organisation The organisation that the user is from varchar(255) 255 7 YES
user_level_id The users permission level within the system int(11) 8 YES
ID Unique ID given for Observer entry int(11) PRI 1 NO
OBSERVER NAME The name of the observer varchar(255) 255 2 YES
OBSERVER SPC CODE A 3 character alphabet code issued by SPC to the observer as a unique identifier char(3) 3 3 YES
EMAIL The email address of the observer varchar(180) 180 4 YES
PHONE The phone number of the obsserver varchar(40) 40 5 YES
SS NUMBER The observers social security number varchar(20) 20 6 YES
JP VISA An indication of whether the observer has a Japanese Visa tinyint(4) 7 YES
HOME PORT The observers home port varchar(60) 60 8 YES
PORT CODE The observers home port UNLOCDE char(5) 5 9 YES
COUNTRY The observers country / nationality char(2) 2 10 YES
LOCATION 3-letter FSM state code to identify where the Observer is from char(3) 3 11 YES
CONTRACT NO The observers contract number varchar(20) 20 12 YES
CONTRACT START The observers contract start date date 13 YES
CONTRACT END The observers contract end date date 14 YES
FIRST AID An indication of whether the observer have first aid training tinyint(4) 15 YES
CPR An indication of whether the observer is trained on CPR tinyint(4) 16 YES
FIRE FIGHTING An indicaition of whether the observer is trained on fire fighting tinyint(4) 17 YES
SEA SAFETY An indicaition of whether the observer is trained on sea safety tinyint(4) 18 YES
ER An indicaition of whether the observer is trained on electronic reporting tinyint(4) 19 YES
EM An indicaition of whether the observer is trained on electronic monitoring tinyint(4) 20 YES
CE OBS tinyint(4) 21 YES
MSC An indicaition of whether the observer is MSC Certified tinyint(4) 22 YES
BIOLOGICAL tinyint(4) 23 YES
TRAINEE DEBRIEFER An indicaition of whether the observer is a trainee debriefer tinyint(4) 24 YES
DEBRIEFER An indicaition of whether the observer is a debriefer tinyint(4) 25 YES
DONE PS TRIPS An indicaition of whether the observer has done purse seine trips tinyint(4) 26 YES
DONE LL TRIPS An indicaition of whether the observer has done long lline trips tinyint(4) 27 YES
DONE PL TRIPS An indicaition of whether the observer has done pole and line trips tinyint(4) 28 YES
CARRIER TRIPS An indicaition of whether the observer has done carrier trips tinyint(4) 29 YES
NOTES Any addtional notes on the observer varchar(255) 255 30 YES
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
id Unique id for user database access int(11) unsigned PRI 1 NO
user_level_id Level of the user int(11) 2 NO
user_id Users unique ID in the system int(11) 3 NO
title Name of the database to be accessed varchar(255) 255 4 YES
credentials Details of the database credentials text 65535 5 YES
date_updated Date the record was last updated datetime 6 YES
ip_address The IP Address of where the record was submitted from varchar(255) 255 7 YES
id Unique ID used to identify entity entry int(11) unsigned PRI 1 NO
entity_type distinct and independent objects varchar(120) 120 2 NO
entity_class A list of the different types of entity that need to be tracked in a system enum('ASSET','ENTITY') 6 3 YES
id The Company ID automatically generated by the database int(11) PRI 1 NO
code Code issued to the company by the system varchar(11) 11 2 YES
organisation_type Type of organisation (Association, Company) varchar(60) 60 3 YES
organisation Name of the organisation varchar(255) 255 4 NO
country Jurisdiction where the organisation was incorporated varchar(180) 180 5 YES
country_code ISO 3166-1 alpha-2 country code for the jurisdiction where the organisation was incorporated char(2) 2 6 YES
address Physical address of the organisations head office varchar(255) 255 7 YES
contact_name Contact person at the organisation varchar(120) 120 8 YES
email Email address of the contact person at the company varchar(180) 180 9 YES
phone Phone number of the contact person at the company varchar(60) 60 10 YES
fax Fax number for the contact person at the company varchar(60) 60 11 YES