ref.auto_hint.txt

Ausgabeformat ist »wrapped«.
                                                                                                           Tabelle »ref.auto_hint«
        Spalte        |           Typ            | Sortierfolge | NULL erlaubt? |                     Vorgabewert                      | Speicherung | Statistikziel |                              Beschreibung                              
----------------------+--------------------------+--------------+---------------+------------------------------------------------------+-------------+---------------+------------------------------------------------------------------------
 pk_audit             | integer                  |              | not null      | nextval('audit.audit_fields_pk_audit_seq'::regclass) | plain       |               | 
 row_version          | integer                  |              | not null      | 0                                                    | plain       |               | 
 modified_when        | timestamp with time zone |              | not null      | CURRENT_TIMESTAMP                                    | plain       |               | 
 modified_by          | name                     |              | not null      | CURRENT_USER                                         | plain       |               | 
 pk                   | integer                  |              | not null      | nextval('ref.auto_hint_pk_seq'::regclass)            | plain       |               | 
 query                | text                     |              |               |                                                      | extended    |               | This query is run against the database.
 title                | text                     |              |               |                                                      | extended    |               | A short title to summarize and identify the hint.
 hint                 | text                     |              |               |                                                      | extended    |               | When the query returns true this is the hint that should be displayed.
 url                  | text                     |              |               |                                                      | extended    |               | An URL relevant to the hint.
 is_active            | boolean                  |              | not null      | true                                                 | plain       |               | Whether or not this query/hint is active.
 source               | text                     |              |               |                                                      | extended    |               | Who provided query and hint.
 lang                 | text                     |              |               |                                                      | extended    |               | The language the hint is written in.
 recommendation_query | text                     |              |               |                                                      | extended    |               | 
Indexe:
    "auto_hint_pkey" PRIMARY KEY, btree (pk)
    "ref_auto_hint_uniq_query" UNIQUE CONSTRAINT, btree (query)
    "ref_auto_hint_uniq_title" UNIQUE CONSTRAINT, btree (title)
Check-Constraints:
    "audit_audit_fields_sane_modified_when" CHECK ((modified_when <= clock_timestamp()) IS TRUE)
    "ref_auto_hint_sane_hint" CHECK (gm.is_null_or_blank_string(hint) IS FALSE)
    "ref_auto_hint_sane_lang" CHECK (gm.is_null_or_blank_string(lang) IS FALSE)
    "ref_auto_hint_sane_query" CHECK (gm.is_null_or_blank_string(query) IS FALSE)
    "ref_auto_hint_sane_rec_query" CHECK (gm.is_null_or_non_empty_string(recommendation_query))
    "ref_auto_hint_sane_source" CHECK (gm.is_null_or_blank_string(source) IS FALSE)
    "ref_auto_hint_sane_title" CHECK (gm.is_null_or_blank_string(title) IS FALSE)
    "ref_auto_hint_sane_url" CHECK (gm.is_null_or_non_empty_string(url))
Fremdschlüsselverweise von:
    TABLE "clin.suppressed_hint" CONSTRAINT "fk_clin_suppressed_hint_fk_hint" FOREIGN KEY (fk_hint) REFERENCES ref.auto_hint(pk) ON UPDATE RESTRICT ON DELETE CASCADE
Trigger:
    zt_del_auto_hint BEFORE DELETE ON ref.auto_hint FOR EACH ROW EXECUTE PROCEDURE audit.ft_del_auto_hint()
    zt_ins_auto_hint BEFORE INSERT ON ref.auto_hint FOR EACH ROW EXECUTE PROCEDURE audit.ft_ins_auto_hint()
    zt_upd_auto_hint BEFORE UPDATE ON ref.auto_hint FOR EACH ROW EXECUTE PROCEDURE audit.ft_upd_auto_hint()
Erbt von: audit.audit_fields