5.3 Shared code tables:
5.3.1 Table 1: t_survey_codes
Comment: Descriptions and codes used to identify the various surveys.
Attributes Data Type Null? Comment
survey character(5,1) No Survey code: 3 chars for region + 2 numerics for year .
proj_code character(12,1) Ministry of Fisheries Project code for the project that collected the data.
descrptn character(95,1) Description of the survey.
comments text(60,120,60,1)
Creator: dba
Indices: UNIQUE survey_pk ON (survey)
5.3.2 Table 2: t_zonef_codes
Comment: This table contains the codes and descriptions for the zone fished in during a fishing trip.
Attributes Data Type Null? Comment
fish_zone smallint No 2-digit code for the zone fished in during a fishing trip.
survey character(5,1) Survey code, 3 chars for region + 2 numerics for yr
descrptn character(80,1) Description of the code.
Creator: dba
Indices: UNIQUE zonef_ndx ON (fish_zone, survey)
NORMAL (2, 15) zfcode_ndx ON (fish_zone)
5.3.3 Table 3: t_locality_codes
Comment: Codes for locality name of place fished by 1996 diarist or northern ramp survey fisher.
Attributes Data Type Null? Comment
fish_loc character(3,1) No 3 char code for locality fished
fish_zone smallint Zone number 1 to 40 as used by 1996 National Diary survey
descrptn character(80,1) Description - Geographical name that the fish_loc derived from (followed by definition of the area).
Creator: dba
Indices: UNIQUE locality ndx ON (fish_loc)
5.3.4 Table 4: t_fishmeth_codes
Comment: This table contains the codes and descriptions for the types of fishing methods used during a fishing trip.
Attributes Data Type Null? Comment
fish_meth character(2,1) No 2-digit code for the type of fishing method used in a fishing trip.
meth_type smallint Code to identify which fishing method coding used.
descrptn character(80,1) Description of the code.
Creator: dba
Indices: UNIQUE fishmeth_codes_pk ON (meth_type, fish_meth)
5.3.5 Table 5: t_ramp_codes
Comment: Boat ramp codes for diary and boat ramp surveys
Attributes Data Type Null? Comment
ramp character(3,1) No 2 or 3 char boat ramp code (2 char codes as used by Northern [Auckland] boat ramp survey, also called Interview location code on boat ramp forms.
fish_zone smallint Fishing zone as used in the 1996 National Diary survey
descrptn character(80,1) Description ie ramp name as recorded by the diarist or boat ramp interviewer
Creator: dba
Indices: UNIQUE t_rmp_code_pk ON (ramp)
5.3.6 Table 6: t_boat_codes
Comment: This table contains the codes and descriptions for the types of boats used during a fishing trip.
Attributes Data Type Null? Comment
boat smallint 1-digit code for the type of boat used in a fishing trip, as used in t_effort.boat.
group_type character(1,1) 1 character code for the type of boat or group as used in t_group.group_type.
descrptn character(80,1) Description of the code.
Creator: dba