asset.copy_location

↑ asset schema

Soft Deletes: This table uses a deleted boolean flag rather than physical row deletion. Ad-hoc queries must include WHERE deleted = false to exclude logically-deleted rows. The application layer enforces this automatically; direct SQL does not.

Data-Modifying Triggers: This table has BEFORE ROW trigger(s) that modify row data before write. Values you INSERT or UPDATE may differ from what is actually stored. See the Triggers section below.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: copy_location_owning_lib_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('asset.copy_location_id_seq'::regclass)
name	`text`	No
owning_lib FK	`integer`	No		→ actor.org_unit(id)
holdable	`boolean`	No	true
hold_verify	`boolean`	No	false
opac_visible	`boolean`	No	true
circulate	`boolean`	No	true
label_prefix	`text`	Yes
label_suffix	`text`	Yes
checkin_alert	`boolean`	No	false
deleted SOFT-DEL	`boolean`	No	false
url	`text`	Yes

id PK

integer

nextval('asset.copy_location_id_seq'::regclass)

name

text

owning_lib FK

integer

→ actor.org_unit(id)

holdable

boolean

true

hold_verify

boolean

false

opac_visible

boolean

true

circulate

boolean

true

label_prefix

text

Yes

label_suffix

text

Yes

checkin_alert

boolean

false

deleted SOFT-DEL

boolean

false

url

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owning_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`copy_location_owning_lib_fkey`

owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

copy_location_owning_lib_fkey

Indexes

Index Method Definition

Index	Method	Definition
`copy_location_pkey` PK	btree	`CREATE UNIQUE INDEX copy_location_pkey ON asset.copy_location USING btree (id)`
`acl_name_once_per_lib` UNIQUE	btree	`CREATE UNIQUE INDEX acl_name_once_per_lib ON asset.copy_location USING btree (name, owning_lib) WHERE deleted = false) OR (deleted IS FALSE`

copy_location_pkey PK

btree

CREATE UNIQUE INDEX copy_location_pkey ON asset.copy_location USING btree (id)

acl_name_once_per_lib UNIQUE

btree

CREATE UNIQUE INDEX acl_name_once_per_lib ON asset.copy_location USING btree (name, owning_lib) WHERE deleted = false) OR (deleted IS FALSE

Triggers

Trigger Timing Event Level Function

Trigger	Timing	Event	Level	Function
`acpl_validate_edit`	BEFORE	UPDATE	ROW	`asset.copy_location_validate_edit()`

acpl_validate_edit

BEFORE

UPDATE

ROW

asset.copy_location_validate_edit()

Trigger Bodies

acpl_validate_edit

Function: asset.copy_location_validate_edit()
Timing: BEFORE UPDATE ROW

This trigger modifies the row before it is written (returns a modified NEW).

BEGIN
    IF OLD.id = 1 THEN
        IF OLD.owning_lib != NEW.owning_lib OR NEW.deleted THEN
            RAISE EXCEPTION 'Copy location 1 cannot be moved or deleted';
        END IF;
    END IF;
    RETURN NEW;
END;

Referenced By

The following tables have foreign keys pointing to asset.copy_location (12 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.distribution_formula_entry	`location`	`id`	`distribution_formula_entry_location_fkey`
acq.lineitem_detail	`location`	`id`	`lineitem_detail_location_fkey`
action.circulation	`copy_location`	`id`	`circulation_copy_location_fkey`
actor.org_unit_proximity_adjustment	`copy_location`	`id`	`actor_org_unit_proximity_copy_location_fkey`
asset.copy	`location`	`id`	`copy_location_fkey`
asset.copy_location_group_map	`location`	`id`	`copy_location_group_map_location_fkey`
asset.copy_location_order	`location`	`id`	`copy_location_order_location_fkey`
asset.copy_template	`location`	`id`	`copy_template_location_fkey`
asset.course_module_course_materials	`original_location`	`id`	`course_module_course_materials_original_location_fkey`
config.circ_limit_set_copy_loc_map	`copy_loc`	`id`	`circ_limit_set_copy_loc_map_copy_loc_fkey`
config.circ_matrix_matchpoint	`copy_location`	`id`	`circ_matrix_matchpoint_copy_location_fkey`
config.hold_matrix_matchpoint	`copy_location`	`id`	`hold_matrix_matchpoint_copy_location_fkey`