asset.stat_cat_entry_copy_map

↑ asset schema

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

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

Columns

Column Type Nullable Default Notes

id PK

bigint

No

nextval('asset.stat_cat_entry_copy_map_id_seq'::regclass)

stat_cat FK

integer

No

→ asset.stat_cat(id)

stat_cat_entry FK

integer

No

→ asset.stat_cat_entry(id)

owning_copy

bigint

No

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

stat_cat

asset.stat_cat(id)

CASCADE

NO ACTION

DEFERRED

a_sc_sc_fkey

stat_cat_entry

asset.stat_cat_entry(id)

CASCADE

NO ACTION

DEFERRED

a_sc_sce_fkey

Unique Constraints

  • sce_once_per_copy: (owning_copy, stat_cat)

Indexes

Index Method Definition

stat_cat_entry_copy_map_pkey PK

btree

CREATE UNIQUE INDEX stat_cat_entry_copy_map_pkey ON asset.stat_cat_entry_copy_map USING btree (id)

sce_once_per_copy UNIQUE

btree

CREATE UNIQUE INDEX sce_once_per_copy ON asset.stat_cat_entry_copy_map USING btree (owning_copy, stat_cat)

scecm_owning_copy_idx

btree

CREATE INDEX scecm_owning_copy_idx ON asset.stat_cat_entry_copy_map USING btree (owning_copy)
Previous
Next