actor.workstation

↑ actor schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.workstation_id_seq'::regclass)
name	`text`	No
owning_lib FK	`integer`	No		→ actor.org_unit(id)

id PK

integer

nextval('actor.workstation_id_seq'::regclass)

name

text

owning_lib FK

integer

→ actor.org_unit(id)

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	`workstation_owning_lib_fkey`

owning_lib

actor.org_unit(id)

NO ACTION

DEFERRED

workstation_owning_lib_fkey

Unique Constraints

workstation_name_key: (name)

Indexes

Index Method Definition

Index	Method	Definition
`workstation_pkey` PK	btree	`CREATE UNIQUE INDEX workstation_pkey ON actor.workstation USING btree (id)`
`workstation_name_key` UNIQUE	btree	`CREATE UNIQUE INDEX workstation_name_key ON actor.workstation USING btree (name)`

workstation_pkey PK

btree

CREATE UNIQUE INDEX workstation_pkey ON actor.workstation USING btree (id)

workstation_name_key UNIQUE

btree

CREATE UNIQUE INDEX workstation_name_key ON actor.workstation USING btree (name)

Referenced By

The following tables have foreign keys pointing to actor.workstation (14 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
action.circulation	`checkin_workstation`	`id`	`circulation_checkin_workstation_fkey`
action.circulation	`workstation`	`id`	`circulation_workstation_fkey`
action.hold_request	`canceling_ws`	`id`	`hold_request_canceling_ws_fkey`
action.hold_request_reset_reason_entry	`requestor_workstation`	`id`	`hold_request_reset_reason_entry_requestor_workstation_fkey`
action.in_house_use	`workstation`	`id`	`in_house_use_workstation_fkey`
action.non_cat_in_house_use	`workstation`	`id`	`non_cat_in_house_use_workstation_fkey`
actor.toolbar	`ws`	`id`	`toolbar_ws_fkey`
actor.usr_org_unit_opt_in	`opt_in_ws`	`id`	`usr_org_unit_opt_in_opt_in_ws_fkey`
actor.workstation_setting	`workstation`	`id`	`workstation_setting_workstation_fkey`
asset.copy_inventory	`inventory_workstation`	`id`	`copy_inventory_inventory_workstation_fkey`
money.bnm_desk_payment	`cash_drawer`	`id`	`bnm_desk_payment_cash_drawer_fkey`
sip.account	`workstation`	`id`	`account_workstation_fkey`
vandelay.background_import	`workstation`	`id`	`background_import_workstation_fkey`
vandelay.session_tracker	`workstation`	`id`	`session_tracker_workstation_fkey`