|
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
|