Dumped on 2009-11-07
table for referrals to defined individuals
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_fields_pk_audit_seq'::regclass) | |
| row_version | integer | NOT NULL | |
| modified_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| modified_by | name | NOT NULL DEFAULT "current_user"() | |
| pk_item | integer | NOT NULL DEFAULT nextval('clin.clin_root_item_pk_item_seq'::regclass) | |
| clin_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| clin.encounter.pk | fk_encounter | integer | NOT NULL |
| clin.episode.pk | fk_episode | integer | NOT NULL |
| narrative | text |
inherited from clin.clin_root_item; stores text of referral letter |
|
| soap_cat | text | ||
| id | serial | PRIMARY KEY | |
| dem.identity.pk | fk_referee | integer |
NOT NULL
person to whom the referral is directed |
| clin.form_instances.pk | fk_form | integer |
NOT NULL
foreign key to the form instance of this referral. |
Table au.referral Inherits clin_root_item,
| Name | Constraint |
|---|---|
| clin_root_item_soap_cat_check | CHECK (((soap_cat IS NULL) OR ((((lower(soap_cat) = 's'::text) OR (lower(soap_cat) = 'o'::text)) OR (lower(soap_cat) = 'a'::text)) OR (lower(soap_cat) = 'p'::text)))) |
| referral_soap_cat_check | CHECK (((soap_cat IS NULL) OR ((((lower(soap_cat) = 's'::text) OR (lower(soap_cat) = 'o'::text)) OR (lower(soap_cat) = 'a'::text)) OR (lower(soap_cat) = 'p'::text)))) |
this table holds all the fields needed for auditing
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | serial | PRIMARY KEY | |
| row_version | integer |
NOT NULL
the version of the row; mainly just a count |
|
| modified_when | timestamp with time zone |
NOT NULL
DEFAULT now()
when has this row been committed (created/modified) |
|
| modified_by | name |
NOT NULL
DEFAULT "current_user"()
by whom has this row been committed (created/modified) |
Each table that needs standard auditing must have a log table inheriting from this table. Log tables have the same name with a prepended "log_". However, log_* tables shall not have constraints.
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | serial | PRIMARY KEY | |
| orig_version | integer |
NOT NULL
the version of this row in the original table previous to the modification |
|
| orig_when | timestamp with time zone |
NOT NULL
previous modification date in the original table |
|
| orig_by | name |
NOT NULL
who committed the row to the original table |
|
| orig_tableoid | oid |
NOT NULL
the table oid of the original table, use this to identify the source table |
|
| audit_action | text |
NOT NULL
either "update" or "delete" |
|
| audit_when | timestamp with time zone |
NOT NULL
DEFAULT now()
when committed to this table for auditing |
|
| audit_by | name |
NOT NULL
DEFAULT "current_user"()
committed to this table for auditing by whom |
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
All tables that need standard auditing must be recorded in this table. Audit triggers will be generated automatically for all tables recorded here.
| F-Key | Name | Type | Description |
|---|---|---|---|
| id | serial | PRIMARY KEY | |
| schema | name | UNIQUE#1 NOT NULL DEFAULT 'public'::name | |
| table_name | name | UNIQUE#1 NOT NULL |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| user_action | text |
Table audit.log_access_log Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text | ||
| atc_code | text |
Table audit.log_active_substance Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_street | integer | ||
| aux_street | text | ||
| number | text | ||
| subunit | text | ||
| addendum | text | ||
| lat_lon | point |
Table audit.log_address Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| substance | text | ||
| substance_code | text | ||
| generics | text | ||
| allergene | text | ||
| atc_code | text | ||
| fk_type | integer | ||
| generic_specific | boolean | ||
| definite | boolean |
Table audit.log_allergy Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| has_allergy | integer | ||
| comment | text | ||
| last_confirmed | timestamp with time zone | ||
| fk_encounter | integer |
Table audit.log_allergy_state Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| code | text | ||
| kurzform | text | ||
| name | text |
Table audit.log_beh_fall_typ Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| pk | integer | ||
| fk_patient | integer | ||
| fk_falltyp | integer | ||
| started | date | ||
| must_pay_prax_geb | boolean |
Table audit.log_behandlungsfall Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer |
Table audit.log_clin_aux_note Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_narrative | integer | ||
| laterality | bpchar | ||
| is_chronic | boolean | ||
| is_active | boolean | ||
| is_definite | boolean | ||
| clinically_relevant | boolean |
Table audit.log_clin_diag Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| fk_hx_family_item | integer |
Table audit.log_clin_hx_family Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| type | text | ||
| code | text |
Table audit.log_clin_item_type Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer |
Table audit.log_clin_narrative Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| term | text | ||
| code | text | ||
| xfk_coding_system | text |
Table audit.log_coded_phrase Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text | ||
| atc_code | text |
Table audit.log_consumed_substance Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| name_short | text | ||
| name_long | text | ||
| version | text | ||
| description | text | ||
| source | text | ||
| lang | text |
Table audit.log_data_source Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_doc | integer | ||
| text | text |
Table audit.log_doc_desc Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| fk_type | integer | ||
| comment | text | ||
| clin_when | timestamp with time zone | ||
| ext_ref | text |
Table audit.log_doc_med Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_health_issue | integer | ||
| description | text | ||
| is_open | boolean | ||
| fk_encounter | integer | ||
| diagnostic_certainty_classification | text |
Table audit.log_episode Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_instance | integer | ||
| fk_form_field | integer | ||
| value | text |
Table audit.log_form_data Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| fk_form_def | integer | ||
| form_name | text |
Table audit.log_form_instances Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| tag | text | ||
| label | text | ||
| sort_weight | integer | ||
| comment | text |
Table audit.log_gender_label Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text | ||
| laterality | character varying | ||
| age_noted | interval | ||
| is_active | boolean | ||
| clinically_relevant | boolean | ||
| is_confidential | boolean | ||
| is_cause_of_death | boolean | ||
| fk_encounter | integer | ||
| grouping | text | ||
| diagnostic_certainty_classification | text |
Table audit.log_health_issue Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| discharge | timestamp with time zone |
Table audit.log_hospital_stay Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_narrative_condition | integer | ||
| fk_relative | integer | ||
| name_relative | text | ||
| dob_relative | timestamp with time zone | ||
| condition | text | ||
| age_noted | text | ||
| age_of_death | interval | ||
| is_cause_of_death | boolean |
Table audit.log_hx_family_item Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| deleted | boolean | ||
| pupic | bpchar | ||
| gender | text | ||
| karyotype | text | ||
| dob | timestamp with time zone | ||
| fk_marital_status | integer | ||
| cob | bpchar | ||
| deceased | timestamp with time zone | ||
| title | text | ||
| tob | time without time zone |
Table audit.log_identity Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text | ||
| is_user | boolean |
Table audit.log_inbox_item_category Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_inbox_item_category | integer | ||
| description | text | ||
| is_user | boolean |
Table audit.log_inbox_item_type Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_patient_candidates | integer[] | ||
| request_id | text | ||
| firstnames | text | ||
| lastnames | text | ||
| dob | date | ||
| postcode | text | ||
| other_info | text | ||
| type | text | ||
| data | bytea | ||
| gender | text | ||
| requestor | text | ||
| external_data_id | text | ||
| fk_identity_disambiguated | integer |
Table audit.log_incoming_data_unmatchable Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_patient_candidates | integer[] | ||
| request_id | text | ||
| firstnames | text | ||
| lastnames | text | ||
| dob | date | ||
| postcode | text | ||
| other_info | text | ||
| type | text | ||
| data | bytea | ||
| gender | text | ||
| requestor | text | ||
| external_data_id | text | ||
| fk_identity_disambiguated | integer |
Table audit.log_incoming_data_unmatched Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| fk_test_org | integer | ||
| request_id | text | ||
| fk_requestor | integer | ||
| lab_request_id | text | ||
| lab_rxd_when | timestamp with time zone | ||
| results_reported_when | timestamp with time zone | ||
| request_status | text | ||
| is_pending | boolean | ||
| diagnostic_service_section | text | ||
| ordered_service | text |
Table audit.log_lab_request Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_test | integer |
Table audit.log_lab_test_gnr Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_vaccination_course | integer | ||
| fk_constraint | integer |
Table audit.log_lnk_constraint2vacc_course Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_identity | integer | ||
| external_id | text | ||
| fk_origin | integer | ||
| comment | text |
Table audit.log_lnk_identity2ext_id Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| pk | integer | ||
| fk_identity | integer | ||
| fk_primary_doc | integer |
Table audit.log_lnk_identity2primary_doc Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_identity | integer | ||
| fk_occupation | integer | ||
| activities | text |
Table audit.log_lnk_job2person Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_patient | integer | ||
| fk_course | integer |
Table audit.log_lnk_pat2vaccination_course Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_identity | integer | ||
| id_relative | integer | ||
| id_relation_type | integer | ||
| started | date | ||
| ended | date |
Table audit.log_lnk_person2relative Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_test | integer | ||
| id_norm | integer |
Table audit.log_lnk_tst2norm Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_type | integer | ||
| fk_item | integer |
Table audit.log_lnk_type2item Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_course | integer | ||
| fk_schedule | integer |
Table audit.log_lnk_vaccination_course2schedule Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| fk_vaccine | integer | ||
| fk_indication | integer |
Table audit.log_lnk_vaccine2inds Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_staff | integer | ||
| fk_inbox_item_type | integer | ||
| comment | text | ||
| ufk_context | integer | ||
| data | text | ||
| importance | smallint | ||
| fk_patient | integer |
Table audit.log_message_inbox Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| name | text |
Table audit.log_occupation Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_health_issue | integer | ||
| fk_encounter | integer | ||
| clin_where | text | ||
| comment | text |
Table audit.log_operation Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_template_type | integer | ||
| instance_type | text | ||
| name_short | text | ||
| name_long | text | ||
| external_version | text | ||
| gnumed_revision | double precision | ||
| engine | text | ||
| in_use | boolean | ||
| filename | text | ||
| data | bytea |
Table audit.log_paperwork_templates Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_fall | integer | ||
| paid_amount | numeric | ||
| paid_when | date | ||
| paid_with | integer |
Table audit.log_prax_geb_paid Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| clin_where | text | ||
| fk_hospital_stay | integer |
Table audit.log_procedure Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| id | integer | ||
| fk_referee | integer | ||
| fk_form | integer |
Table audit.log_referral Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| inverse | integer | ||
| biological | boolean | ||
| biol_verified | boolean | ||
| description | text |
Table audit.log_relation_types Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| label | text | ||
| cmd | text |
Table audit.log_report_query Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_identity | integer | ||
| fk_role | integer | ||
| db_user | name | ||
| short_alias | text | ||
| comment | text | ||
| is_active | boolean |
Table audit.log_staff Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| name | text | ||
| comment | text |
Table audit.log_staff_role Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| code | text | ||
| country | bpchar | ||
| name | text |
Table audit.log_state Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_urb | integer | ||
| name | text | ||
| postcode | text | ||
| suburb | text | ||
| lat_lon | point |
Table audit.log_street Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text | ||
| preparation | text | ||
| atc_code | text | ||
| is_fake | boolean | ||
| external_code | text |
Table audit.log_substance_brand Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit.audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| fk_brand | integer | ||
| fk_substance | integer | ||
| strength | text | ||
| preparation | text | ||
| schedule | text | ||
| aim | text | ||
| duration | interval | ||
| intake_is_approved_of | boolean | ||
| is_long_term | boolean |
Table audit.log_substance_intake Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_org | integer | ||
| fk_adm_contact | integer | ||
| fk_med_contact | integer | ||
| internal_name | text | ||
| comment | text |
Table audit.log_test_org Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| pk | integer | ||
| fk_type | integer | ||
| val_num | numeric | ||
| val_alpha | text | ||
| val_unit | text | ||
| val_normal_min | numeric | ||
| val_normal_max | numeric | ||
| val_normal_range | text | ||
| val_target_min | numeric | ||
| val_target_max | numeric | ||
| val_target_range | text | ||
| abnormality_indicator | text | ||
| norm_ref_group | text | ||
| note_test_org | text | ||
| material | text | ||
| material_detail | text | ||
| fk_intended_reviewer | integer |
Table audit.log_test_result Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_test_org | integer | ||
| code | text | ||
| coding_system | text | ||
| name | text | ||
| comment | text | ||
| conversion_unit | text | ||
| loinc | text | ||
| abbrev | text |
Table audit.log_test_type Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| id_state | integer | ||
| postcode | text | ||
| lat_lon | point | ||
| name | text |
Table audit.log_urb Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| description | text |
Table audit.log_vacc_indication Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| abbreviation | text | ||
| description | text |
Table audit.log_vacc_route Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk_item | integer | ||
| clin_when | timestamp with time zone | ||
| fk_encounter | integer | ||
| fk_episode | integer | ||
| narrative | text | ||
| soap_cat | text | ||
| id | integer | ||
| fk_patient | integer | ||
| fk_provider | integer | ||
| fk_vaccine | integer | ||
| site | text | ||
| batch_no | text |
Table audit.log_vaccination Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_recommended_by | integer | ||
| fk_indication | integer | ||
| is_active | boolean | ||
| comment | text |
Table audit.log_vaccination_course Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| description | text |
Table audit.log_vaccination_course_constraint Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| id | integer | ||
| fk_course | integer | ||
| is_booster | boolean | ||
| seq_no | integer | ||
| min_age_due | interval | ||
| max_age_due | interval | ||
| min_interval | interval | ||
| comment | text |
Table audit.log_vaccination_definition Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| name | text | ||
| comment | text |
Table audit.log_vaccination_schedule Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| id_route | integer | ||
| trade_name | text | ||
| short_name | text | ||
| is_live | boolean | ||
| min_age | interval | ||
| max_age | interval | ||
| comment | text |
Table audit.log_vaccine Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_vaccine | integer | ||
| batch_no | text |
Table audit.log_vaccine_batches Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| fk_patient | integer | ||
| registered | timestamp with time zone | ||
| urgency | integer | ||
| list_position | integer | ||
| comment | text | ||
| area | text |
Table audit.log_waiting_list Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
| F-Key | Name | Type | Description |
|---|---|---|---|
| pk_audit | integer | NOT NULL DEFAULT nextval('audit_trail_pk_audit_seq'::regclass) | |
| orig_version | integer | NOT NULL | |
| orig_when | timestamp with time zone | NOT NULL | |
| orig_by | name | NOT NULL | |
| orig_tableoid | oid | NOT NULL | |
| audit_action | text | NOT NULL | |
| audit_when | timestamp with time zone | NOT NULL DEFAULT now() | |
| audit_by | name | NOT NULL DEFAULT "current_user"() | |
| row_version | integer | ||
| modified_when | timestamp with time zone | ||
| modified_by | name | ||
| pk | integer | ||
| xfk_identity | integer | ||
| pupic | text | ||
| data | text |
Table audit.log_xlnk_identity Inherits audit_trail,
| Name | Constraint |
|---|---|
| audit_trail_audit_action_check | CHECK (((audit_action = 'UPDATE'::text) OR (audit_action = 'DELETE'::text))) |
sanity-checking convenience function for marking tables for auditing, schema is always "public"
select audit.add_table_for_audit('public', $1);
sanity-checking convenience function for marking tables for auditing
DECLARE _relnamespace alias for $1; _relname ALIAS FOR $2; dummy RECORD; tmp text; BEGIN -- does table exist ? select relname into dummy from pg_class where relname = _relname and relnamespace = (select oid from pg_namespace where nspname = _relnamespace) ; if not found then tmp := _relnamespace || '.' || _relname; raise exception 'audit.add_table_for_audit: Table [%] does not exist.', tmp; return false; end if; -- already queued for auditing ? select 1 into dummy from audit.audited_tables where table_name = _relname and schema = _relnamespace; if found then return true; end if; -- add definition insert into audit.audited_tables ( schema, table_name ) values ( _relnamespace, _relname ); return true; END;
BEGIN INSERT INTO audit.log_access_log ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, user_action ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.user_action ); return OLD; END;
BEGIN INSERT INTO audit.log_active_substance ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description, atc_code ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description, OLD.atc_code ); return OLD; END;
BEGIN INSERT INTO audit.log_address ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_street, aux_street, number, subunit, addendum, lat_lon ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_street, OLD.aux_street, OLD.number, OLD.subunit, OLD.addendum, OLD.lat_lon ); return OLD; END;
BEGIN INSERT INTO audit.log_allergy ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, substance, substance_code, generics, allergene, atc_code, fk_type, generic_specific, definite ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.substance, OLD.substance_code, OLD.generics, OLD.allergene, OLD.atc_code, OLD.fk_type, OLD.generic_specific, OLD.definite ); return OLD; END;
BEGIN INSERT INTO audit.log_allergy_state ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, has_allergy, comment, last_confirmed, fk_encounter ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.has_allergy, OLD.comment, OLD.last_confirmed, OLD.fk_encounter ); return OLD; END;
BEGIN INSERT INTO audit.log_atc_group ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, code, description ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.code, OLD.description ); return OLD; END;
BEGIN INSERT INTO audit.log_atc_substance ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, code, name, ddd_amount, fk_ddd_unit, route, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.code, OLD.name, OLD.ddd_amount, OLD.fk_ddd_unit, OLD.route, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_beh_fall_typ ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, code, kurzform, name ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.code, OLD.kurzform, OLD.name ); return OLD; END;
BEGIN INSERT INTO audit.log_behandlungsfall ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk, fk_patient, fk_falltyp, started, must_pay_prax_geb ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk, OLD.fk_patient, OLD.fk_falltyp, OLD.started, OLD.must_pay_prax_geb ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_aux_note ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_diag ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_narrative, laterality, is_chronic, is_active, is_definite, clinically_relevant ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_narrative, OLD.laterality, OLD.is_chronic, OLD.is_active, OLD.is_definite, OLD.clinically_relevant ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_hx_family ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, fk_hx_family_item ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.fk_hx_family_item ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_item_type ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, type, code ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.type, OLD.code ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_medication ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, last_prescribed, fk_last_script, discontinued, brandname, generic, adjuvant, dosage_form, ufk_drug, drug_db, atc_code, is_cr, dosage, period, dosage_unit, directions, is_prn ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.last_prescribed, OLD.fk_last_script, OLD.discontinued, OLD.brandname, OLD.generic, OLD.adjuvant, OLD.dosage_form, OLD.ufk_drug, OLD.drug_db, OLD.atc_code, OLD.is_cr, OLD.dosage, OLD.period, OLD.dosage_unit, OLD.directions, OLD.is_prn ); return OLD; END;
BEGIN INSERT INTO audit.log_clin_narrative ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk ); return OLD; END;
BEGIN INSERT INTO audit.log_coded_phrase ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, term, code, xfk_coding_system ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.term, OLD.code, OLD.xfk_coding_system ); return OLD; END;
BEGIN INSERT INTO audit.log_consumed_substance ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description, atc_code ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description, OLD.atc_code ); return OLD; END;
BEGIN INSERT INTO audit.log_data_source ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, name_long, name_short, version, description, source, lang ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.name_long, OLD.name_short, OLD.version, OLD.description, OLD.source, OLD.lang ); return OLD; END;
BEGIN INSERT INTO audit.log_doc_desc ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_doc, text ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_doc, OLD.text ); return OLD; END;
BEGIN INSERT INTO audit.log_doc_med ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_encounter, fk_episode, fk_type, comment, clin_when, ext_ref ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_encounter, OLD.fk_episode, OLD.fk_type, OLD.comment, OLD.clin_when, OLD.ext_ref ); return OLD; END;
BEGIN INSERT INTO audit.log_episode ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_health_issue, description, is_open, fk_encounter, diagnostic_certainty_classification ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_health_issue, OLD.description, OLD.is_open, OLD.fk_encounter, OLD.diagnostic_certainty_classification ); return OLD; END;
BEGIN INSERT INTO audit.log_form_data ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_instance, fk_form_field, value ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_instance, OLD.fk_form_field, OLD.value ); return OLD; END;
BEGIN INSERT INTO audit.log_form_defs ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_type, country, locale, soap_cat, name_short, name_long, revision, template, engine, in_use, url, is_user ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_type, OLD.country, OLD.locale, OLD.soap_cat, OLD.name_short, OLD.name_long, OLD.revision, OLD.template, OLD.engine, OLD.in_use, OLD.url, OLD.is_user ); return OLD; END;
BEGIN INSERT INTO audit.log_form_instances ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, fk_form_def, form_name ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.fk_form_def, OLD.form_name ); return OLD; END;
BEGIN INSERT INTO audit.log_gender_label ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, tag, label, sort_weight, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.tag, OLD.label, OLD.sort_weight, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_health_issue ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description, laterality, age_noted, is_active, clinically_relevant, is_confidential, is_cause_of_death, fk_encounter, grouping, diagnostic_certainty_classification ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description, OLD.laterality, OLD.age_noted, OLD.is_active, OLD.clinically_relevant, OLD.is_confidential, OLD.is_cause_of_death, OLD.fk_encounter, OLD.grouping, OLD.diagnostic_certainty_classification ); return OLD; END;
BEGIN INSERT INTO audit.log_hospital_stay ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, discharge ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.discharge ); return OLD; END;
BEGIN INSERT INTO audit.log_hx_family_item ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_narrative_condition, fk_relative, name_relative, dob_relative, condition, age_noted, age_of_death, is_cause_of_death ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_narrative_condition, OLD.fk_relative, OLD.name_relative, OLD.dob_relative, OLD.condition, OLD.age_noted, OLD.age_of_death, OLD.is_cause_of_death ); return OLD; END;
BEGIN INSERT INTO audit.log_identity ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, deleted, pupic, gender, karyotype, dob, fk_marital_status, cob, deceased, title, tob ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.deleted, OLD.pupic, OLD.gender, OLD.karyotype, OLD.dob, OLD.fk_marital_status, OLD.cob, OLD.deceased, OLD.title, OLD.tob ); return OLD; END;
BEGIN INSERT INTO audit.log_inbox_item_category ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description, is_user ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description, OLD.is_user ); return OLD; END;
BEGIN INSERT INTO audit.log_inbox_item_type ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_inbox_item_category, description, is_user ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_inbox_item_category, OLD.description, OLD.is_user ); return OLD; END;
BEGIN INSERT INTO audit.log_incoming_data_unmatchable ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_patient_candidates, request_id, firstnames, lastnames, dob, postcode, other_info, type, data, gender, requestor, external_data_id, fk_identity_disambiguated ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_patient_candidates, OLD.request_id, OLD.firstnames, OLD.lastnames, OLD.dob, OLD.postcode, OLD.other_info, OLD.type, OLD.data, OLD.gender, OLD.requestor, OLD.external_data_id, OLD.fk_identity_disambiguated ); return OLD; END;
BEGIN INSERT INTO audit.log_incoming_data_unmatched ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_patient_candidates, request_id, firstnames, lastnames, dob, postcode, other_info, type, data, gender, requestor, external_data_id, fk_identity_disambiguated ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_patient_candidates, OLD.request_id, OLD.firstnames, OLD.lastnames, OLD.dob, OLD.postcode, OLD.other_info, OLD.type, OLD.data, OLD.gender, OLD.requestor, OLD.external_data_id, OLD.fk_identity_disambiguated ); return OLD; END;
BEGIN INSERT INTO audit.log_lab_request ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, fk_test_org, request_id, fk_requestor, lab_request_id, lab_rxd_when, results_reported_when, request_status, is_pending, diagnostic_service_section, ordered_service ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.fk_test_org, OLD.request_id, OLD.fk_requestor, OLD.lab_request_id, OLD.lab_rxd_when, OLD.results_reported_when, OLD.request_status, OLD.is_pending, OLD.diagnostic_service_section, OLD.ordered_service ); return OLD; END;
BEGIN INSERT INTO audit.log_lab_test_gnr ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_test ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_test ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_constraint2vacc_course ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_vaccination_course, fk_constraint ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_vaccination_course, OLD.fk_constraint ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_identity2ext_id ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_identity, external_id, fk_origin, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_identity, OLD.external_id, OLD.fk_origin, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_identity2primary_doc ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk, fk_identity, fk_primary_doc ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk, OLD.fk_identity, OLD.fk_primary_doc ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_job2person ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_identity, fk_occupation, activities ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_identity, OLD.fk_occupation, OLD.activities ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_pat2vaccination_course ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_patient, fk_course ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_patient, OLD.fk_course ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_person2relative ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_identity, id_relative, id_relation_type, started, ended ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_identity, OLD.id_relative, OLD.id_relation_type, OLD.started, OLD.ended ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_tst2norm ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_test, id_norm ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_test, OLD.id_norm ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_type2item ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_type, fk_item ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_type, OLD.fk_item ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_vaccination_course2schedule ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_course, fk_schedule ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_course, OLD.fk_schedule ); return OLD; END;
BEGIN INSERT INTO audit.log_lnk_vaccine2inds ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, fk_vaccine, fk_indication ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.fk_vaccine, OLD.fk_indication ); return OLD; END;
BEGIN INSERT INTO audit.log_message_inbox ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_staff, fk_inbox_item_type, comment, ufk_context, data, importance, fk_patient ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_staff, OLD.fk_inbox_item_type, OLD.comment, OLD.ufk_context, OLD.data, OLD.importance, OLD.fk_patient ); return OLD; END;
BEGIN INSERT INTO audit.log_occupation ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, name ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.name ); return OLD; END;
BEGIN INSERT INTO audit.log_operation ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_health_issue, fk_encounter, clin_where, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_health_issue, OLD.fk_encounter, OLD.clin_where, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_paperwork_templates ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_template_type, instance_type, name_short, name_long, external_version, gnumed_revision, engine, in_use, filename, data ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_template_type, OLD.instance_type, OLD.name_short, OLD.name_long, OLD.external_version, OLD.gnumed_revision, OLD.engine, OLD.in_use, OLD.filename, OLD.data ); return OLD; END;
BEGIN INSERT INTO audit.log_prax_geb_paid ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_fall, paid_amount, paid_when, paid_with ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_fall, OLD.paid_amount, OLD.paid_when, OLD.paid_with ); return OLD; END;
BEGIN INSERT INTO audit.log_procedure ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, clin_where, fk_hospital_stay ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.clin_where, OLD.fk_hospital_stay ); return OLD; END;
BEGIN INSERT INTO audit.log_ref_source ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, name_short, name_long, version, description, source ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.name_short, OLD.name_long, OLD.version, OLD.description, OLD.source ); return OLD; END;
BEGIN INSERT INTO audit.log_referral ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, id, fk_referee, fk_form ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.id, OLD.fk_referee, OLD.fk_form ); return OLD; END;
BEGIN INSERT INTO audit.log_relation_types ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, inverse, biological, biol_verified, description ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.inverse, OLD.biological, OLD.biol_verified, OLD.description ); return OLD; END;
BEGIN INSERT INTO audit.log_report_query ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, label, cmd ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.label, OLD.cmd ); return OLD; END;
BEGIN INSERT INTO audit.log_staff ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_identity, fk_role, db_user, short_alias, comment, is_active ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_identity, OLD.fk_role, OLD.db_user, OLD.short_alias, OLD.comment, OLD.is_active ); return OLD; END;
BEGIN INSERT INTO audit.log_staff_role ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, name, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.name, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_state ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, code, country, name ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.code, OLD.country, OLD.name ); return OLD; END;
BEGIN INSERT INTO audit.log_street ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_urb, name, postcode, suburb, lat_lon ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_urb, OLD.name, OLD.postcode, OLD.suburb, OLD.lat_lon ); return OLD; END;
BEGIN INSERT INTO audit.log_substance_brand ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description, preparation, atc_code, is_fake, external_code ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description, OLD.preparation, OLD.atc_code, OLD.is_fake, OLD.external_code ); return OLD; END;
BEGIN INSERT INTO audit.log_substance_intake ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, fk_brand, fk_substance, strength, preparation, schedule, aim, duration, intake_is_approved_of, is_long_term ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.fk_brand, OLD.fk_substance, OLD.strength, OLD.preparation, OLD.schedule, OLD.aim, OLD.duration, OLD.intake_is_approved_of, OLD.is_long_term ); return OLD; END;
BEGIN INSERT INTO audit.log_test_org ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_org, fk_adm_contact, fk_med_contact, internal_name, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_org, OLD.fk_adm_contact, OLD.fk_med_contact, OLD.internal_name, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_test_result ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, pk, fk_type, val_num, val_alpha, val_unit, val_normal_min, val_normal_max, val_normal_range, val_target_min, val_target_max, val_target_range, abnormality_indicator, norm_ref_group, note_test_org, material, material_detail, fk_intended_reviewer ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.pk, OLD.fk_type, OLD.val_num, OLD.val_alpha, OLD.val_unit, OLD.val_normal_min, OLD.val_normal_max, OLD.val_normal_range, OLD.val_target_min, OLD.val_target_max, OLD.val_target_range, OLD.abnormality_indicator, OLD.norm_ref_group, OLD.note_test_org, OLD.material, OLD.material_detail, OLD.fk_intended_reviewer ); return OLD; END;
BEGIN INSERT INTO audit.log_test_type ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_test_org, code, coding_system, name, comment, conversion_unit, loinc, abbrev ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_test_org, OLD.code, OLD.coding_system, OLD.name, OLD.comment, OLD.conversion_unit, OLD.loinc, OLD.abbrev ); return OLD; END;
BEGIN INSERT INTO audit.log_urb ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, id_state, postcode, lat_lon, name ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.id_state, OLD.postcode, OLD.lat_lon, OLD.name ); return OLD; END;
BEGIN INSERT INTO audit.log_vacc_indication ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, description ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.description ); return OLD; END;
BEGIN INSERT INTO audit.log_vacc_route ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, abbreviation, description ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.abbreviation, OLD.description ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccination ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk_item, clin_when, fk_encounter, fk_episode, narrative, soap_cat, id, fk_provider, fk_vaccine, site, batch_no ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk_item, OLD.clin_when, OLD.fk_encounter, OLD.fk_episode, OLD.narrative, OLD.soap_cat, OLD.id, OLD.fk_provider, OLD.fk_vaccine, OLD.site, OLD.batch_no ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccination_course ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_recommended_by, fk_indication, is_active, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_recommended_by, OLD.fk_indication, OLD.is_active, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccination_course_constraint ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, description ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.description ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccination_definition ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, id, fk_course, is_booster, seq_no, min_age_due, max_age_due, min_interval, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.id, OLD.fk_course, OLD.is_booster, OLD.seq_no, OLD.min_age_due, OLD.max_age_due, OLD.min_interval, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccination_schedule ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, name, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.name, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccine ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, id_route, trade_name, short_name, is_live, min_age, max_age, comment ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.id_route, OLD.trade_name, OLD.short_name, OLD.is_live, OLD.min_age, OLD.max_age, OLD.comment ); return OLD; END;
BEGIN INSERT INTO audit.log_vaccine_batches ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_vaccine, batch_no ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_vaccine, OLD.batch_no ); return OLD; END;
BEGIN INSERT INTO audit.log_waiting_list ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, fk_patient, registered, urgency, list_position, comment, area ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.fk_patient, OLD.registered, OLD.urgency, OLD.list_position, OLD.comment, OLD.area ); return OLD; END;
BEGIN INSERT INTO audit.log_xlnk_identity ( orig_version, orig_when, orig_by, orig_tableoid, audit_action, pk_audit, row_version, modified_when, modified_by, pk, xfk_identity, pupic, data ) VALUES ( OLD.row_version, OLD.modified_when, OLD.modified_by, TG_RELID, TG_OP, OLD.pk_audit, OLD.row_version, OLD.modified_when, OLD.modified_by, OLD.pk, OLD.xfk_identity, OLD.pupic, OLD.data ); return OLD; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;
BEGIN NEW.row_version := 0; NEW.modified_when := CURRENT_TIMESTAMP; NEW.modified_by := SESSION_USER; return NEW; END;