container.copy_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: copy_bucket_btype_fkey, copy_bucket_owner_fkey, copy_bucket_owning_lib_fkey.

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.copy_bucket_id_seq'::regclass)

owner FK

integer

No

→ actor.usr(id)

name

text

No

btype FK

text

No

'misc'::text

→ container.copy_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.copy_bucket_type(code)

NO ACTION

NO ACTION

DEFERRED

copy_bucket_btype_fkey

owner

actor.usr(id)

CASCADE

CASCADE

DEFERRED

copy_bucket_owner_fkey

owning_lib

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

copy_bucket_owning_lib_fkey

Unique Constraints

  • cb_name_once_per_owner: (owner, name, btype)

Indexes

Index Method Definition

copy_bucket_pkey PK

btree

CREATE UNIQUE INDEX copy_bucket_pkey ON container.copy_bucket USING btree (id)

cb_name_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX cb_name_once_per_owner ON container.copy_bucket USING btree (owner, name, btype)

Referenced By

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

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

container.copy_bucket_item

bucket

id

copy_bucket_item_bucket_fkey

container.copy_bucket_note

bucket

id

copy_bucket_note_bucket_fkey
Previous
Next