Constraints

23 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
user_request_preference__t_user_id_fkey
user_request_preference__t.user_id
users__t.id
Restrict delete
user_request_preference__t_default_service_point_id_fkey
user_request_preference__t.default_service_point_id
service_point__t.id
Restrict delete
check_in__t_item_location_id_fkey
check_in__t.item_location_id
location__t.id
Restrict delete
check_in__t_service_point_id_fkey
check_in__t.service_point_id
service_point__t.id
Restrict delete
check_in__t_performed_by_user_id_fkey
check_in__t.performed_by_user_id
users__t.id
Restrict delete
request__t_cancellation_reason_id_fkey
request__t.cancellation_reason_id
cancellation_reason__t.id
Restrict delete
request__t_requester_id_fkey
request__t.requester_id
users__t.id
Restrict delete
request__t_pickup_service_point_id_fkey
request__t.pickup_service_point_id
service_point__t.id
Restrict delete
request__t_cancelled_by_user_id_fkey
request__t.cancelled_by_user_id
users__t.id
Restrict delete
patron_action_session__t_patron_id_fkey
patron_action_session__t.patron_id
users__t.id
Restrict delete
patron_action_session__t_loan_id_fkey
patron_action_session__t.loan_id
loan__t.id
Restrict delete
scheduled_notice__t_recipient_user_id_fkey
scheduled_notice__t.recipient_user_id
users__t.id
Restrict delete
scheduled_notice__t_fee_fine_action_id_fkey
scheduled_notice__t.fee_fine_action_id
feefineactions__t.id
Restrict delete
scheduled_notice__t_request_id_fkey
scheduled_notice__t.request_id
request__t.id
Restrict delete
scheduled_notice__t_loan_id_fkey
scheduled_notice__t.loan_id
loan__t.id
Restrict delete
loan__t_proxy_user_id_fkey
loan__t.proxy_user_id
users__t.id
Restrict delete
loan__t_checkout_service_point_id_fkey
loan__t.checkout_service_point_id
service_point__t.id
Restrict delete
loan__t_loan_policy_id_fkey
loan__t.loan_policy_id
loan_policy__t.id
Restrict delete
loan__t_item_effective_location_id_at_check_out_fkey
loan__t.item_effective_location_id_at_check_out
location__t.id
Restrict delete
loan__t_checkin_service_point_id_fkey
loan__t.checkin_service_point_id
service_point__t.id
Restrict delete
loan__t_lost_item_policy_id_fkey
loan__t.lost_item_policy_id
lost_item_fee_policy__t.id
Restrict delete
loan__t_overdue_fine_policy_id_fkey
loan__t.overdue_fine_policy_id
overdue_fine_policy__t.id
Restrict delete
loan__t_patron_group_id_at_checkout_fkey
loan__t.patron_group_id_at_checkout
groups__t.id
Restrict delete

Check Constraints

Table Constraint Name Constraint