config.weight_assoc

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.weight_assoc_id_seq'::regclass)

active

boolean

No

org_unit FK

integer

No

→ actor.org_unit(id)

circ_weights FK

integer

Yes

→ config.circ_matrix_weights(id)

hold_weights FK

integer

Yes

→ config.hold_matrix_weights(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

circ_weights

config.circ_matrix_weights(id)

SET NULL

NO ACTION

DEFERRED

weight_assoc_circ_weights_fkey

hold_weights

config.hold_matrix_weights(id)

SET NULL

NO ACTION

DEFERRED

weight_assoc_hold_weights_fkey

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

weight_assoc_org_unit_fkey

Indexes

Index Method Definition

weight_assoc_pkey PK

btree

CREATE UNIQUE INDEX weight_assoc_pkey ON config.weight_assoc USING btree (id)

cwa_one_active_per_ou UNIQUE

btree

CREATE UNIQUE INDEX cwa_one_active_per_ou ON config.weight_assoc USING btree (org_unit) WHERE active
Previous
Next