audit.audit_fields.txt

Ausgabeformat ist »wrapped«.
                                                                                             Tabelle »audit.audit_fields«
    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       |               | the version of the row; mainly just a count
 modified_when | timestamp with time zone |              | not null      | CURRENT_TIMESTAMP                                    | plain       |               | when has this row been committed (created/modified)
 modified_by   | name                     |              | not null      | CURRENT_USER                                         | plain       |               | by whom has this row been committed (created/modified)
Indexe:
    "audit_fields_pkey" PRIMARY KEY, btree (pk_audit)
Check-Constraints:
    "audit_audit_fields_sane_modified_when" CHECK ((modified_when <= clock_timestamp()) IS TRUE)
Regeln:
    audit_fields_no_del AS
    ON DELETE TO audit.audit_fields DO INSTEAD NOTHING
    audit_fields_no_ins AS
    ON INSERT TO audit.audit_fields DO INSTEAD NOTHING
    audit_fields_no_upd AS
    ON UPDATE TO audit.audit_fields DO INSTEAD NOTHING
Kindtabellen: bill.bill,
              bill.bill_item,
              blobs.doc_desc,
              blobs.doc_med,
              blobs.lnk_doc2hospital_stay,
              blobs.lnk_doc_med2episode,
              cfg.report_query,
              clin.allergy_state,
              clin.clin_diag,
              clin.clin_item_type,
              clin.clin_root_item,
              clin.encounter,
              clin.episode,
              clin.external_care,
              clin.fhx_relation_type,
              clin.form_data,
              clin.health_issue,
              clin.incoming_data_unmatchable,
              clin.incoming_data_unmatched,
              clin.lnk_code2item_root,
              clin.lnk_constraint2vacc_course,
              clin.lnk_pat2vaccination_course,
              clin.lnk_substance2episode,
              clin.lnk_tst2norm,
              clin.lnk_type2item,
              clin.lnk_vaccination_course2schedule,
              clin.lnk_vaccine2inds,
              clin.patient,
              clin.review_root,
              clin.suppressed_hint,
              clin.test_org,
              clin.test_panel,
              clin.test_type,
              clin.vaccination_course,
              clin.vaccination_course_constraint,
              clin.vaccination_definition,
              clin.vaccination_schedule,
              clin.vacc_indication,
              clin.vaccine,
              clin.vaccine_batches,
              clin.vacc_route,
              clin.waiting_list,
              de_de.beh_fall_typ,
              de_de.lab_test_gnr,
              de_de.prax_geb_paid,
              dem.address,
              dem.gender_label,
              dem.identity,
              dem.identity_tag,
              dem.inbox_item_category,
              dem.inbox_item_type,
              dem.lnk_identity2ext_id,
              dem.lnk_job2person,
              dem.lnk_org_unit2comm,
              dem.lnk_org_unit2ext_id,
              dem.lnk_person2relative,
              dem.message_inbox,
              dem.occupation,
              dem.org,
              dem.org_unit,
              dem.praxis_branch,
              dem.region,
              dem.relation_types,
              dem.staff,
              dem.street,
              dem.urb,
              gm.access_log,
              ref.auto_hint,
              ref.branded_drug,
              ref.consumable_substance,
              ref.data_source,
              ref.lnk_substance2brand,
              ref.paperwork_templates,
              ref.tag_image