container.call_number_bucket_item

Cascading Deletes: Deleting rows from this table will cascade to: container.call_number_bucket, asset.call_number.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('container.call_number_bucket_item_id_seq'::regclass)
bucket FK	`integer`	No		→ container.call_number_bucket(id)
target_call_number FK	`integer`	No		→ asset.call_number(id)
pos	`integer`	Yes
create_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('container.call_number_bucket_item_id_seq'::regclass)

bucket FK

integer

→ container.call_number_bucket(id)

target_call_number FK

integer

→ asset.call_number(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.call_number_bucket(id)	CASCADE	CASCADE	DEFERRED	`call_number_bucket_item_bucket_fkey`
`target_call_number`	asset.call_number(id)	CASCADE	CASCADE	DEFERRED	`call_number_bucket_item_target_call_number_fkey`

bucket

container.call_number_bucket(id)

CASCADE

DEFERRED

call_number_bucket_item_bucket_fkey

target_call_number

asset.call_number(id)

CASCADE

DEFERRED

call_number_bucket_item_target_call_number_fkey

Indexes

Index Method Definition

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

call_number_bucket_item_pkey PK

btree

CREATE UNIQUE INDEX call_number_bucket_item_pkey ON container.call_number_bucket_item USING btree (id)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
container.call_number_bucket_item_note	`item`	`id`	`call_number_bucket_item_note_item_fkey`

container.call_number_bucket_item_note

item

id

call_number_bucket_item_note_item_fkey