vandelay.queue

↑ vandelay schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('vandelay.queue_id_seq'::regclass)
owner FK	`integer`	No		→ actor.usr(id)
name	`text`	No
complete	`boolean`	No	false
match_set FK	`integer`	Yes		→ vandelay.match_set(id)

id PK

bigint

nextval('vandelay.queue_id_seq'::regclass)

owner FK

integer

→ actor.usr(id)

name

text

complete

boolean

false

match_set FK

integer

Yes

→ vandelay.match_set(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`match_set`	vandelay.match_set(id)	SET NULL	CASCADE	DEFERRED	`queue_match_set_fkey`
`owner`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`queue_owner_fkey`

match_set

vandelay.match_set(id)

SET NULL

CASCADE

DEFERRED

queue_match_set_fkey

owner

actor.usr(id)

NO ACTION

DEFERRED

queue_owner_fkey

Indexes

Index Method Definition

Index	Method	Definition
`queue_pkey` PK	btree	`CREATE UNIQUE INDEX queue_pkey ON vandelay.queue USING btree (id)`

queue_pkey PK

btree

CREATE UNIQUE INDEX queue_pkey ON vandelay.queue USING btree (id)