actor.stat_cat_entry_usr_map

↑ actor schema

Statistical Catagory Entry to User map

Records the stat_cat entries for each user.

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

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('actor.stat_cat_entry_usr_map_id_seq'::regclass)

stat_cat_entry

text

No

stat_cat FK

integer

No

→ actor.stat_cat(id)

target_usr FK

integer

No

→ actor.usr(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

stat_cat

actor.stat_cat(id)

NO ACTION

NO ACTION

DEFERRED

actor_sceum_sc_fkey

target_usr

actor.usr(id)

CASCADE

NO ACTION

DEFERRED

actor_sceum_tu_fkey

Unique Constraints

  • sc_once_per_usr: (target_usr, stat_cat)

Indexes

Index Method Definition

stat_cat_entry_usr_map_pkey PK

btree

CREATE UNIQUE INDEX stat_cat_entry_usr_map_pkey ON actor.stat_cat_entry_usr_map USING btree (id)

sc_once_per_usr UNIQUE

btree

CREATE UNIQUE INDEX sc_once_per_usr ON actor.stat_cat_entry_usr_map USING btree (target_usr, stat_cat)

actor_stat_cat_entry_usr_idx

btree

CREATE INDEX actor_stat_cat_entry_usr_idx ON actor.stat_cat_entry_usr_map USING btree (target_usr)
Previous
Next