Constraints

39 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
distribution_subscription_fkey
distribution.subscription
subscription.id
Cascade on delete
distribution_receive_unit_template_fkey
distribution.receive_unit_template
copy_template.id
Restrict delete
distribution_record_entry_fkey
distribution.record_entry
record_entry.id
Null on delete
distribution_bind_call_number_fkey
distribution.bind_call_number
call_number.id
Restrict delete
distribution_receive_call_number_fkey
distribution.receive_call_number
call_number.id
Restrict delete
distribution_holding_lib_fkey
distribution.holding_lib
org_unit.id
Restrict delete
distribution_bind_unit_template_fkey
distribution.bind_unit_template
copy_template.id
Restrict delete
serial_unit_call_number_fkey
unit.call_number
call_number.id
Restrict delete
serial_unit_creator_fkey
unit.creator
usr.id
Null on delete
serial_unit_editor_fkey
unit.editor
usr.id
Null on delete
distribution_note_distribution_fkey
distribution_note.distribution
distribution.id
Cascade on delete
distribution_note_creator_fkey
distribution_note.creator
usr.id
Restrict delete
item_note_item_fkey
item_note.item
item.id
Cascade on delete
item_note_creator_fkey
item_note.creator
usr.id
Restrict delete
subscription_record_entry_fkey
subscription.record_entry
record_entry.id
Null on delete
subscription_owning_lib_fkey
subscription.owning_lib
org_unit.id
Null on delete
stream_distribution_fkey
stream.distribution
distribution.id
Cascade on delete
index_summary_distribution_fkey
index_summary.distribution
distribution.id
Cascade on delete
supplement_summary_distribution_fkey
supplement_summary.distribution
distribution.id
Cascade on delete
caption_and_pattern_subscription_fkey
caption_and_pattern.subscription
subscription.id
Cascade on delete
materialized_holding_code_issuance_fkey
materialized_holding_code.issuance
issuance.id
Cascade on delete
routing_list_user_reader_fkey
routing_list_user.reader
usr.id
Cascade on delete
routing_list_user_stream_fkey
routing_list_user.stream
stream.id
Cascade on delete
basic_summary_distribution_fkey
basic_summary.distribution
distribution.id
Cascade on delete
item_creator_fkey
item.creator
usr.id
Restrict delete
item_issuance_fkey
item.issuance
issuance.id
Cascade on delete
item_stream_fkey
item.stream
stream.id
Cascade on delete
item_editor_fkey
item.editor
usr.id
Restrict delete
item_uri_fkey
item.uri
uri.id
Null on delete
item_unit_fkey
item.unit
unit.id
Null on delete
pattern_template_owning_lib_fkey
pattern_template.owning_lib
org_unit.id
Restrict delete
issuance_editor_fkey
issuance.editor
usr.id
Restrict delete
issuance_caption_and_pattern_fkey
issuance.caption_and_pattern
caption_and_pattern.id
Cascade on delete
issuance_creator_fkey
issuance.creator
usr.id
Restrict delete
issuance_subscription_fkey
issuance.subscription
subscription.id
Cascade on delete
record_entry_record_fkey
record_entry.record
record_entry.id
Null on delete
record_entry_owning_lib_fkey
record_entry.owning_lib
org_unit.id
Null on delete
subscription_note_creator_fkey
subscription_note.creator
usr.id
Restrict delete
subscription_note_subscription_fkey
subscription_note.subscription
subscription.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
distribution distribution_display_grouping_check ((display_grouping = ANY (ARRAY['enum'::text, 'chron'::text])))
distribution sdist_summary_method_check (((summary_method IS NULL) OR (summary_method = ANY (ARRAY['add_to_sre'::text, 'merge_with_sre'::text, 'use_sre_only'::text, 'use_sdist_only'::text]))))
unit copy_fine_level_check ((fine_level = ANY (ARRAY[1, 2, 3])))
unit copy_loan_duration_check ((loan_duration = ANY (ARRAY[1, 2, 3])))
caption_and_pattern cap_type ((type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text])))
routing_list_user reader_or_dept ((((reader IS NOT NULL) AND (department IS NULL)) OR ((reader IS NULL) AND (department IS NOT NULL))))
item valid_status ((status = ANY (ARRAY['Bindery'::text, 'Bound'::text, 'Claimed'::text, 'Discarded'::text, 'Expected'::text, 'Not Held'::text, 'Not Published'::text, 'Received'::text])))
issuance issuance_holding_code_check (((holding_code IS NULL) OR could_be_serial_holding_code(holding_code)))
issuance issuance_holding_code_check1 (((holding_code IS NULL) OR is_json(holding_code)))
issuance valid_holding_type (((holding_type IS NULL) OR (holding_type = ANY (ARRAY['basic'::text, 'supplement'::text, 'index'::text]))))