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
|