evergreen=# \d asset.copy_location
                                   Table "asset.copy_location"
    Column     |  Type   | Collation | Nullable |                     Default
---------------+---------+-----------+----------+-------------------------------------------------
 id            | integer |           | not null | nextval('asset.copy_location_id_seq'::regclass)
 name          | text    |           | not null |
 owning_lib    | integer |           | not null |
 holdable      | boolean |           | not null | true
 opac_visible  | boolean |           | not null | true
 circulate     | boolean |           | not null | true
 hold_verify   | boolean |           | not null | false
 label_prefix  | text    |           |          |
 label_suffix  | text    |           |          |
 checkin_alert | boolean |           | not null | false
 deleted       | boolean |           | not null | false
 url           | text    |           |          |
Indexes:
    "copy_location_pkey" PRIMARY KEY, btree (id)
    "acl_name_once_per_lib" UNIQUE, btree (name, owning_lib) WHERE deleted = false OR deleted IS FALSE
Foreign-key constraints:
    "copy_location_owning_lib_fkey" FOREIGN KEY (owning_lib) REFERENCES actor.org_unit(id)
Referenced by:
    TABLE "config.circ_limit_set_copy_loc_map" CONSTRAINT "circ_limit_set_copy_loc_map_copy_loc_fkey" FOREIGN KEY (copy_loc) REFERENCES asset.copy_location(id) ON UPDATE CASCADE ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
    TABLE "config.circ_matrix_matchpoint" CONSTRAINT "circ_matrix_matchpoint_copy_location_fkey" FOREIGN KEY (copy_location) REFERENCES asset.copy_location(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "action.circulation" CONSTRAINT "circulation_copy_location_fkey" FOREIGN KEY (copy_location) REFERENCES asset.copy_location(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "asset.copy" CONSTRAINT "copy_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "asset.copy_location_group_map" CONSTRAINT "copy_location_group_map_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
    TABLE "asset.copy_location_order" CONSTRAINT "copy_location_order_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
    TABLE "asset.copy_template" CONSTRAINT "copy_template_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id) DEFERRABLE INITIALLY DEFERRED
    TABLE "asset.course_module_course_materials" CONSTRAINT "course_module_course_materials_original_location_fkey" FOREIGN KEY (original_location) REFERENCES asset.copy_location(id)
    TABLE "acq.distribution_formula_entry" CONSTRAINT "distribution_formula_entry_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id)
    TABLE "acq.lineitem_detail" CONSTRAINT "lineitem_detail_location_fkey" FOREIGN KEY (location) REFERENCES asset.copy_location(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
    TABLE "actor.org_unit_proximity_adjustment" CONSTRAINT "org_unit_proximity_adjustment_copy_location_fkey" FOREIGN KEY (copy_location) REFERENCES asset.copy_location(id)
Rules:
    protect_copy_location_delete AS
    ON DELETE TO asset.copy_location DO INSTEAD ( SELECT asset.check_delete_copy_location(old.id) AS check_delete_copy_location;
 UPDATE asset.copy_location SET deleted = true
  WHERE old.id = copy_location.id;
 UPDATE acq.lineitem_detail SET location = NULL::integer
  WHERE lineitem_detail.location = old.id;
 DELETE FROM asset.copy_location_order
  WHERE copy_location_order.location = old.id;
 DELETE FROM asset.copy_location_group_map
  WHERE copy_location_group_map.location = old.id;
 DELETE FROM config.circ_limit_set_copy_loc_map
  WHERE circ_limit_set_copy_loc_map.copy_loc = old.id;
)
Triggers:
    acpl_validate_edit BEFORE UPDATE ON asset.copy_location FOR EACH ROW EXECUTE PROCEDURE asset.copy_location_validate_edit()
    audit_asset_copy_location_update_trigger AFTER DELETE OR UPDATE ON asset.copy_location FOR EACH ROW EXECUTE PROCEDURE auditor.audit_asset_copy_location_func()