config.circ_limit_set

↑ config schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.circ_limit_set_id_seq'::regclass)
name	`text`	No
owning_lib FK	`integer`	No		→ actor.org_unit(id)
items_out	`integer`	No
depth	`integer`	No	0
global	`boolean`	No	false
description	`text`	Yes

id PK

integer

nextval('config.circ_limit_set_id_seq'::regclass)

name

text

owning_lib FK

integer

→ actor.org_unit(id)

items_out

integer

depth

integer

global

boolean

false

description

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owning_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`circ_limit_set_owning_lib_fkey`

owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

circ_limit_set_owning_lib_fkey

Unique Constraints

circ_limit_set_name_key: (name)

Indexes

Index Method Definition

Index	Method	Definition
`circ_limit_set_pkey` PK	btree	`CREATE UNIQUE INDEX circ_limit_set_pkey ON config.circ_limit_set USING btree (id)`
`circ_limit_set_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX circ_limit_set_name_key ON config.circ_limit_set USING btree (name)`

circ_limit_set_pkey PK

btree

CREATE UNIQUE INDEX circ_limit_set_pkey ON config.circ_limit_set USING btree (id)

circ_limit_set_name_key UNIQUE

btree

CREATE UNIQUE INDEX circ_limit_set_name_key ON config.circ_limit_set USING btree (name)

Referenced By

The following tables have foreign keys pointing to config.circ_limit_set (4 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
config.circ_limit_set_circ_mod_map	`limit_set`	`id`	`circ_limit_set_circ_mod_map_limit_set_fkey`
config.circ_limit_set_copy_loc_map	`limit_set`	`id`	`circ_limit_set_copy_loc_map_limit_set_fkey`
config.circ_limit_set_group_map	`limit_set`	`id`	`circ_limit_set_group_map_limit_set_fkey`
config.circ_matrix_limit_set_map	`limit_set`	`id`	`circ_matrix_limit_set_map_limit_set_fkey`