container.biblio_record_entry_bucket_item

↑ container schema

Cascading Deletes: Deleting rows from this table will cascade to: container.biblio_record_entry_bucket, biblio.record_entry.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('container.biblio_record_entry_bucket_item_id_seq'::regclass)
bucket FK	`integer`	No		→ container.biblio_record_entry_bucket(id)
target_biblio_record_entry FK	`bigint`	No		→ biblio.record_entry(id)
pos	`integer`	Yes
create_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('container.biblio_record_entry_bucket_item_id_seq'::regclass)

bucket FK

integer

→ container.biblio_record_entry_bucket(id)

target_biblio_record_entry FK

bigint

→ biblio.record_entry(id)

pos

integer

Yes

create_time

timestamp with time zone

now()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`bucket`	container.biblio_record_entry_bucket(id)	CASCADE	CASCADE	DEFERRED	`biblio_record_entry_bucket_item_bucket_fkey`
`target_biblio_record_entry`	biblio.record_entry(id)	CASCADE	CASCADE	DEFERRED	`biblio_record_entry_bucket_item_target_biblio_record_entry_fkey`

bucket

container.biblio_record_entry_bucket(id)

CASCADE

DEFERRED

biblio_record_entry_bucket_item_bucket_fkey

target_biblio_record_entry

biblio.record_entry(id)

CASCADE

DEFERRED

biblio_record_entry_bucket_item_target_biblio_record_entry_fkey

Indexes

Index Method Definition

Index	Method	Definition
`biblio_record_entry_bucket_item_pkey` PK	btree	`CREATE UNIQUE INDEX biblio_record_entry_bucket_item_pkey ON container.biblio_record_entry_bucket_item USING btree (id)`

biblio_record_entry_bucket_item_pkey PK

btree

CREATE UNIQUE INDEX biblio_record_entry_bucket_item_pkey ON container.biblio_record_entry_bucket_item USING btree (id)

Referenced By

The following tables have foreign keys pointing to container.biblio_record_entry_bucket_item (2 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
container.biblio_record_entry_bucket_item_note	`item`	`id`	`biblio_record_entry_bucket_item_note_item_fkey`
url_verify.url	`item`	`id`	`url_item_fkey`

container.biblio_record_entry_bucket_item_note

item

id

biblio_record_entry_bucket_item_note_item_fkey

url_verify.url

item

id

url_item_fkey