predator

0 rows


Description

Predators in predator/prey sample

Columns

Column Type Size Nulls Auto Default Children Parents Comments
predator_id serial 10 √ nextval('examples.predator_predator_id_seq'::regclass)
prey.predator_id prey_predator_id_fkeyR
data_source_id int4 10 null
data_source.data_source_id predator_data_source_id_fkeyR
institute_id int4 10 √ null
institute.institute_id predator_institute_id_fkeyR

Institute that undertook survey
gear_id int4 10 √ null
gear.gear_id predator_gear_id_fkeyR

Gear used
vessel_id int4 10 √ null
vessel.vessel_id predator_vessel_id_fkeyR

Vessel used
trip_id int4 10 √ null
trip.trip_id predator_trip_id_fkeyR

Part of trip
tow_id int4 10 √ null
tow.tow_id predator_tow_id_fkeyR

Tow used
sampling_type_id int4 10 √ null
sampling_type.sampling_type_id predator_sampling_type_id_fkeyR

Sampling type
year int4 10 null

Year sample was undertaken
month int4 10 null

Month sample was undertaken
areacell_id int4 10 √ null
areacell.areacell_id predator_areacell_id_fkeyR

Areacell data relates to
stomach_name varchar 128 null

Stomach identifier
species_id int8 19 √ null
species.species_id predator_species_id_fkeyR
age numeric 10,5 √ null

Age (years)
sex_id int4 10 √ null
sex.sex_id predator_sex_id_fkeyR

Sex ID
maturity_stage_id int4 10 √ null
maturity_stage.maturity_stage_id predator_maturity_stage_id_fkeyR

Maturity Stage ID
stomach_state_id int4 10 √ null
stomach_state.stomach_state_id predator_stomach_state_id_fkeyR

Status of stomach when caught
length float4 8,8 √ null

Length of predator
weight float4 8,8 √ null

Weight of predator

Indexes

Constraint Name Type Sort Column(s)
predator_pkey Primary key Asc predator_id

Check Constraints

Constraint Name Constraint
predator_month_check (((month >= 1) AND (month <= 12)))

Relationships

Close relationships within degrees of separation