container.biblio_record_entry_bucket_shares

↑ container schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.biblio_record_entry_bucket_shares_id_seq'::regclass)

bucket FK

integer

No

→ container.biblio_record_entry_bucket(id)

share_org FK

integer

No

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

bucket

container.biblio_record_entry_bucket(id)

CASCADE

CASCADE

DEFERRED

biblio_record_entry_bucket_shares_bucket_fkey

share_org

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

biblio_record_entry_bucket_shares_share_org_fkey

Unique Constraints

  • brebs_org_once_per_bucket: (bucket, share_org)

Indexes

Index Method Definition

biblio_record_entry_bucket_shares_pkey PK

btree

CREATE UNIQUE INDEX biblio_record_entry_bucket_shares_pkey ON container.biblio_record_entry_bucket_shares USING btree (id)

brebs_org_once_per_bucket UNIQUE

btree

CREATE UNIQUE INDEX brebs_org_once_per_bucket ON container.biblio_record_entry_bucket_shares USING btree (bucket, share_org)
Previous
Next