action.circulation_limit_group_map

↑ action schema

Cascading Deletes: Rows in this table will be automatically deleted when rows are deleted from: action.circulation, config.circ_limit_group.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
circ PK FK	`bigint`	No		→ action.circulation(id)
limit_group PK FK	`integer`	No		→ config.circ_limit_group(id)

circ PK FK

bigint

→ action.circulation(id)

limit_group PK FK

integer

→ config.circ_limit_group(id)

Primary Key

(circ, limit_group)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`circ`	action.circulation(id)	CASCADE	NO ACTION	DEFERRED	`circulation_limit_group_map_circ_fkey`
`limit_group`	config.circ_limit_group(id)	CASCADE	NO ACTION	DEFERRED	`circulation_limit_group_map_limit_group_fkey`

circ

action.circulation(id)

CASCADE

NO ACTION

DEFERRED

circulation_limit_group_map_circ_fkey

limit_group

config.circ_limit_group(id)

CASCADE

NO ACTION

DEFERRED

circulation_limit_group_map_limit_group_fkey

Indexes

Index Method Definition

Index	Method	Definition
`circulation_limit_group_map_pkey` PK	btree	`CREATE UNIQUE INDEX circulation_limit_group_map_pkey ON action.circulation_limit_group_map USING btree (circ, limit_group)`

circulation_limit_group_map_pkey PK

btree

CREATE UNIQUE INDEX circulation_limit_group_map_pkey ON action.circulation_limit_group_map USING btree (circ, limit_group)