Constraints

38 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
call_number_bucket_owner_fkey
call_number_bucket.owner
usr.id
Cascade on delete
call_number_bucket_btype_fkey
call_number_bucket.btype
call_number_bucket_type.code
Restrict delete
call_number_bucket_owning_lib_fkey
call_number_bucket.owning_lib
org_unit.id
Cascade on delete
call_number_bucket_note_bucket_fkey
call_number_bucket_note.bucket
call_number_bucket.id
Cascade on delete
user_bucket_item_note_item_fkey
user_bucket_item_note.item
user_bucket_item.id
Cascade on delete
call_number_bucket_item_target_call_number_fkey
call_number_bucket_item.target_call_number
call_number.id
Cascade on delete
call_number_bucket_item_bucket_fkey
call_number_bucket_item.bucket
call_number_bucket.id
Cascade on delete
biblio_record_entry_bucket_owning_lib_fkey
biblio_record_entry_bucket.owning_lib
org_unit.id
Cascade on delete
biblio_record_entry_bucket_owner_fkey
biblio_record_entry_bucket.owner
usr.id
Cascade on delete
biblio_record_entry_bucket_btype_fkey
biblio_record_entry_bucket.btype
biblio_record_entry_bucket_type.code
Restrict delete
biblio_record_entry_bucket_usr_flags_usr_fkey
biblio_record_entry_bucket_usr_flags.usr
usr.id
Cascade on delete
biblio_record_entry_bucket_usr_flags_bucket_fkey
biblio_record_entry_bucket_usr_flags.bucket
biblio_record_entry_bucket.id
Cascade on delete
call_number_bucket_item_note_item_fkey
call_number_bucket_item_note.item
call_number_bucket_item.id
Cascade on delete
user_bucket_item_bucket_fkey
user_bucket_item.bucket
user_bucket.id
Cascade on delete
user_bucket_item_target_user_fkey
user_bucket_item.target_user
usr.id
Cascade on delete
user_bucket_note_bucket_fkey
user_bucket_note.bucket
user_bucket.id
Cascade on delete
carousel_org_unit_org_unit_fkey
carousel_org_unit.org_unit
org_unit.id
Restrict delete
carousel_org_unit_carousel_fkey
carousel_org_unit.carousel
carousel.id
Cascade on delete
user_bucket_owning_lib_fkey
user_bucket.owning_lib
org_unit.id
Cascade on delete
user_bucket_owner_fkey
user_bucket.owner
usr.id
Cascade on delete
user_bucket_btype_fkey
user_bucket.btype
user_bucket_type.code
Restrict delete
copy_bucket_item_note_item_fkey
copy_bucket_item_note.item
copy_bucket_item.id
Cascade on delete
carousel_type_fkey
carousel.type
carousel_type.id
Restrict delete
carousel_bucket_fkey
carousel.bucket
biblio_record_entry_bucket.id
Restrict delete
carousel_creator_fkey
carousel.creator
usr.id
Restrict delete
carousel_editor_fkey
carousel.editor
usr.id
Restrict delete
carousel_owner_fkey
carousel.owner
org_unit.id
Restrict delete
copy_bucket_note_bucket_fkey
copy_bucket_note.bucket
copy_bucket.id
Cascade on delete
copy_bucket_item_bucket_fkey
copy_bucket_item.bucket
copy_bucket.id
Cascade on delete
copy_bucket_owning_lib_fkey
copy_bucket.owning_lib
org_unit.id
Cascade on delete
copy_bucket_owner_fkey
copy_bucket.owner
usr.id
Cascade on delete
copy_bucket_btype_fkey
copy_bucket.btype
copy_bucket_type.code
Restrict delete
biblio_record_entry_bucket_shares_bucket_fkey
biblio_record_entry_bucket_shares.bucket
biblio_record_entry_bucket.id
Cascade on delete
biblio_record_entry_bucket_shares_share_org_fkey
biblio_record_entry_bucket_shares.share_org
org_unit.id
Cascade on delete
biblio_record_entry_bucket_item_bucket_fkey
biblio_record_entry_bucket_item.bucket
biblio_record_entry_bucket.id
Cascade on delete
biblio_record_entry_bucket_item_target_biblio_record_entry_fkey
biblio_record_entry_bucket_item.target_biblio_record_entry
record_entry.id
Cascade on delete
biblio_record_entry_bucket_item_note_item_fkey
biblio_record_entry_bucket_item_note.item
biblio_record_entry_bucket_item.id
Cascade on delete
biblio_record_entry_bucket_note_bucket_fkey
biblio_record_entry_bucket_note.bucket
biblio_record_entry_bucket.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint