action.non_cataloged_circulation

↑ action schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: non_cataloged_circulation_circ_lib_fkey, non_cataloged_circulation_item_type_fkey, non_cataloged_circulation_patron_fkey, non_cataloged_circulation_staff_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.non_cataloged_circulation_id_seq'::regclass)
patron FK	`integer`	No		→ actor.usr(id)
staff FK	`integer`	No		→ actor.usr(id)
circ_lib FK	`integer`	No		→ actor.org_unit(id)
item_type FK	`integer`	No		→ config.non_cataloged_type(id)
circ_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('action.non_cataloged_circulation_id_seq'::regclass)

patron FK

integer

→ actor.usr(id)

staff FK

integer

→ actor.usr(id)

circ_lib FK

integer

→ actor.org_unit(id)

item_type FK

integer

→ config.non_cataloged_type(id)

circ_time

timestamp with time zone

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`circ_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`non_cataloged_circulation_circ_lib_fkey`
`item_type`	config.non_cataloged_type(id)	NO ACTION	NO ACTION	DEFERRED	`non_cataloged_circulation_item_type_fkey`
`patron`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`non_cataloged_circulation_patron_fkey`
`staff`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`non_cataloged_circulation_staff_fkey`

circ_lib

actor.org_unit(id)

NO ACTION

DEFERRED

non_cataloged_circulation_circ_lib_fkey

item_type

config.non_cataloged_type(id)

NO ACTION

DEFERRED

non_cataloged_circulation_item_type_fkey

patron

actor.usr(id)

NO ACTION

DEFERRED

non_cataloged_circulation_patron_fkey

staff

actor.usr(id)

NO ACTION

DEFERRED

non_cataloged_circulation_staff_fkey

Indexes

Index Method Definition

Index	Method	Definition
`non_cataloged_circulation_pkey` PK	btree	`CREATE UNIQUE INDEX non_cataloged_circulation_pkey ON action.non_cataloged_circulation USING btree (id)`
`action_non_cat_circ_patron_idx`	btree	`CREATE INDEX action_non_cat_circ_patron_idx ON action.non_cataloged_circulation USING btree (patron)`
`action_non_cat_circ_staff_idx`	btree	`CREATE INDEX action_non_cat_circ_staff_idx ON action.non_cataloged_circulation USING btree (staff)`

non_cataloged_circulation_pkey PK

btree

CREATE UNIQUE INDEX non_cataloged_circulation_pkey ON action.non_cataloged_circulation USING btree (id)

action_non_cat_circ_patron_idx

btree

CREATE INDEX action_non_cat_circ_patron_idx ON action.non_cataloged_circulation USING btree (patron)

action_non_cat_circ_staff_idx

btree

CREATE INDEX action_non_cat_circ_staff_idx ON action.non_cataloged_circulation USING btree (staff)