container.user_bucket

↑ container schema

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: user_bucket_btype_fkey, user_bucket_owner_fkey, user_bucket_owning_lib_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.user_bucket_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

name

text

No

btype FK

text

No

'misc'::text

→ container.user_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()

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

btype

container.user_bucket_type(code)

NO ACTION

NO ACTION

DEFERRED

user_bucket_btype_fkey

owner

actor.usr(id)

CASCADE

CASCADE

DEFERRED

user_bucket_owner_fkey

owning_lib

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

user_bucket_owning_lib_fkey

Unique Constraints

  • ub_name_once_per_owner: (owner, name, btype)

Indexes

Index Method Definition

user_bucket_pkey PK

btree

CREATE UNIQUE INDEX user_bucket_pkey ON container.user_bucket USING btree (id)

ub_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX ub_name_once_per_owner ON container.user_bucket USING btree (owner, name, btype)

Referenced By

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

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

action.batch_hold_event

bucket

id

batch_hold_event_bucket_fkey

container.user_bucket_item

bucket

id

user_bucket_item_bucket_fkey

container.user_bucket_note

bucket

id

user_bucket_note_bucket_fkey
Previous
Next