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

Column	Type	Nullable	Default	Notes
coded_value PK FK	`integer`	No		→ config.coded_value_map(id)
definition	`text`	No

coded_value PK FK

integer

definition

text

(coded_value)

Column(s) References On Delete On Update Deferrable Constraint

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`

coded_value

CASCADE

composite_attr_entry_definition_coded_value_fkey

Index Method Definition

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)`

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)

Trigger Timing Event Level Function

Trigger	Timing	Event	Level	Function
`ccraed_cache_inval_tgr`	AFTER	INSERT OR DELETE OR UPDATE	STATEMENT	`metabib.composite_attr_def_cache_inval_tgr()`

ccraed_cache_inval_tgr

AFTER

INSERT OR DELETE OR UPDATE

STATEMENT

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;