Constraints

31 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
statistical_code__t_statistical_code_type_id_fkey
statistical_code__t.statistical_code_type_id
statistical_code_type__t.id
Restrict delete
service_point_user__t_user_id_fkey
service_point_user__t.user_id
users__t.id
Restrict delete
service_point_user__t_default_service_point_id_fkey
service_point_user__t.default_service_point_id
service_point__t.id
Restrict delete
location__t_primary_service_point_fkey
location__t.primary_service_point
service_point__t.id
Restrict delete
location__t_library_id_fkey
location__t.library_id
loclibrary__t.id
Restrict delete
location__t_institution_id_fkey
location__t.institution_id
locinstitution__t.id
Restrict delete
location__t_campus_id_fkey
location__t.campus_id
loccampus__t.id
Restrict delete
loccampus__t_institution_id_fkey
loccampus__t.institution_id
locinstitution__t.id
Restrict delete
holdings_record__t_temporary_location_id_fkey
holdings_record__t.temporary_location_id
location__t.id
Restrict delete
holdings_record__t_instance_id_fkey
holdings_record__t.instance_id
instance__t.id
Restrict delete
holdings_record__t_effective_location_id_fkey
holdings_record__t.effective_location_id
location__t.id
Restrict delete
holdings_record__t_permanent_location_id_fkey
holdings_record__t.permanent_location_id
location__t.id
Restrict delete
holdings_record__t_holdings_type_id_fkey
holdings_record__t.holdings_type_id
holdings_type__t.id
Restrict delete
holdings_record__t_call_number_type_id_fkey
holdings_record__t.call_number_type_id
call_number_type__t.id
Restrict delete
holdings_record__t_source_id_fkey
holdings_record__t.source_id
holdings_records_source__t.id
Restrict delete
instance__t_instance_type_id_fkey
instance__t.instance_type_id
instance_type__t.id
Restrict delete
instance__t_mode_of_issuance_id_fkey
instance__t.mode_of_issuance_id
mode_of_issuance__t.id
Restrict delete
instance__t_status_id_fkey
instance__t.status_id
instance_status__t.id
Restrict delete
loclibrary__t_campus_id_fkey
loclibrary__t.campus_id
loccampus__t.id
Restrict delete
preceding_succeeding_title__t_preceding_instance_id_fkey
preceding_succeeding_title__t.preceding_instance_id
instance__t.id
Restrict delete
preceding_succeeding_title__t_succeeding_instance_id_fkey
preceding_succeeding_title__t.succeeding_instance_id
instance__t.id
Restrict delete
item__t_holdings_record_id_fkey
item__t.holdings_record_id
holdings_record__t.id
Restrict delete
item__t_temporary_loan_type_id_fkey
item__t.temporary_loan_type_id
loan_type__t.id
Restrict delete
item__t_permanent_location_id_fkey
item__t.permanent_location_id
location__t.id
Restrict delete
item__t_effective_location_id_fkey
item__t.effective_location_id
location__t.id
Restrict delete
item__t_permanent_loan_type_id_fkey
item__t.permanent_loan_type_id
loan_type__t.id
Restrict delete
item__t_item_level_call_number_type_id_fkey
item__t.item_level_call_number_type_id
call_number_type__t.id
Restrict delete
item__t_in_transit_destination_service_point_id_fkey
item__t.in_transit_destination_service_point_id
service_point__t.id
Restrict delete
item__t_item_damaged_status_id_fkey
item__t.item_damaged_status_id
item_damaged_status__t.id
Restrict delete
item__t_temporary_location_id_fkey
item__t.temporary_location_id
location__t.id
Restrict delete
item__t_material_type_id_fkey
item__t.material_type_id
material_type__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint