actor.workstation_setting

↑ actor schema

Cascading Deletes: Deleting rows from this table will cascade to: config.workstation_setting_type, actor.workstation.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('actor.workstation_setting_id_seq'::regclass)

workstation FK

integer

No

→ actor.workstation(id)

name FK

text

No

→ config.workstation_setting_type(name)

value

json

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

name

config.workstation_setting_type(name)

CASCADE

CASCADE

DEFERRED

workstation_setting_name_fkey

workstation

actor.workstation(id)

CASCADE

NO ACTION

DEFERRED

workstation_setting_workstation_fkey

Unique Constraints

  • ws_once_per_key: (workstation, name)

Indexes

Index Method Definition

workstation_setting_pkey PK

btree

CREATE UNIQUE INDEX workstation_setting_pkey ON actor.workstation_setting USING btree (id)

ws_once_per_key UNIQUE

btree

CREATE UNIQUE INDEX ws_once_per_key ON actor.workstation_setting USING btree (workstation, name)

actor_workstation_setting_workstation_idx

btree

CREATE INDEX actor_workstation_setting_workstation_idx ON actor.workstation_setting USING btree (workstation)
Previous
Next