Constraints

14 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
synchronization_jobs__t_user_id_fkey
synchronization_jobs__t.user_id
users__t.id
Restrict delete
item_declared_lost_event__t_loan_id_fkey
item_declared_lost_event__t.loan_id
loan__t.id
Restrict delete
item_declared_lost_event__t_user_id_fkey
item_declared_lost_event__t.user_id
users__t.id
Restrict delete
loan_due_date_changed_event__t_loan_id_fkey
loan_due_date_changed_event__t.loan_id
loan__t.id
Restrict delete
loan_due_date_changed_event__t_user_id_fkey
loan_due_date_changed_event__t.user_id
users__t.id
Restrict delete
item_aged_to_lost_event__t_loan_id_fkey
item_aged_to_lost_event__t.loan_id
loan__t.id
Restrict delete
patron_block_limits__t_patron_group_id_fkey
patron_block_limits__t.patron_group_id
groups__t.id
Restrict delete
patron_block_limits__t_condition_id_fkey
patron_block_limits__t.condition_id
patron_block_conditions__t.id
Restrict delete
item_checked_in_event__t_loan_id_fkey
item_checked_in_event__t.loan_id
loan__t.id
Restrict delete
item_checked_in_event__t_user_id_fkey
item_checked_in_event__t.user_id
users__t.id
Restrict delete
item_checked_out_event__t_loan_id_fkey
item_checked_out_event__t.loan_id
loan__t.id
Restrict delete
item_claimed_returned_event__t_loan_id_fkey
item_claimed_returned_event__t.loan_id
loan__t.id
Restrict delete
item_claimed_returned_event__t_user_id_fkey
item_claimed_returned_event__t.user_id
users__t.id
Restrict delete
fee_fine_balance_changed_event__t_fee_fine_id_fkey
fee_fine_balance_changed_event__t.fee_fine_id
accounts__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint