actor.org_unit_proximity_adjustment

↑ actor schema

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.org_unit_proximity_adjustment_id_seq'::regclass)

item_circ_lib FK

integer

Yes

→ actor.org_unit(id)

item_owning_lib FK

integer

Yes

→ actor.org_unit(id)

copy_location FK

integer

Yes

→ asset.copy_location(id)

hold_pickup_lib FK

integer

Yes

→ actor.org_unit(id)

hold_request_lib FK

integer

Yes

→ actor.org_unit(id)

pos

integer

No

0

absolute_adjustment

boolean

No

false

prox_adjustment

numeric

Yes

circ_mod FK

text

Yes

→ config.circ_modifier(code)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

circ_mod

config.circ_modifier(code)

NO ACTION

NO ACTION

DEFERRED

actor_org_unit_proximity_adjustment_circ_mod_fkey

copy_location

asset.copy_location(id)

NO ACTION

NO ACTION

DEFERRED

actor_org_unit_proximity_copy_location_fkey

hold_pickup_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

org_unit_proximity_adjustment_hold_pickup_lib_fkey

hold_request_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

org_unit_proximity_adjustment_hold_request_lib_fkey

item_circ_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

org_unit_proximity_adjustment_item_circ_lib_fkey

item_owning_lib

actor.org_unit(id)

NO ACTION

NO ACTION

No

org_unit_proximity_adjustment_item_owning_lib_fkey

Check Constraints

  • prox_adj_criterium: CHECK COALESCE((item_circ_lib)::text, (item_owning_lib)::text, (copy_location)::text, (hold_pickup_lib)::text, (hold_request_lib)::text, circ_mod) IS NOT NULL

Indexes

Index Method Definition

org_unit_proximity_adjustment_pkey PK

btree

CREATE UNIQUE INDEX org_unit_proximity_adjustment_pkey ON actor.org_unit_proximity_adjustment USING btree (id)

prox_adj_once_idx UNIQUE

btree

CREATE UNIQUE INDEX prox_adj_once_idx ON actor.org_unit_proximity_adjustment USING btree (COALESCE(item_circ_lib, '-1'::integer), COALESCE(item_owning_lib, '-1'::integer), COALESCE(copy_location, '-1'::integer), COALESCE(hold_pickup_lib, '-1'::integer), COALESCE(hold_request_lib, '-1'::integer), COALESCE(circ_mod, ''::text), pos)

prox_adj_circ_lib_idx

btree

CREATE INDEX prox_adj_circ_lib_idx ON actor.org_unit_proximity_adjustment USING btree (item_circ_lib)

prox_adj_circ_mod_idx

btree

CREATE INDEX prox_adj_circ_mod_idx ON actor.org_unit_proximity_adjustment USING btree (circ_mod)

prox_adj_copy_location_idx

btree

CREATE INDEX prox_adj_copy_location_idx ON actor.org_unit_proximity_adjustment USING btree (copy_location)

prox_adj_owning_lib_idx

btree

CREATE INDEX prox_adj_owning_lib_idx ON actor.org_unit_proximity_adjustment USING btree (item_owning_lib)

prox_adj_pickup_lib_idx

btree

CREATE INDEX prox_adj_pickup_lib_idx ON actor.org_unit_proximity_adjustment USING btree (hold_pickup_lib)

prox_adj_request_lib_idx

btree

CREATE INDEX prox_adj_request_lib_idx ON actor.org_unit_proximity_adjustment USING btree (hold_request_lib)
Previous
Next