vandelay.bib_queue

↑ vandelay schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('vandelay.queue_id_seq'::regclass)
owner	`integer`	No
name	`text`	No
complete	`boolean`	No	false
match_set	`integer`	Yes
queue_type	`vandelay.bib_queue_queue_type`	No	'bib'::vandelay.bib_queue_queue_type
item_attr_def FK	`bigint`	Yes		→ vandelay.import_item_attr_definition(id)
match_bucket FK	`integer`	Yes		→ container.biblio_record_entry_bucket(id)

id PK

bigint

nextval('vandelay.queue_id_seq'::regclass)

owner

integer

name

text

complete

boolean

false

match_set

integer

Yes

queue_type

vandelay.bib_queue_queue_type

'bib'::vandelay.bib_queue_queue_type

item_attr_def FK

bigint

Yes

→ vandelay.import_item_attr_definition(id)

match_bucket FK

integer

Yes

→ container.biblio_record_entry_bucket(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`item_attr_def`	vandelay.import_item_attr_definition(id)	SET NULL	NO ACTION	DEFERRED	`bib_queue_item_attr_def_fkey`
`match_bucket`	container.biblio_record_entry_bucket(id)	SET NULL	NO ACTION	DEFERRED	`match_bucket_fkey`

item_attr_def

vandelay.import_item_attr_definition(id)

SET NULL

NO ACTION

DEFERRED

bib_queue_item_attr_def_fkey

match_bucket

container.biblio_record_entry_bucket(id)

SET NULL

NO ACTION

DEFERRED

match_bucket_fkey

Unique Constraints

vand_bib_queue_name_once_per_owner_const: (owner, name, queue_type)

Indexes

Index Method Definition

Index	Method	Definition
`bib_queue_pkey` PK	btree	`CREATE UNIQUE INDEX bib_queue_pkey ON vandelay.bib_queue USING btree (id)`
`vand_bib_queue_name_once_per_owner_const` UNIQUE	btree	`CREATE UNIQUE INDEX vand_bib_queue_name_once_per_owner_const ON vandelay.bib_queue USING btree (owner, name, queue_type)`

bib_queue_pkey PK

btree

CREATE UNIQUE INDEX bib_queue_pkey ON vandelay.bib_queue USING btree (id)

vand_bib_queue_name_once_per_owner_const UNIQUE

btree

CREATE UNIQUE INDEX vand_bib_queue_name_once_per_owner_const ON vandelay.bib_queue USING btree (owner, name, queue_type)

Referenced By

The following tables have foreign keys pointing to vandelay.bib_queue (1 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
vandelay.queued_bib_record	`queue`	`id`	`queued_bib_record_queue_fkey`

vandelay.queued_bib_record

queue

id

queued_bib_record_queue_fkey