TABLECOLUMNCOMMENTTYPELENGTHCOLUMN_KEYPOSITIONIS_NULL
vms_track_dataidPacific Islands Forum Fisheries issued vessel identifierint(11)PRI1NO
vms_track_datanameVessel Namevarchar(255)2552YES
vms_track_dataircsInternational Radio Call Signvarchar(255)2553YES
vms_track_dataflagVessel Flag Statevarchar(255)2554YES
vms_track_datadtgDate and time of GPS position being sentdatetimePRI5NO
vms_track_datalatitudeLatitude of vessel doublePRI6NO
vms_track_datalongitudeLongitude of the vesseldoublePRI7NO
vms_track_datatypeType of VMS position codeint(11)8YES
vms_track_dataCourseCourse heading of the vesselint(11)9YES
vms_track_dataSpeedSpeed of the vesselint(11)10YES
vms_track_dataPosition TypeType of positionvarchar(255)25511YES
vms_track_dataPosition SourceSource of position datavarchar(255)25512YES
vms_track_dataVessel TypeType of vesselvarchar(255)25513YES
reference_seaportsIDUnique ID given to Seaport entryint(11)PRI1NO
reference_seaportsCountryThe ISO Alpha 2 letter code of the country the Sea Port resides invarchar(255)2552YES
reference_seaportsLocationThe "LOCODE" 3-character code for the location derived from the United Nations Code for Trade and Transport Locations varchar(255)2553YES
reference_seaportsNameThe name of the location the seaport resides invarchar(255)255MUL4YES
reference_seaportsNameWoDiacriticsnames of the location of seaport which have been allocated a UN/LOCODE without diacritic signs.varchar(255)2555YES
reference_seaportsSubdivisioncontains 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)2556YES
reference_seaportsStatusindicates 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)2557YES
reference_seaportsFunctioncontains 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 crossingvarchar(255)2558YES
reference_seaportsDatedisplays the last date when the location was updated/entereddouble9YES
reference_seaportsIATAvarchar(255)25510YES
reference_seaportsCoordinatesvarchar(255)25511YES
reference_seaportsRemarksvarchar(255)25512YES
reference_seaportsEnabledchar(1)113YES
reference_seaportslatdouble(11,7)14YES
reference_seaportslondouble(11,7)15YES
userlevelpermissionsuserlevelidThe ID of the user levelint(11)PRI1NO
userlevelpermissionstablenameThe name of the database tablevarchar(80)80PRI2NO
userlevelpermissionspermissionThe permissions that the user level hasint(11)3NO
annual_catch_by_flagyrThe Catch Yeardate1YES
annual_catch_by_flaggr_idGearchar(1)12YES
annual_catch_by_flagflag_idFlag State of the vesselchar(2)23YES
annual_catch_by_flagfleet_idThe Flag State of the Fleetchar(2)24YES
annual_catch_by_flagez_idThe EEZ of the Catchchar(2)25YES
annual_catch_by_flagdaysThe number of daysint(11)6YES
annual_catch_by_flagskj_cSkip Jack Catchint(11)7YES
annual_catch_by_flagyft_cYellow Fin Catchint(11)8YES
annual_catch_by_flagbet_cBig Eye Catchint(11)9YES
annual_catch_by_flagdays_archint(11)10YES
annual_catch_by_flagskj_arch_cint(11)11YES
annual_catch_by_flagyft_arch_cint(11)12YES
annual_catch_by_flagbet_arch_cint(11)13YES
annual_catch_by_flagalb_cAlbacore Catchint(11)14YES
annual_catch_by_flagbum_cint(11)15YES
annual_catch_by_flagblm_cint(11)16YES
annual_catch_by_flagmls_cint(11)17YES
annual_catch_by_flagswo_cSwordfish Catchint(11)18YES
docs_columnsTABLEvarchar(64)641NO
docs_columnsCOLUMNvarchar(64)642NO
docs_columnsCOMMENTvarchar(1024)10243NO
docs_columnsTYPElongtext42949672954NO
docs_columnsLENGTHbigint(21) unsigned5YES
docs_columnsCOLUMN_KEYvarchar(3)36NO
docs_columnsPOSITIONbigint(21) unsigned7NO
docs_columnsIS_NULLvarchar(3)38NO
docs_tablesROWSbigint(21) unsigned1YES
docs_tablesENGINEvarchar(64)642YES
docs_tablesTABLE_NAMEvarchar(64)643NO
docs_tablesTABLE_COMMENTvarchar(2048)20484NO
reference_fee_typeidUnique ID for fee entryint(11) unsignedPRI1NO
reference_fee_typefee_typeThe distinct name given for a type of paymentvarchar(80)802NO
reference_ffa_membersidUnique ID for FFA memeber entryint(11)PRI1NO
reference_ffa_memberscountry_nameThe name of the participating countryvarchar(255)2552YES
reference_ffa_memberscountry_code_2The ISO-Alpha 2 -letter code for the participating countrychar(2)23YES
reference_ffa_memberscountry_code_3The ISO-Alpha 3 -letter code for the participating countrychar(3)34YES
reference_ffa_memberscurrency_codethree-letter ISO currency code for the participating countrychar(10)105YES
reference_ffa_membersfisheries_authority_nameThe Name of the Fisheries Authority for the participating countryvarchar(255)2556YES
reference_ffa_membersfisheries_authority_codeThe acronym for the name of the Fisheries Authority for the participating countryvarchar(15)157YES
reference_doc_typeidUnique ID used to identify entry int(11)PRI1NO
reference_doc_typedoc_type_code3-Letter code used to identify document type char(3)32YES
reference_doc_typedoc_typeThe type of document being issued by the systemvarchar(180)1803YES
reference_doc_typedoc_descriptionA short description of the documentvarchar(255)2554YES
reference_eventidThe database issued unique identifierint(11) unsignedPRI1NO
reference_eventeventThe name of the activityvarchar(255)2552NO
reference_eventevent_categorythe category of the activityenum('SEA','PORT','DRY DOCK','FACTORY','CONTAINER')93YES
reference_mcs_activityidUnique Identifierint(10) unsignedPRI1NO
reference_mcs_activityfunctionName of the Governance Functionvarchar(255)2552NO
reference_mcs_activitycode3 charcater code for the functionchar(5)53NO
reference_mcs_activitytypeThe Type of Governance Functionenum('CONTROL','MONITOR','SURVIEL','ENFORCE','ANALYSE')74YES
userlevelsuserlevelidID of the User Levelint(11)PRI1NO
userlevelsuserlevelnameName of the user levelvarchar(80)802NO
reference_fishing_areasidint(11) unsignedPRI1NO
reference_fishing_areasCodeThe ISO-Alpha 2 -letter code for the participating country in which the fishing areas is part ofchar(2)22NO
reference_fishing_areasDescriptionDescription given to fishing areas entryvarchar(180)1803YES
reference_fishing_areasColorColor given to describe the fishing areas entryvarchar(60)604YES
reference_fishing_areasArea_TypeThe ocean zones code as defined in the United Nations Convention on the Law of the Sea char(2)25YES
reference_fishing_areasIMS_Namevarchar(40)406YES
reference_product_stateidint(10) unsignedPRI1NO
reference_product_stateproduct_statevarchar(255)2552YES
reference_product_stateproduct_state_codechar(2)23YES
reference_currencyISO3166-1-numeric Three-digit country codes defined in ISO 3166-1int(4)PRI1NO
reference_currencyISO4217-currency_numeric_codea standard published by International Organization for Standardization (ISO) for the represenation of currenciesint(11)2NO
reference_currencyISO4217-currency_alphabetic_codealphabetic code standard published by International Organization for Standardization (ISO) for the represenation of currencieschar(20)203NO
reference_currencyISO4217-currency_namename of currency from standard published by International Organization for Standardization (ISO) for the represenation of currenciesvarchar(255)2554NO
reference_currencyISO3166-1-Alpha-2Two-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 interestchar(2)25NO
reference_currencyISO4217-currency_minor_unit minor units of a currency published by International Organization for Standardization (ISO)int(2)6YES
reference_species_tunaidint(11)PRI1NO
reference_species_tunadate_updatedvarchar(255)2552YES
reference_species_tunaSpeciesvarchar(255)2553YES
reference_species_tunaISSCAAPint(11)4YES
reference_species_tunaTax_Codevarchar(20)205YES
reference_species_tunaScientific_Namevarchar(255)2556YES
reference_species_tunaA_Codechar(3)37YES
reference_species_tunaAuthorvarchar(255)2558YES
reference_species_tunaFamilyvarchar(120)1209YES
reference_species_tunaOrdervarchar(255)25510YES
reference_species_tunaStats_Datavarchar(3)311YES
reference_license_typeidUnique ID given to specific License Typeint(11)PRI1NO
reference_license_typelicense_typeName given to specifc type of License issues by Fisheries Authorityvarchar(130)1302YES
reference_countryidPrimary Key for country entries int(4)PRI1NO
reference_countryCLDR display nameCommon 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 availablevarchar(255)2552YES
reference_countryISO3166-1-numericThree-digit country codes defined in ISO 3166-1 published by the International Organization for Standardization (ISO)int(11)3YES
reference_countryISO3166-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)24YES
reference_countryISO3166-1-Alpha-3Three-letter country codes defined in ISO 3166-1, part of the ISO 3166 standard published by the International Organization for Standardization (ISO)char(3)35YES
reference_countryofficial_name_arOfficial recognized country name in the Arabic languagevarchar(255)2556YES
reference_countryofficial_name_cnOfficial recognized country name in the Chinese/Mandarin languagevarchar(255)2557YES
reference_countryofficial_name_enOfficial recognized country name in the English languagevarchar(255)2558YES
reference_countryofficial_name_esOfficial recognized country name in the Spanish languagevarchar(255)2559YES
reference_countryofficial_name_ruOfficial recognized country name in the Russian languagevarchar(255)25510YES
reference_countryofficial_name_frOfficial recognized country name in the French languagevarchar(255)25511YES
reference_countryISO4217-currency_alphabetic_codeStandard published by International Organization for Standardization (ISO) that represents currency char(255)25512YES
reference_countryISO4217-currency_country_name standard published by International Organization for Standardization (ISO) that represents Country of currencyvarchar(255)25513YES
reference_countryISO4217-currency_minor_unitMinor Unit of currency for standard published by International Organization for Standardization (ISO) that char(5)514YES
reference_countryISO4217-currency_name Name of currency for standard published by International Organization for Standardization (ISO) that varchar(255)25515YES
reference_countryISO4217-currency_numeric_codeNumeric Code for standard published by International Organization for Standardization (ISO) that char(6)616YES
reference_countryM49UN 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 Divisionchar(3)317YES
reference_countryUNTERM Arabic FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Name varchar(255)25518YES
reference_countryUNTERM Arabic ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Arabic Country Namevarchar(255)25519YES
reference_countryUNTERM Chinese FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Country Namevarchar(255)25520YES
reference_countryUNTERM Chinese ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Chinese Short Country Namevarchar(255)25521YES
reference_countryUNTERM English FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Country Namevarchar(255)25522YES
reference_countryUNTERM English ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for English Short Country Namevarchar(255)25523YES
reference_countryUNTERM French FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Country Namevarchar(255)25524YES
reference_countryUNTERM French ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for French Short Country Namevarchar(255)25525YES
reference_countryUNTERM Russian FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Country Namevarchar(255)25526YES
reference_countryUNTERM Russian ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Russian Short Country Namevarchar(255)25527YES
reference_countryUNTERM Spanish FormalUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Country Namevarchar(255)25528YES
reference_countryUNTERM Spanish ShortUNTERM provides terminology and nomenclature in subjects relevant to the work of the United Nations system for Spanish Short Country Namevarchar(255)25529YES
reference_countryCapitalName of Official Capital for Countryvarchar(255)25530YES
reference_countryContinentThe Continent Code the Country presides inchar(2)231YES
reference_countryDS code used for "distinquishing Signs" for Convention on Road Traffic (Geneva, 1949)varchar(3)332YES
reference_countryDeveloped / Developing CountriesCountry falls under Developed or Developing Category varchar(30)3033YES
reference_countryDialUnique Dial Code for respective Countryvarchar(10)1034YES
reference_countryEDGARSEC 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 filervarchar(255)25535YES
reference_countryFIFA3 letter country code assigned by FIFA International Federation of Association Footballchar(3)336YES
reference_countryFIPS2 letter country code assigned by the Federal Information Processing Standards (FIPS) char(3)337YES
reference_countryGAULGAUL 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)1038YES
reference_countryGeoname IDID to identify country in GeoNames databasesvarchar(20)2039YES
reference_countryGlobal 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)1040YES
reference_countryGlobal NameGlobal name for countryvarchar(10)1041YES
reference_countryIOC3-letter codes assigned to country by the International Olympic Comittee (IOC) char(3)342YES
reference_countryITUletetr codes assigned to country by the International Telecommunication Union (ITU)char(3)343YES
reference_countryIntermediate Region CodeCode for the Smaller geographical subregions that the country is part of created by the United Nationsint(11)44YES
reference_countryIntermediate Region NameSmaller geographical subregions that the country is part of created by the United Nations varchar(255)25545YES
reference_countryLand Locked Developing Countries (LLDC)Landlocked developing countries (LLDC) are developing countries that are landlockedchar(1)146YES
reference_countryLanguagesLanguage codes of the countryvarchar(30)3047YES
reference_countryLeast 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)148YES
reference_countryMARC MARC is a standard for encoding bibliographic materials in electronic form. The Library of Congress maintains the MARC code list for countrieschar(2)249YES
reference_countryRegion CodeUN 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 Divisionint(11)50YES
reference_countryRegion NameName of the Region Based on the UN M49 list varchar(60)6051YES
reference_countrySmall 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)152YES
reference_countrySub-region Codecode that corresponds to the UN Region Code Listint(11)53YES
reference_countrySub-region NameName that corresponds to the UN Region Codelist varchar(60)6054YES
reference_countryTLDtop-level domain (TLD) for a countrychar(3)355YES
reference_countryWMO Meteorological codes are defined by the World Meteorological Organization in WMOchar(2)256YES
reference_countryis_independentField is reserved to indicate the country's political sovereigntyvarchar(30)3057YES
reference_vessel_licenseidint(11)PRI1NO
reference_vessel_licensedate_createddatetime2YES
reference_vessel_licensedate_updateddatetime3YES
reference_vessel_licenseStatusvarchar(60)604YES
reference_vessel_licenseVessel_Typevarchar(120)1205YES
reference_vessel_licenseVessel_Namevarchar(255)2556YES
reference_vessel_licenseLicence_Numbervarchar(30)307YES
reference_vessel_licenseStartdate8YES
reference_vessel_licenseExpirydate9YES
reference_vessel_licenseIssueddate10YES
reference_vessel_licenseCompanyvarchar(255)25511YES
reference_vessel_licenseCompany_Codevarchar(20)2012YES
reference_vessel_licenseFFA_VIDint(11)13YES
reference_vessel_licenseIRCSvarchar(20)2014YES
reference_vessel_licenseIMOint(11)15YES
reference_vessel_licenseWCPFC_VIDint(11)16YES
reference_vessel_licenseMMSIint(11)17YES
reference_vessel_licenseFlag_Statevarchar(255)25518YES
reference_vessel_licenseFlag_State_Numbervarchar(30)3019YES
reference_vessel_licenseGRTdecimal(11,4)20YES
reference_vessel_licenseLOAvarchar(11)1121YES
reference_vessel_licenseFishing_Areasvarchar(255)25522YES
reference_vessel_licenseTarget_Speciesvarchar(255)25523YES
reference_vessel_licenseAgreement_Namevarchar(120)12024YES
reference_vessel_licenseAgreement_Codevarchar(30)3025YES
reference_vessel_licenseAgreement_Startdate26YES
reference_vessel_licenseAgreement_Expirydate27YES
reference_vessel_licenseApplicant_Emailvarchar(255)25528YES
reference_product_formidint(10) unsignedPRI1NO
reference_product_formproduct_formvarchar(255)2552NO
reference_product_formproduct_form_codechar(2)23NO
reference_gear_typeIDint(11)PRI1NO
reference_gear_typeKeydoubleMUL2YES
reference_gear_typeIDENTIFIERvarchar(255)255MUL3YES
reference_gear_typeGEARvarchar(255)2554YES
reference_gear_typeCODEvarchar(255)255MUL5YES
reference_gear_typeISSCFG_NAMEvarchar(255)2556YES
reference_gear_typeELOG_CODEvarchar(255)255MUL7YES
reference_gear_typeELOG_NAMEvarchar(255)2558YES
reference_gear_typeIMS_NAMEvarchar(255)2559YES
reference_gear_typeIMS_vty_idint(11)10YES
reference_activity_codesidActivity Codeint(11)PRI1NO
reference_activity_codesactivityActivity Descriptionvarchar(255)2552YES
purse_seine_catchyearFishing Yearchar(2)21YES
purse_seine_catchflag_codeVessel Flagchar(2)22YES
purse_seine_catchvessel_nameVessel Namevarchar(255)2553YES
purse_seine_catchdepart_dateDate of port departuredate4YES
purse_seine_catchreturn_dateDate of port returndate5YES
purse_seine_catchlogdateDate the catch is loggeddate6YES
purse_seine_catchmonthMonth of the fishing setint(11)7YES
purse_seine_catchlatLatitude of the fishing setvarchar(255)2558YES
purse_seine_catchlonLongitude of the fishing setvarchar(255)2559YES
purse_seine_catchlatdLatitude in decimal degreesdecimal(11,8)10YES
purse_seine_catchlondLongditude in decimal degreesdecimal(11,8)11YES
purse_seine_catchset_startTime of the fishing settime12YES
purse_seine_catchschool_idSchool IDtinyint(4)13YES
purse_seine_catcheez_codeThe EEZ of the fishing setchar(2)214YES
purse_seine_catchactivity_codeThe Activity code as set in the SPC/FFA regional logsheettinyint(4)15YES
purse_seine_catchskj_mtThe amount of skipjack in metric tonnesdecimal(11,3)16YES
purse_seine_catchbet_mtThe amount of big eye tuna in metric tonnesdecimal(11,3)17YES
purse_seine_catchyft_mtthe amount of yellow fin in metric tonnesdecimal(11,3)18YES
reference_wcpfc_rfvSubmitted by CCMThe CCM (Cooperating Members, Cooperating non-members and. Participating Territories (of the WCPFC)) that submitted the information to WCPFCvarchar(255)2551YES
reference_wcpfc_rfvVIDUnique Vessel Identification Number assigned by WCPFC int(11)PRI2NO
reference_wcpfc_rfvVessel NameName of the Vessel varchar(120)1203NO
reference_wcpfc_rfvFlagFlag State of the Vesselvarchar(120)1204YES
reference_wcpfc_rfvRegistration NumberFlag State Registration Number of the Vesselvarchar(120)1205YES
reference_wcpfc_rfvWINWCPFC Identification Number (WIN) based on their International Telecommunication Union Radio Call Signs (IRCS) or characters allocated by the International Telecommunication Union (ITU)varchar(40)406YES
reference_wcpfc_rfvPrevious NamesPrevious Name of the Vesselvarchar(300)3007YES
reference_wcpfc_rfvReg PortPort where the vessel was registeredvarchar(60)608YES
reference_wcpfc_rfvOwner NameName of the the vessel ownervarchar(240)2409YES
reference_wcpfc_rfvOwner AddressAddress of the vessel ownervarchar(255)25510YES
reference_wcpfc_rfvMaster NameName of the vessel Captain / Mastervarchar(240)24011YES
reference_wcpfc_rfvMaster NationalityNationality of the vessel Captain / Mastervarchar(120)12012YES
reference_wcpfc_rfvPrevious FlagsPrevious Flag of the vesselvarchar(120)12013YES
reference_wcpfc_rfvIRCSInternational Radio Call Sign of the Vesselvarchar(255)25514YES
reference_wcpfc_rfvCommunication DetailsWCPFC Identification Number (WIN) based on their International Telecommunication Union Radio Call Signs (IRCS) or characters allocated by the International Telecommunication Union (ITU)varchar(255)25515YES
reference_wcpfc_rfvBuilt in CountryCountry the bessel was built invarchar(120)12016YES
reference_wcpfc_rfvBuilt in YearThe year the vessel was built inint(11)17YES
reference_wcpfc_rfvVessel TypeType of vessel e.g. Purse Seiner, Longliner, Pole and Line, Bunker, Carrier etcvarchar(60)6018YES
reference_wcpfc_rfvCrewCrew Compliment, how many crew aboard the vesselint(11)19YES
reference_wcpfc_rfvFishing MethodsFishing method of the vessel varchar(255)25520YES
reference_wcpfc_rfvLengthLength 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.double21YES
reference_wcpfc_rfvLength TypeType of length being measured e.g. Length Overall (LOA)varchar(30)3022YES
reference_wcpfc_rfvLength UnitsUnit of measurement for lengthvarchar(30)3023YES
reference_wcpfc_rfvMoulded DepthMoulded Depth is the vertical distance measured from the top of the keel to the underside of the upper deck at side of the vesseldouble24YES
reference_wcpfc_rfvMoulded Depth UnitsThe measurement unit that is used to measure the vessels depthvarchar(30)3025YES
reference_wcpfc_rfvBeamThe beam of a vessel is its width at its widest point.double26YES
reference_wcpfc_rfvBeam UnitsThe measurement unit is used to measure the vessels beamvarchar(30)3027YES
reference_wcpfc_rfvTonnageThe tonnage refers to a calculation of the volume or cargo volume of a shipint(11)28YES
reference_wcpfc_rfvTonnage TypeThe 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)3029YES
reference_wcpfc_rfvEngine PowerThe amount of power that the engine can generate to propel a vesselint(11)30YES
reference_wcpfc_rfvPower UnitsThe unit of measurement used to measure the vessels powervarchar(255)25531YES
reference_wcpfc_rfvFreezer TypesThe type of freezers aboard the vesselvarchar(150)15032YES
reference_wcpfc_rfvFreezing CapacityThe total storage capacity of the vesselsint(11)33YES
reference_wcpfc_rfvFreezing Capacity UnitsThe unit of measurement used to measure freezing capacityvarchar(120)12034YES
reference_wcpfc_rfvNumber of FreezersThe number of vessels abaord the vesselint(11)35YES
reference_wcpfc_rfvFishHold CapacityThe total storage capacity of the fish holds aboard a vessel int(11)36YES
reference_wcpfc_rfvFishHold Cap UnitsThe measurement units used to measure fish hold capacityvarchar(30)3037YES
reference_wcpfc_rfvAuth TypeType of authoriation granted to the vesselvarchar(255)25538YES
reference_wcpfc_rfvAuth NumberThe unique identifier for the authorisationvarchar(255)25539YES
reference_wcpfc_rfvAuth AreaThe area the vessel is allwed to operate invarchar(255)25540YES
reference_wcpfc_rfvAuth SpeciesThe species that the vessel is authorised to catchvarchar(255)25541YES
reference_wcpfc_rfvAuth Period FromThe start of the authorised periodvarchar(255)25542YES
reference_wcpfc_rfvAuth Period ToThe end of the authorised periodvarchar(255)25543YES
reference_wcpfc_rfvPurse seine vessel authorised to tranship at seaIs the purse seine vessel authorised to tranship at seavarchar(255)25544YES
reference_wcpfc_rfvIMO-LRThe 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)45YES
reference_wcpfc_rfvAuthorisation to tranship on the high seasIs the vessel have authorisation to tranship in the high seas?varchar(255)25546YES
reference_wcpfc_rfvUnder CharterIs the vessel under chartervarchar(255)25547YES
reference_wcpfc_rfvCharterer NameName of the individual or organisation that is chartering the vessel varchar(255)25548YES
reference_wcpfc_rfvChartering CCMThe CCM (Commission Members, Cooperating Non-Members, and Participating Territories of the WCPFC) chartering the vesselvarchar(255)25549YES
reference_wcpfc_rfvAddress of CharterThe physical address of the individual or organisation that has chartered the vesselvarchar(255)25550YES
reference_wcpfc_rfvCharter Start DateThe start date of the vessel charterdate51YES
reference_wcpfc_rfvCharter End DateThe end date of the vessel charterdate52YES
reference_gear_type_attributeidUnique ID for gear type attribute entryint(10) unsignedPRI1NO
reference_gear_type_attributegear_type_idId that corresponds with the specific gear typeint(11)2YES
reference_gear_type_attributegear_type_attributeName of gear type attributevarchar(255)2553NO
reference_gear_type_attributegear_type_attribute_descriptionDescription of gear type attributevarchar(255)2554YES
reference_docsidUnique ID used to identify document entryint(11)PRI1NO
reference_docsdoc_typeThe type of document being issued by the system found in the reference_doc_type tablevarchar(30)302YES
reference_docsidentification_typename of identifiable documentvarchar(255)2553YES
regional_prosecutionsidint(11)PRI1NO
regional_prosecutionsdate_createddatetime2YES
regional_prosecutionsdate_updateddatetime3YES
regional_prosecutionsCasevarchar(255)2554YES
regional_prosecutionsCase_Outcomevarchar(120)1205YES
regional_prosecutionsFlag_Statevarchar(255)2556YES
regional_prosecutionsJurisdictionvarchar(255)2557YES
regional_prosecutionsFlag_State_Codechar(2)28YES
regional_prosecutionsJurisdiction_Codechar(2)29YES
regional_prosecutionsPlaintiffvarchar(255)25510YES
regional_prosecutionsDefendantvarchar(255)25511YES
regional_prosecutionsJudges_Namevarchar(255)25512YES
regional_prosecutionsDate_of_Judgement__Settlementdate13YES
regional_prosecutionsSettlement_Amountdecimal(32,4)14YES
regional_prosecutionsSubmitted_By_First_Namevarchar(255)25515YES
regional_prosecutionsSubmitted_By_Last_Namevarchar(255)25516YES
regional_prosecutionsEmailvarchar(255)25517YES
regional_prosecutionsVessel_Namevarchar(255)25518YES
regional_prosecutionsRegistry_Vessel_Namevarchar(255)25519YES
regional_prosecutionsVessel_Typevarchar(255)25520YES
regional_prosecutionsYear_Builtint(11)21YES
regional_prosecutionsIMOint(11)22YES
regional_prosecutionsMMSIint(11)23YES
regional_prosecutionsIRCSvarchar(20)2024YES
user_accountsidSystem generated unique identifier for the userint(11) unsignedPRI1NO
user_accountsuser_nameName of the uservarchar(255)2552YES
user_accountsuser_emailUsers email address. This is used as the user name to log into the systemvarchar(255)2553NO
user_accountsuser_passwordUsers passwordvarchar(255)2554NO
user_accountsuser_enabledHas the user been enabled in the systemtinyint(1)5YES
user_accountsuser_notesAny notes that you may have about the usertext655356YES
user_accountsuser_organisationThe organisation that the user is fromvarchar(255)2557YES
user_accountsuser_level_idThe users permission level within the systemint(11)8YES
reference_observerIDUnique ID given for Observer entryint(11)PRI1NO
reference_observerOBSERVER NAMEThe name of the observervarchar(255)2552YES
reference_observerOBSERVER SPC CODEA 3 character alphabet code issued by SPC to the observer as a unique identifierchar(3)33YES
reference_observerEMAILThe email address of the observervarchar(180)1804YES
reference_observerPHONEThe phone number of the obsservervarchar(40)405YES
reference_observerSS NUMBERThe observers social security numbervarchar(20)206YES
reference_observerJP VISAAn indication of whether the observer has a Japanese Visatinyint(4)7YES
reference_observerHOME PORTThe observers home portvarchar(60)608YES
reference_observerPORT CODEThe observers home port UNLOCDEchar(5)59YES
reference_observerCOUNTRYThe observers country / nationality char(2)210YES
reference_observerLOCATION3-letter FSM state code to identify where the Observer is fromchar(3)311YES
reference_observerCONTRACT NOThe observers contract numbervarchar(20)2012YES
reference_observerCONTRACT STARTThe observers contract start datedate13YES
reference_observerCONTRACT ENDThe observers contract end datedate14YES
reference_observerFIRST AIDAn indication of whether the observer have first aid trainingtinyint(4)15YES
reference_observerCPRAn indication of whether the observer is trained on CPRtinyint(4)16YES
reference_observerFIRE FIGHTINGAn indicaition of whether the observer is trained on fire fightingtinyint(4)17YES
reference_observerSEA SAFETYAn indicaition of whether the observer is trained on sea safetytinyint(4)18YES
reference_observerERAn indicaition of whether the observer is trained on electronic reportingtinyint(4)19YES
reference_observerEMAn indicaition of whether the observer is trained on electronic monitoringtinyint(4)20YES
reference_observerCE OBStinyint(4)21YES
reference_observerMSCAn indicaition of whether the observer is MSC Certifiedtinyint(4)22YES
reference_observerBIOLOGICALtinyint(4)23YES
reference_observerTRAINEE DEBRIEFERAn indicaition of whether the observer is a trainee debriefer tinyint(4)24YES
reference_observerDEBRIEFERAn indicaition of whether the observer is a debriefertinyint(4)25YES
reference_observerDONE PS TRIPSAn indicaition of whether the observer has done purse seine tripstinyint(4)26YES
reference_observerDONE LL TRIPSAn indicaition of whether the observer has done long lline tripstinyint(4)27YES
reference_observerDONE PL TRIPSAn indicaition of whether the observer has done pole and line tripstinyint(4)28YES
reference_observerCARRIER TRIPSAn indicaition of whether the observer has done carrier tripstinyint(4)29YES
reference_observerNOTESAny addtional notes on the observervarchar(255)25530YES
user_database_accessidUnique id for user database accessint(11) unsignedPRI1NO
user_database_accessuser_level_idLevel of the userint(11)2NO
user_database_accessuser_idUsers unique ID in the systemint(11)3NO
user_database_accesstitleName of the database to be accessedvarchar(255)2554YES
user_database_accesscredentialsDetails of the database credentialstext655355YES
user_database_accessdate_updatedDate the record was last updateddatetime6YES
user_database_accessip_addressThe IP Address of where the record was submitted fromvarchar(255)2557YES
reference_entity_typeidUnique ID used to identify entity entry int(11) unsignedPRI1NO
reference_entity_typeentity_typedistinct and independent objectsvarchar(120)1202NO
reference_entity_typeentity_classA list of the different types of entity that need to be tracked in a systemenum('ASSET','ENTITY')63YES
reference_companyidThe Company ID automatically generated by the databaseint(11)PRI1NO
reference_companycodeCode issued to the company by the systemvarchar(11)112YES
reference_companyorganisation_typeType of organisation (Association, Company)varchar(60)603YES
reference_companyorganisationName of the organisationvarchar(255)2554NO
reference_companycountryJurisdiction where the organisation was incorporatedvarchar(180)1805YES
reference_companycountry_codeISO 3166-1 alpha-2 country code for the jurisdiction where the organisation was incorporatedchar(2)26YES
reference_companyaddressPhysical address of the organisations head officevarchar(255)2557YES
reference_companycontact_nameContact person at the organisationvarchar(120)1208YES
reference_companyemailEmail address of the contact person at the companyvarchar(180)1809YES
reference_companyphonePhone number of the contact person at the companyvarchar(60)6010YES
reference_companyfaxFax number for the contact person at the companyvarchar(60)6011YES