config.circ_limit_set_circ_mod_map

↑ config schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('config.circ_limit_set_circ_mod_map_id_seq'::regclass)

limit_set FK

integer

No

→ config.circ_limit_set(id)

circ_mod FK

text

No

→ config.circ_modifier(code)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

circ_mod

config.circ_modifier(code)

CASCADE

CASCADE

DEFERRED

circ_limit_set_circ_mod_map_circ_mod_fkey

limit_set

config.circ_limit_set(id)

CASCADE

NO ACTION

DEFERRED

circ_limit_set_circ_mod_map_limit_set_fkey

Unique Constraints

  • cm_once_per_set: (limit_set, circ_mod)

Indexes

Index Method Definition

circ_limit_set_circ_mod_map_pkey PK

btree

CREATE UNIQUE INDEX circ_limit_set_circ_mod_map_pkey ON config.circ_limit_set_circ_mod_map USING btree (id)

cm_once_per_set UNIQUE

btree

CREATE UNIQUE INDEX cm_once_per_set ON config.circ_limit_set_circ_mod_map USING btree (limit_set, circ_mod)
Previous
Next