config.circ_limit_set_copy_loc_map

↑ config schema

Cascading Deletes: Deleting rows from this table will cascade to: asset.copy_location, config.circ_limit_set.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.circ_limit_set_copy_loc_map_id_seq'::regclass)

limit_set FK

integer

No

→ config.circ_limit_set(id)

copy_loc FK

integer

No

→ asset.copy_location(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

copy_loc

asset.copy_location(id)

CASCADE

CASCADE

DEFERRED

circ_limit_set_copy_loc_map_copy_loc_fkey

limit_set

config.circ_limit_set(id)

CASCADE

NO ACTION

DEFERRED

circ_limit_set_copy_loc_map_limit_set_fkey

Unique Constraints

  • cl_once_per_set: (limit_set, copy_loc)

Indexes

Index Method Definition

circ_limit_set_copy_loc_map_pkey PK

btree

CREATE UNIQUE INDEX circ_limit_set_copy_loc_map_pkey ON config.circ_limit_set_copy_loc_map USING btree (id)

cl_once_per_set UNIQUE

btree

CREATE UNIQUE INDEX cl_once_per_set ON config.circ_limit_set_copy_loc_map USING btree (limit_set, copy_loc)
Previous
Next