5 Nonfish_bycatch tables
The following are listings of the tables in the nonfish_bycatch
database, including attribute names, data types (and any range
restrictions), and comments.
5.1 t_trip
Contains header information for each trip event.
|
Attribute Name
|
Attribute Data Type
|
Description
|
|
trip_key
|
longinteger
|
Primary key using sequential trip key value
|
|
vessel_key
|
longinteger
|
Mfish identification number of the fishing vessel
|
|
start_date
|
date(0)
|
Start date for a trip
|
|
end_date
|
date(0)
|
End date for a trip
|
|
observer
|
character(32,1)
|
Indicates if observer was present and type
|
|
signature
|
character(1,1)
|
Indicates if form was signed (Y=Yes, N=No)
|
|
comments
|
character(40,1)
|
Comments added in loading process
|
|
Indexed Attribute
|
Index type
|
Description
|
|
trip_key
|
BTREE
|
Primary key
|
|
vessel_key
|
BTREE
|
Normal
|
5.2 t_station
Contains details for stations with nonfish bycatch, including
target_sp, fishing method, date and position.
|
Attribute Name
|
Attribute Data Type
|
Description
|
|
station_key
|
longinteger
|
Primary key used to identify a sequential number for each tow
made during a trip
|
|
trip_key
|
longinteger
|
Foreign key to reference
|
|
t_trip target_sp
|
character(3,1)
|
Target fish species fishing
|
|
method
|
character(3,1)
|
Code for fishing method used
|
|
datetime
|
time(0)
|
Date and time when incident occurred (24-hour format, NZDT)
|
|
latitude
|
decimal(8,6)
|
Decimalised latitude of vessel when animal was bought on board
|
|
longitude
|
decimal(9,6)
|
Decimalised longitude of vessel when animal was bought on
board (in degrees east of Greenwich)
|
|
comments
|
character(40,1)
|
Comments added in loading process
|
|
Indexed Attribute
|
Index type
|
Description
|
|
station_key
|
TIMESERIES
|
Primary key
|
|
trip_key
|
BTREE
|
Foreign key, refer t_trip(trip_key)
|
|
target_sp
|
BTREE
|
Foreign key, refer rdb:curr_spp(code)
|
5.3 t_catch
Contains each unit of catch recorded in Non-Fish Incidential Catch
Reporting Form
|
Attribute Name
|
Attribute Data Type
|
Description
|
|
catch_key
|
longinteger
|
Primary key generated from a counter
|
|
trip_key
|
longinteger
|
Redundant key for reference t_trip, no foreign key constraint
is applied
|
|
station_key
|
longinteger
|
Foreign key to reference t_station
|
|
species
|
character(3,1)
|
3 character species code
|
|
number_caught
|
Interger
|
The number caught for this fishing event sex character(1,1)
0=unsexed, 1=male, 2=female, 3=unknown (unable to determine)
|
|
alive
|
character(1,1)
|
Records animals status (A=Alive, D=Dead)
|
|
retained
|
character(1,1)
|
Records if species was retained on board (Y=Yes, N=No)
|
|
comments
|
character(40,1)
|
Comments added in loading process
|
|
Indexed Attribute
|
Index type
|
Description
|
|
catch_key
|
TIMESERIES
|
Primary key
|
|
station_key
|
BTREE
|
Foreign key, refer t_station(station_key)
|