asset.stat_cat_entry

↑ asset schema

Cascading Deletes: Deleting rows from this table will cascade to: actor.org_unit, asset.stat_cat.

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.stat_cat_entry_id_seq'::regclass)

stat_cat FK

integer

No

→ asset.stat_cat(id)

owner FK

integer

No

→ actor.org_unit(id)

value

text

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

a_sce_owner_fkey

stat_cat

asset.stat_cat(id)

CASCADE

NO ACTION

DEFERRED

a_sce_sc_fkey

Unique Constraints

  • sce_once_per_owner: (stat_cat, owner, value)

Indexes

Index Method Definition

stat_cat_entry_pkey PK

btree

CREATE UNIQUE INDEX stat_cat_entry_pkey ON asset.stat_cat_entry USING btree (id)

sce_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX sce_once_per_owner ON asset.stat_cat_entry USING btree (stat_cat, owner, value)

Referenced By

The following tables have foreign keys pointing to asset.stat_cat_entry (1 referencing table(s)):

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

asset.stat_cat_entry_copy_map

stat_cat_entry

id

a_sc_sce_fkey
Previous
Next