rating.record_badge_score

↑ rating schema

Cascading Deletes: Deleting rows from this table will cascade to: rating.badge, biblio.record_entry.

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('rating.record_badge_score_id_seq'::regclass)

record FK

bigint

No

→ biblio.record_entry(id)

badge FK

integer

No

→ rating.badge(id)

score

integer

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

badge

rating.badge(id)

CASCADE

CASCADE

DEFERRED

record_badge_score_badge_fkey

record

biblio.record_entry(id)

CASCADE

CASCADE

DEFERRED

record_badge_score_record_fkey

Unique Constraints

  • unique_record_badge: (record, badge)

Check Constraints

  • record_badge_score_score_check: CHECK

Indexes

Index Method Definition

record_badge_score_pkey PK

btree

CREATE UNIQUE INDEX record_badge_score_pkey ON rating.record_badge_score USING btree (id)

unique_record_badge UNIQUE

btree

CREATE UNIQUE INDEX unique_record_badge ON rating.record_badge_score USING btree (record, badge)

record_badge_score_badge_idx

btree

CREATE INDEX record_badge_score_badge_idx ON rating.record_badge_score USING btree (badge)

record_badge_score_record_idx

btree

CREATE INDEX record_badge_score_record_idx ON rating.record_badge_score USING btree (record)
Previous
Next