Documemtation

TABLE reference_wcpfc_rfv
TABLE COMMENT Record of Fishing vessel from the WCPFC
ROWS 3502
COLUMN
COMMENT
TYPE
LENGTH
COLUMN KEY
POSITION
IS NULL
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