container.biblio_record_entry_bucket

Cascading Deletes: Deleting rows from this table will cascade to: actor.usr, actor.org_unit.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('container.biblio_record_entry_bucket_id_seq'::regclass)
owner FK	`integer`	No		→ actor.usr(id)
name	`text`	No
btype FK	`text`	No	'misc'::text	→ container.biblio_record_entry_bucket_type(code)
description	`text`	Yes
pub	`boolean`	No	false
owning_lib FK	`integer`	Yes		→ actor.org_unit(id)
create_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('container.biblio_record_entry_bucket_id_seq'::regclass)

owner FK

integer

→ actor.usr(id)

name

text

btype FK

text

'misc'::text

→ container.biblio_record_entry_bucket_type(code)

description

text

Yes

pub

boolean

false

owning_lib FK

integer

Yes

→ actor.org_unit(id)

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
`btype`	container.biblio_record_entry_bucket_type(code)	NO ACTION	NO ACTION	DEFERRED	`biblio_record_entry_bucket_btype_fkey`
`owner`	actor.usr(id)	CASCADE	CASCADE	DEFERRED	`biblio_record_entry_bucket_owner_fkey`
`owning_lib`	actor.org_unit(id)	CASCADE	NO ACTION	DEFERRED	`biblio_record_entry_bucket_owning_lib_fkey`

btype

container.biblio_record_entry_bucket_type(code)

NO ACTION

DEFERRED

biblio_record_entry_bucket_btype_fkey

owner

actor.usr(id)

CASCADE

DEFERRED

biblio_record_entry_bucket_owner_fkey

owning_lib

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

biblio_record_entry_bucket_owning_lib_fkey

Unique Constraints

breb_name_once_per_owner: (owner, name, btype)

Indexes

Index Method Definition

Index	Method	Definition
`biblio_record_entry_bucket_pkey` PK	btree	`CREATE UNIQUE INDEX biblio_record_entry_bucket_pkey ON container.biblio_record_entry_bucket USING btree (id)`
`breb_name_once_per_owner` UNIQUE	btree	`CREATE UNIQUE INDEX breb_name_once_per_owner ON container.biblio_record_entry_bucket USING btree (owner, name, btype)`

biblio_record_entry_bucket_pkey PK

btree

CREATE UNIQUE INDEX biblio_record_entry_bucket_pkey ON container.biblio_record_entry_bucket USING btree (id)

breb_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX breb_name_once_per_owner ON container.biblio_record_entry_bucket USING btree (owner, name, btype)

Referenced By

The following tables have foreign keys pointing to container.biblio_record_entry_bucket (7 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	`bucket`	`id`	`biblio_record_entry_bucket_item_bucket_fkey`
container.biblio_record_entry_bucket_note	`bucket`	`id`	`biblio_record_entry_bucket_note_bucket_fkey`
container.biblio_record_entry_bucket_shares	`bucket`	`id`	`biblio_record_entry_bucket_shares_bucket_fkey`
container.biblio_record_entry_bucket_usr_flags	`bucket`	`id`	`biblio_record_entry_bucket_usr_flags_bucket_fkey`
container.carousel	`bucket`	`id`	`carousel_bucket_fkey`
url_verify.session	`container`	`id`	`session_container_fkey`
vandelay.bib_queue	`match_bucket`	`id`	`match_bucket_fkey`