Constraints

60 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
population_t_group_fkey
population.t_group
population.name
Restrict delete
survey_index_areacell_id_fkey
survey_index.areacell_id
areacell.areacell_id
Restrict delete
survey_index_index_type_id_fkey
survey_index.index_type_id
index_type.index_type_id
Restrict delete
survey_index_data_source_id_fkey
survey_index.data_source_id
data_source.data_source_id
Restrict delete
trip_start_port_id_fkey
trip.start_port_id
port.port_id
Restrict delete
trip_end_port_id_fkey
trip.end_port_id
port.port_id
Restrict delete
trip_t_group_fkey
trip.t_group
trip.name
Restrict delete
vessel_t_group_fkey
vessel.t_group
vessel.name
Restrict delete
vessel_vessel_owner_id_fkey
vessel.vessel_owner_id
vessel_owner.vessel_owner_id
Restrict delete
vessel_vessel_type_id_fkey
vessel.vessel_type_id
vessel_type.vessel_type_id
Restrict delete
sex_t_group_fkey
sex.t_group
sex.name
Restrict delete
species_t_group_fkey
species.t_group
species.name
Restrict delete
data_source_t_group_fkey
data_source.t_group
data_source.name
Restrict delete
division_areacell_id_fkey
division.areacell_id
areacell.areacell_id
Restrict delete
predator_trip_id_fkey
predator.trip_id
trip.trip_id
Restrict delete
predator_institute_id_fkey
predator.institute_id
institute.institute_id
Restrict delete
predator_sex_id_fkey
predator.sex_id
sex.sex_id
Restrict delete
predator_vessel_id_fkey
predator.vessel_id
vessel.vessel_id
Restrict delete
predator_tow_id_fkey
predator.tow_id
tow.tow_id
Restrict delete
predator_gear_id_fkey
predator.gear_id
gear.gear_id
Restrict delete
predator_stomach_state_id_fkey
predator.stomach_state_id
stomach_state.stomach_state_id
Restrict delete
predator_species_id_fkey
predator.species_id
species.species_id
Restrict delete
predator_maturity_stage_id_fkey
predator.maturity_stage_id
maturity_stage.maturity_stage_id
Restrict delete
predator_areacell_id_fkey
predator.areacell_id
areacell.areacell_id
Restrict delete
predator_data_source_id_fkey
predator.data_source_id
data_source.data_source_id
Restrict delete
predator_sampling_type_id_fkey
predator.sampling_type_id
sampling_type.sampling_type_id
Restrict delete
index_type_t_group_fkey
index_type.t_group
index_type.name
Restrict delete
vessel_type_t_group_fkey
vessel_type.t_group
vessel_type.name
Restrict delete
prey_predator_id_fkey
prey.predator_id
predator.predator_id
Restrict delete
prey_species_id_fkey
prey.species_id
species.species_id
Restrict delete
prey_digestion_stage_id_fkey
prey.digestion_stage_id
digestion_stage.digestion_stage_id
Restrict delete
sampling_type_t_group_fkey
sampling_type.t_group
sampling_type.name
Restrict delete
bait_type_t_group_fkey
bait_type.t_group
bait_type.name
Restrict delete
net_type_t_group_fkey
net_type.t_group
net_type.name
Restrict delete
port_t_group_fkey
port.t_group
port.name
Restrict delete
port_institute_id_fkey
port.institute_id
institute.institute_id
Restrict delete
case_study_t_group_fkey
case_study.t_group
case_study.name
Restrict delete
stomach_state_t_group_fkey
stomach_state.t_group
stomach_state.name
Restrict delete
gear_t_group_fkey
gear.t_group
gear.name
Restrict delete
maturity_stage_t_group_fkey
maturity_stage.t_group
maturity_stage.name
Restrict delete
sample_sampling_type_id_fkey
sample.sampling_type_id
sampling_type.sampling_type_id
Restrict delete
sample_tow_id_fkey
sample.tow_id
tow.tow_id
Restrict delete
sample_vessel_id_fkey
sample.vessel_id
vessel.vessel_id
Restrict delete
sample_trip_id_fkey
sample.trip_id
trip.trip_id
Restrict delete
sample_species_id_fkey
sample.species_id
species.species_id
Restrict delete
sample_population_id_fkey
sample.population_id
population.population_id
Restrict delete
sample_gear_id_fkey
sample.gear_id
gear.gear_id
Restrict delete
sample_sex_id_fkey
sample.sex_id
sex.sex_id
Restrict delete
sample_areacell_id_fkey
sample.areacell_id
areacell.areacell_id
Restrict delete
sample_institute_id_fkey
sample.institute_id
institute.institute_id
Restrict delete
sample_data_source_id_fkey
sample.data_source_id
data_source.data_source_id
Restrict delete
sample_maturity_stage_id_fkey
sample.maturity_stage_id
maturity_stage.maturity_stage_id
Restrict delete
vessel_owner_t_group_fkey
vessel_owner.t_group
vessel_owner.name
Restrict delete
areacell_t_group_fkey
areacell.t_group
areacell.name
Restrict delete
institute_t_group_fkey
institute.t_group
institute.name
Restrict delete
digestion_stage_t_group_fkey
digestion_stage.t_group
digestion_stage.name
Restrict delete
market_category_t_group_fkey
market_category.t_group
market_category.name
Restrict delete
tow_t_group_fkey
tow.t_group
tow.name
Restrict delete
tow_bait_type_id_fkey
tow.bait_type_id
bait_type.bait_type_id
Restrict delete
tow_net_type_id_fkey
tow.net_type_id
net_type.net_type_id
Restrict delete

Check Constraints

Table Constraint Name Constraint
predator predator_month_check (((month >= 1) AND (month <= 12)))
sample sample_month_check (((month >= 1) AND (month <= 12)))