config.composite_attr_entry_definition

Cascading Deletes: Deleting rows from this table will cascade to: config.coded_value_map.

Columns

Column Type Nullable Default Notes

coded_value PK FK

integer

No

config.coded_value_map(id)

definition

text

No

Primary Key

(coded_value)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

coded_value

config.coded_value_map(id)

CASCADE

CASCADE

No

composite_attr_entry_definition_coded_value_fkey

Indexes

Index Method Definition

composite_attr_entry_definition_pkey PK

btree

CREATE UNIQUE INDEX composite_attr_entry_definition_pkey ON config.composite_attr_entry_definition USING btree (coded_value)

Triggers

Trigger Timing Event Level Function

ccraed_cache_inval_tgr

AFTER

INSERT OR DELETE OR UPDATE

STATEMENT

metabib.composite_attr_def_cache_inval_tgr()

Trigger Bodies

ccraed_cache_inval_tgr

Function: metabib.composite_attr_def_cache_inval_tgr()
Timing: AFTER INSERT OR DELETE OR UPDATE STATEMENT

BEGIN
    PERFORM metabib.compile_composite_attr_cache_invalidate();
    RETURN NULL;
END;