vandelay.queued_bib_record_attr

↑ vandelay schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`bigint`	No	nextval('vandelay.queued_bib_record_attr_id_seq'::regclass)
record FK	`bigint`	No		→ vandelay.queued_bib_record(id)
field FK	`integer`	No		→ vandelay.bib_attr_definition(id)
attr_value	`text`	No

id PK

bigint

nextval('vandelay.queued_bib_record_attr_id_seq'::regclass)

record FK

bigint

→ vandelay.queued_bib_record(id)

field FK

integer

→ vandelay.bib_attr_definition(id)

attr_value

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`field`	vandelay.bib_attr_definition(id)	NO ACTION	NO ACTION	DEFERRED	`queued_bib_record_attr_field_fkey`
`record`	vandelay.queued_bib_record(id)	NO ACTION	NO ACTION	DEFERRED	`queued_bib_record_attr_record_fkey`

field

vandelay.bib_attr_definition(id)

NO ACTION

DEFERRED

queued_bib_record_attr_field_fkey

record

vandelay.queued_bib_record(id)

NO ACTION

DEFERRED

queued_bib_record_attr_record_fkey

Indexes

Index Method Definition

Index	Method	Definition
`queued_bib_record_attr_pkey` PK	btree	`CREATE UNIQUE INDEX queued_bib_record_attr_pkey ON vandelay.queued_bib_record_attr USING btree (id)`
`queued_bib_record_attr_record_idx`	btree	`CREATE INDEX queued_bib_record_attr_record_idx ON vandelay.queued_bib_record_attr USING btree (record)`

queued_bib_record_attr_pkey PK

btree

CREATE UNIQUE INDEX queued_bib_record_attr_pkey ON vandelay.queued_bib_record_attr USING btree (id)

queued_bib_record_attr_record_idx

btree

CREATE INDEX queued_bib_record_attr_record_idx ON vandelay.queued_bib_record_attr USING btree (record)