container.call_number_bucket_item_note

Cascading Deletes: Deleting rows from this table will cascade to: container.call_number_bucket_item.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('container.call_number_bucket_item_note_id_seq'::regclass)
item FK	`integer`	No		→ container.call_number_bucket_item(id)
note	`text`	No

id PK

integer

nextval('container.call_number_bucket_item_note_id_seq'::regclass)

item FK

integer

→ container.call_number_bucket_item(id)

note

text

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`item`	container.call_number_bucket_item(id)	CASCADE	CASCADE	DEFERRED	`call_number_bucket_item_note_item_fkey`

item

container.call_number_bucket_item(id)

CASCADE

DEFERRED

call_number_bucket_item_note_item_fkey

Indexes

Index Method Definition

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

call_number_bucket_item_note_pkey PK

btree

CREATE UNIQUE INDEX call_number_bucket_item_note_pkey ON container.call_number_bucket_item_note USING btree (id)