Constraints

20 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
reservation_target_resource_fkey
reservation.target_resource
resource.id
Cascade on delete
booking_reservation_usr_fkey
reservation.usr
usr.id
Restrict delete
reservation_target_resource_type_fkey
reservation.target_resource_type
resource_type.id
Cascade on delete
reservation_pickup_lib_fkey
reservation.pickup_lib
org_unit.id
Restrict delete
reservation_current_resource_fkey
reservation.current_resource
resource.id
Cascade on delete
reservation_request_lib_fkey
reservation.request_lib
org_unit.id
Restrict delete
reservation_capture_staff_fkey
reservation.capture_staff
usr.id
Restrict delete
resource_attr_value_owner_fkey
resource_attr_value.owner
org_unit.id
Restrict delete
resource_attr_value_attr_fkey
resource_attr_value.attr
resource_attr.id
Restrict delete
reservation_attr_value_map_reservation_fkey
reservation_attr_value_map.reservation
reservation.id
Cascade on delete
reservation_attr_value_map_attr_value_fkey
reservation_attr_value_map.attr_value
resource_attr_value.id
Cascade on delete
resource_attr_owner_fkey
resource_attr.owner
org_unit.id
Restrict delete
resource_attr_resource_type_fkey
resource_attr.resource_type
resource_type.id
Cascade on delete
resource_type_owner_fkey
resource_type.owner
org_unit.id
Restrict delete
resource_type_record_fkey
resource_type.record
record_entry.id
Restrict delete
resource_attr_map_value_fkey
resource_attr_map.value
resource_attr_value.id
Restrict delete
resource_attr_map_resource_attr_fkey
resource_attr_map.resource_attr
resource_attr.id
Cascade on delete
resource_attr_map_resource_fkey
resource_attr_map.resource
resource.id
Cascade on delete
resource_type_fkey
resource.type
resource_type.id
Restrict delete
resource_owner_fkey
resource.owner
org_unit.id
Restrict delete

Check Constraints

Table Constraint Name Constraint