authority.thesaurus

↑ authority schema

Cascading Deletes: Deleting rows from this table will cascade to: authority.control_set.

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

Columns

Column Type Nullable Default Notes

code PK

text

No

control_set FK

integer

Yes

→ authority.control_set(id)

name

text

No

description

text

Yes

short_code

text

Yes

uri

text

Yes

Primary Key

(code)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

control_set

authority.control_set(id)

CASCADE

CASCADE

DEFERRED

thesaurus_control_set_fkey

Unique Constraints

  • thesaurus_name_key: (name)

Indexes

Index Method Definition

thesaurus_pkey PK

btree

CREATE UNIQUE INDEX thesaurus_pkey ON authority.thesaurus USING btree (code)

thesaurus_name_key UNIQUE

btree

CREATE UNIQUE INDEX thesaurus_name_key ON authority.thesaurus USING btree (name)

Triggers

Trigger Timing Event Level Function

thes_code_tracking_trigger

AFTER

UPDATE

ROW

evergreen.oils_i18n_code_tracking()

Trigger Bodies

thes_code_tracking_trigger

Function: evergreen.oils_i18n_code_tracking()
Timing: AFTER UPDATE ROW

BEGIN
    PERFORM oils_i18n_update_apply( OLD.code::TEXT, NEW.code::TEXT, TG_ARGV[0]::TEXT );
    RETURN NEW;
END;
Previous
Next