container.biblio_record_entry_bucket_usr_flags

↑ container schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('container.biblio_record_entry_bucket_usr_flags_id_seq'::regclass)

bucket FK

integer

No

→ container.biblio_record_entry_bucket(id)

usr FK

integer

No

→ actor.usr(id)

flag

container.usr_flag_type

No

'favorite'::container.usr_flag_type

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_usr_flags_bucket_fkey

usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

biblio_record_entry_bucket_usr_flags_usr_fkey

Unique Constraints

  • brebs_flag_once_per_usr_per_bucket: (bucket, usr, flag)

Indexes

Index Method Definition

biblio_record_entry_bucket_usr_flags_pkey PK

btree

CREATE UNIQUE INDEX biblio_record_entry_bucket_usr_flags_pkey ON container.biblio_record_entry_bucket_usr_flags USING btree (id)

brebs_flag_once_per_usr_per_bucket UNIQUE

btree

CREATE UNIQUE INDEX brebs_flag_once_per_usr_per_bucket ON container.biblio_record_entry_bucket_usr_flags USING btree (bucket, usr, flag)
Previous
Next