action.non_cat_in_house_use

↑ action schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: non_cat_in_house_use_item_type_fkey, non_cat_in_house_use_org_unit_fkey, non_cat_in_house_use_staff_fkey, non_cat_in_house_use_workstation_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('action.non_cat_in_house_use_id_seq'::regclass)
item_type FK	`bigint`	No		→ config.non_cataloged_type(id)
staff FK	`integer`	No		→ actor.usr(id)
workstation FK	`integer`	Yes		→ actor.workstation(id)
org_unit FK	`integer`	No		→ actor.org_unit(id)
use_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('action.non_cat_in_house_use_id_seq'::regclass)

item_type FK

bigint

→ config.non_cataloged_type(id)

staff FK

integer

→ actor.usr(id)

workstation FK

integer

Yes

→ actor.workstation(id)

org_unit FK

integer

→ actor.org_unit(id)

use_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
`item_type`	config.non_cataloged_type(id)	NO ACTION	NO ACTION	DEFERRED	`non_cat_in_house_use_item_type_fkey`
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`non_cat_in_house_use_org_unit_fkey`
`staff`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`non_cat_in_house_use_staff_fkey`
`workstation`	actor.workstation(id)	NO ACTION	NO ACTION	DEFERRED	`non_cat_in_house_use_workstation_fkey`

item_type

config.non_cataloged_type(id)

NO ACTION

DEFERRED

non_cat_in_house_use_item_type_fkey

org_unit

actor.org_unit(id)

NO ACTION

DEFERRED

non_cat_in_house_use_org_unit_fkey

staff

actor.usr(id)

NO ACTION

DEFERRED

non_cat_in_house_use_staff_fkey

workstation

actor.workstation(id)

NO ACTION

DEFERRED

non_cat_in_house_use_workstation_fkey

Indexes

Index Method Definition

Index	Method	Definition
`non_cat_in_house_use_pkey` PK	btree	`CREATE UNIQUE INDEX non_cat_in_house_use_pkey ON action.non_cat_in_house_use USING btree (id)`
`non_cat_in_house_use_staff_idx`	btree	`CREATE INDEX non_cat_in_house_use_staff_idx ON action.non_cat_in_house_use USING btree (staff)`
`non_cat_in_house_use_ws_idx`	btree	`CREATE INDEX non_cat_in_house_use_ws_idx ON action.non_cat_in_house_use USING btree (workstation)`

non_cat_in_house_use_pkey PK

btree

CREATE UNIQUE INDEX non_cat_in_house_use_pkey ON action.non_cat_in_house_use USING btree (id)

non_cat_in_house_use_staff_idx

btree

CREATE INDEX non_cat_in_house_use_staff_idx ON action.non_cat_in_house_use USING btree (staff)

non_cat_in_house_use_ws_idx

btree

CREATE INDEX non_cat_in_house_use_ws_idx ON action.non_cat_in_house_use USING btree (workstation)