Constraints

34 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

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

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

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

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

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

Cascade on delete

carousel_org_unit_org_unit_fkey

carousel_org_unit.org_unit

Restrict delete

carousel_org_unit_carousel_fkey

carousel_org_unit.carousel

Cascade on delete

user_bucket_owning_lib_fkey

user_bucket.owning_lib

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.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

Restrict delete

copy_bucket_note_bucket_fkey

copy_bucket_note.bucket

Cascade on delete

copy_bucket_item_bucket_fkey

copy_bucket_item.bucket

Cascade on delete

copy_bucket_owning_lib_fkey

copy_bucket.owning_lib

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_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