Fingerprinting GNUmed database ...

           Name: gnumed_v15
           Size: 41 MB
           Hash: 70012ff960b77ecdff4981c94b5b55b6
       Patients: 14
       Contacts: 7
       Episodes: 5
         Issues: 2
        Results: 5
   Vaccinations: 1
      Documents: 3
        Objects: 4

clin.clin_hx_family.clin_when::timestamptz
clin.clin_item_type.modified_by::name
blobs.doc_desc.modified_when::timestamptz
clin.reviewed_test_results.comment::text
clin.form_data.modified_by::name
clin.hx_family_item.age_of_death::interval
clin.vaccination.soap_cat::text
blobs.doc_med.fk_encounter::int4
cfg.cfg_str_array.fk_item::int4
dem.street.name::text
clin.procedure.clin_end::timestamptz
staging.test_result.abnormality_indicator::text
clin.allergy.row_version::int4
dem.lnk_org_unit2comm.is_confidential::bool
dem.staff.fk_identity::int4
dem.org_unit.fk_category::int4
clin.test_type.coding_system::text
staging.lab_request.modified_when::timestamptz
clin.vacc_route.abbreviation::text
dem.org.pk_audit::int4
clin.allergy.pk::int4
clin.waiting_list.urgency::int4
dem.urb.id::int4
ref.coding_system_root.comment::text
dem.lnk_job2person.fk_identity::int4
clin._enum_allergy_type.pk::int4
dem.state.code::text
clin.substance_intake.pk_audit::int4
clin.form_instances.pk_audit::int4
ref.loinc_staging.system::text
blobs.doc_med.fk_episode::int4
ref.loinc_staging.units_required::text
ref.loinc_staging.status::text
clin.lnk_vaccination_course2schedule.fk_course::int4
clin.lnk_pat2vaccination_course.row_version::int4
clin.lab_request.clin_when::timestamptz
cfg.config.crypt_pwd::text
clin.lab_request.row_version::int4
dem.message_inbox.fk_inbox_item_type::int4
ref.icpc_chapter.pk::int4
clin.clin_item_type.modified_when::timestamptz
clin.test_type.name::text
ref.form_types.name::text
dem.marital_status.pk::int4
cfg.cfg_string.value::text
ref.loinc.base_name::text
dem.address.modified_by::name
ref.loinc_staging.class::text
ref.loinc.code::text
clin.lnk_vaccine2inds.pk_audit::int4
clin.lnk_vaccination_course2schedule.row_version::int4
dem.lnk_identity2ext_id.pk_audit::int4
blobs.reviewed_doc_objs.row_version::int4
clin.test_result.pk::int4
clin.vaccination.pk::int4
clin.vacc_indication.description::text
staging.lab_request.fk_incoming_data_unmatched::int4
clin.vaccination_schedule.modified_by::name
ref.branded_drug.fk_data_source::int4
clin.clin_root_item.narrative::text
cfg.db_logon_banner.message::text
clin.clin_diag.is_active::bool
clin.incoming_data_unmatched.comment::text
clin.lab_request.soap_cat::text
clin.incoming_data_unmatched.dob::date
ref.loinc.scope::text
ref.form_types.pk::int4
dem.address.aux_street::text
blobs.doc_type.name::text
staging.lab_request.clin_when::timestamptz
clin.vaccination_definition.min_age_due::interval
clin.lab_request.fk_encounter::int4
clin.clin_hx_family.fk_episode::int4
clin.soap_cat_ranks.soap_cat::bpchar
i18n.keys.pk::int4
clin.clin_hx_family.modified_when::timestamptz
ref.loinc_staging.base_name::text
clin.clin_hx_family.pk::int4
clin.incoming_data_unmatched.fk_patient_candidates::_int4
dem.staff.comment::text
ref.loinc.species::text
clin.review_root.fk_reviewer::int4
clin.operation.fk_encounter::int4
ref.paperwork_templates.pk::int4
staging.lab_request.fk_requestor::int4
cfg.config.db::int4
staging.lab_request.narrative::text
blobs.doc_obj.fk_intended_reviewer::int4
clin.vaccination_course_constraint.row_version::int4
dem.identity.row_version::int4
clin.vaccine_batches.modified_when::timestamptz
dem.inbox_item_category.pk::int4
dem.urb.row_version::int4
clin.clin_narrative.modified_by::name
ref.loinc_staging.time_aspect::text
staging.test_result.modified_by::name
clin.substance_intake.is_long_term::bool
dem.lnk_job2person.pk_audit::int4
clin.health_issue.pk_audit::int4
clin.lnk_type2item.pk::int4
ref.atc.term::text
ref.loinc_staging.short_name::text
ref.loinc_staging.source::text
clin.clin_diag.is_definite::bool
dem.state.country::bpchar
dem.enum_comm_types.description::text
clin.encounter.pk::int4
clin.test_result.fk_type::int4
cfg.cfg_numeric.fk_item::int4
clin.test_result.clin_when::timestamptz
clin.vaccination.pk_item::int4
ref.loinc_staging.inpc_percentage::text
clin.vaccination_definition.row_version::int4
clin.incoming_data_unmatchable.type::text
clin.waiting_list.modified_when::timestamptz
blobs.lnk_doc2hospital_stay.row_version::int4
dem.message_inbox.pk::int4
ref.icpc_chapter.description::text
clin.clin_aux_note.modified_when::timestamptz
clin.vacc_route.modified_by::name
clin.hx_family_item.row_version::int4
ref.tag_image.description::text
clin.allergy.substance_code::text
clin.coded_phrase.modified_by::name
ref.loinc_staging.class_type::text
clin.lnk_vaccine2inds.modified_when::timestamptz
blobs.reviewed_doc_objs.pk::int4
dem.name_gender_map.name::text
dem.lnk_org_unit2ext_id.fk_type::int4
clin.coded_phrase.modified_when::timestamptz
clin.test_type.row_version::int4
clin.operation.pk::int4
clin.active_substance.pk_audit::int4
clin.lnk_substance2episode.pk::int4
clin.vaccine.min_age::interval
clin.incoming_data_unmatched.modified_when::timestamptz
dem.org.pk::int4
ref.paperwork_templates.pk_audit::int4
clin.test_type.pk::int4
ref.loinc.comment::text
cfg.report_query.cmd::text
blobs.reviewed_doc_objs.modified_when::timestamptz
clin.lnk_constraint2vacc_course.pk::int4
clin.clin_root_item.modified_by::name
dem.message_inbox.importance::int2
clin.test_result.val_target_max::numeric
clin.form_instances.fk_form_def::int4
clin.clin_narrative.row_version::int4
clin.lab_request.modified_by::name
clin.test_result.soap_cat::text
blobs.doc_obj.pk::int4
ref.icpc_thesaurus.fk_code::int4
clin.form_data.value::text
clin.procedure.fk_episode::int4
ref.consumable_substance.unit::text
clin.hx_family_item.is_cause_of_death::bool
ref.loinc_staging.dt_last_change::text
dem.enum_comm_types.pk::int4
i18n.translations.pk::int4
clin.test_result.abnormality_indicator::text
cfg.cfg_template.type::text
dem.relation_types.biol_verified::bool
ref.icpc.icd10::_text
clin.allergy.pk_item::int4
clin.vaccine_batches.row_version::int4
clin.incoming_data_unmatched.modified_by::name
clin.form_instances.row_version::int4
clin.test_result.pk_audit::int4
staging.test_result.val_target_range::text
clin.allergy.generics::text
clin.vaccination_definition.max_age_due::interval
clin.clin_narrative.pk_audit::int4
blobs.doc_med.clin_when::timestamptz
clin.test_type.fk_test_org::int4
clin.lnk_constraint2vacc_course.fk_constraint::int4
dem.state.id::int4
clin.procedure.pk_item::int4
ref.lnk_substance2brand.pk::int4
clin.test_type.conversion_unit::text
clin.operation.comment::text
dem.lnk_org_unit2ext_id.comment::text
clin.hx_family_item.fk_relative::int4
clin.vaccination_course.pk_audit::int4
clin.procedure.narrative::text
ref.loinc.final::text
ref.loinc.hl7_field_subfield_id::text
dem.street.lat_lon::point
clin.vaccination_course.comment::text
clin.test_result.val_alpha::text
dem.relation_types.pk_audit::int4
dem.identity.modified_by::name
clin.meta_test_type.name::text
clin.waiting_list.registered::timestamptz
clin.lnk_vaccine2inds.id::int4
clin.health_issue.is_cause_of_death::bool
ref.data_source.version::text
ref.loinc.acs_synonyms::text
blobs.doc_med.comment::text
ref.icpc_component.description::text
clin.reviewed_test_results.row_version::int4
staging.lab_request.fk_test_org::int4
ref.loinc.time_aspect::text
ref.loinc.related_names_1_old::text
clin.hospital_stay.narrative::text
ref.branded_drug.modified_by::name
clin.vaccine.max_age::interval
cfg.cfg_data.fk_item::int4
clin.test_result.fk_intended_reviewer::int4
clin.lab_request.diagnostic_service_section::text
clin.lnk_vaccination_course2schedule.pk_audit::int4
dem.lnk_identity2comm.fk_address::int4
clin.test_result.val_target_min::numeric
dem.enum_ext_id_types.pk::int4
dem.inbox_item_category.modified_by::name
ref.loinc.example_units::text
ref.loinc.code_table::text
clin.lab_request.pk_audit::int4
clin.health_issue.description::text
clin.vaccination.reaction::text
ref.loinc.related_names_2::text
clin.health_issue.laterality::varchar
clin.vaccination_definition.seq_no::int4
blobs.reviewed_doc_objs.fk_reviewed_row::int4
dem.org_unit.fk_org::int4
dem.identity.tob::time
clin.lnk_constraint2vacc_course.modified_by::name
ref.loinc_staging.cdisc_common_tests::text
clin.reviewed_test_results.clinically_relevant::bool
clin.lab_request.request_id::text
clin.test_result.material_detail::text
clin.encounter.last_affirmed::timestamptz
dem.message_inbox.data::text
ref.atc.pk_coding_system::int4
dem.lnk_org_unit2comm.fk_type::int4
clin.incoming_data_unmatchable.other_info::text
dem.lnk_identity2comm.fk_identity::int4
clin.vaccine_batches.batch_no::text
ref.tag_image.filename::text
clin.vacc_indication.atcs_combi_indication::_text
clin.hx_family_item.name_relative::text
staging.test_result.val_normal_range::text
dem.identity.pk::int4
i18n.curr_lang.lang::text
clin.substance_intake.modified_when::timestamptz
ref.icpc.fk_component::int2
clin.clin_hx_family.fk_encounter::int4
clin.substance_intake.schedule::text
clin.coded_phrase.pk::int4
blobs.doc_med.modified_when::timestamptz
ref.paperwork_templates.fk_template_type::int4
dem.inbox_item_type.modified_by::name
dem.relation_types.modified_when::timestamptz
clin.test_type.loinc::text
clin.clin_diag.modified_when::timestamptz
staging.lab_request.modified_by::name
ref.paperwork_templates.instance_type::text
ref.paperwork_templates.row_version::int4
cfg.cfg_template.description::text
clin.lnk_constraint2vacc_course.modified_when::timestamptz
ref.loinc_staging.component::text
clin.incoming_data_unmatched.pk_audit::int4
clin.hospital_stay.fk_episode::int4
staging.test_result.val_target_min::numeric
i18n.curr_lang.pk::int4
clin.clin_root_item.clin_when::timestamptz
clin.clin_diag.is_chronic::bool
clin.test_org.pk_audit::int4
dem.inbox_item_type.fk_inbox_item_category::int4
clin.clin_aux_note.pk::int4
clin.incoming_data_unmatchable.pk_audit::int4
dem.urb.pk_audit::int4
clin.lnk_pat2vaccination_course.pk_audit::int4
staging.test_result.row_version::int4
cfg.cfg_item.pk::int4
dem.org_unit.pk_audit::int4
clin.allergy_state.fk_encounter::int4
dem.names.firstnames::text
clin.encounter.fk_type::int4
staging.lab_request.fk_episode::int4
clin.clin_item_type.code::text
ref.branded_drug.description::text
ref.paperwork_templates.filename::text
dem.name_gender_map.id::int4
staging.lab_request.request_id::text
blobs.doc_obj.data::bytea
clin.test_org.internal_name::text
clin.operation.clin_where::text
dem.identity.gender::text
blobs.doc_obj.seq_idx::int4
dem.identity.fk_marital_status::int4
dem.relation_types.description::text
clin.hx_family_item.modified_by::name
clin.episode.pk::int4
clin.vaccination_course.fk_recommended_by::int4
clin.lnk_pat2vaccination_course.pk::int4
dem.lnk_job2person.activities::text
clin.allergy.modified_by::name
staging.lab_request.pk_audit::int4
clin.vaccination.fk_vaccine::int4
dem.identity_tag.pk::int4
ref.branded_drug.preparation::text
clin.test_result.modified_when::timestamptz
staging.lab_request.lab_rxd_when::timestamptz
dem.gender_label.modified_by::name
clin.allergy_state.pk_audit::int4
clin.incoming_data_unmatchable.fk_patient_candidates::_int4
dem.inbox_item_category.row_version::int4
cfg.db_logon_banner.singularizer::bool
cfg.config.ddb::int4
clin.review_root.is_technically_abnormal::bool
clin.lnk_vaccination_course2schedule.pk::int4
cfg.config.pwd_hash::text
clin.test_result.val_num::numeric
ref.consumable_substance.description::text
blobs.lnk_doc2hospital_stay.pk_audit::int4
blobs.doc_med.row_version::int4
cfg.cfg_numeric.value::numeric
dem.lnk_org_unit2ext_id.row_version::int4
dem.lnk_person2relative.modified_by::name
dem.org.description::text
clin.lnk_substance2episode.modified_when::timestamptz
cfg.report_query.modified_when::timestamptz
ref.loinc.answer_list::text
clin.hospital_stay.fk_encounter::int4
clin.lab_request.fk_episode::int4
dem.country.name::text
clin.vaccination_course.modified_when::timestamptz
dem.lnk_identity2ext_id.id::int4
clin.allergy_state.pk::int4
dem.lnk_identity2primary_doc.fk_identity::int4
ref.data_source.pk_audit::int4
dem.identity.title::text
clin.allergy.allergene::text
dem.staff.modified_by::name
clin.review_root.pk::int4
ref.icpc.fk_data_source::int4
dem.occupation.name::text
clin.lnk_substance2episode.pk_audit::int4
ref.icpc_thesaurus.pk_thesaurus::int4
dem.lnk_identity2ext_id.fk_origin::int4
dem.lnk_person2relative.modified_when::timestamptz
cfg.cfg_template.pk::int4
ref.loinc.change_type::text
clin.test_result.val_normal_max::numeric
clin.vaccine.pk_audit::int4
ref.papersizes.size::point
ref.loinc_staging.is_set_root::text
clin.health_issue.is_confidential::bool
staging.lab_request.diagnostic_service_section::text
clin.hospital_stay.row_version::int4
ref.document_type.description::text
clin.vaccination_definition.fk_course::int4
dem.occupation.pk_audit::int4
clin.reviewed_test_results.modified_by::name
clin.meta_test_type.loinc::text
clin.vacc_route.description::text
clin.clin_aux_note.narrative::text
cfg.cfg_item.fk_template::int4
clin.episode.row_version::int4
clin.vaccine_batches.modified_by::name
clin.active_substance.atc_code::text
clin.encounter.reason_for_encounter::text
clin.lab_request.narrative::text
clin.encounter.modified_when::timestamptz
clin.vaccine.modified_when::timestamptz
dem.lnk_org_unit2ext_id.fk_org_unit::int4
dem.lnk_person_org_address.address_source::text
i18n.curr_lang.db_user::name
clin.keyword_expansion.pk::int4
clin.incoming_data_unmatched.request_id::text
ref.lnk_substance2brand.fk_brand::int4
ref.atc.pk::int4
clin.clin_diag.modified_by::name
clin.reviewed_test_results.is_technically_abnormal::bool
ref.loinc.molar_mass::text
ref.loinc_staging.long_common_name::text
cfg.cfg_type_enum.name::text
staging.lab_request.row_version::int4
ref.icpc.criteria::text
clin.procedure.modified_by::name
ref.icpc.code_extension::text
staging.test_result.clin_when::timestamptz
dem.urb.lat_lon::point
dem.identity.modified_when::timestamptz
clin.waiting_list.pk_audit::int4
clin.form_instances.form_name::text
clin.procedure.clin_where::text
clin.incoming_data_unmatched.type::text
clin.test_org.pk::int4
clin.vaccination_schedule.pk::int4
dem.org.modified_when::timestamptz
ref.paperwork_templates.gnumed_revision::float8
dem.identity.deceased::timestamptz
clin.procedure.modified_when::timestamptz
clin.clin_root_item.fk_encounter::int4
clin.health_issue.is_active::bool
clin.lnk_vaccine2inds.fk_indication::int4
clin.encounter.fk_location::int4
ref.loinc.dt_last_change::text
clin.allergy_state.modified_when::timestamptz
dem.enum_ext_id_types.name::text
cfg.cfg_item.cookie::text
dem.lnk_org_unit2ext_id.external_id::text
clin.incoming_data_unmatched.external_data_id::text
blobs.doc_obj.filename::text
clin.clin_root_item.pk_item::int4
clin.vacc_indication.id::int4
clin.episode.fk_encounter::int4
ref.branded_drug.external_code_type::text
clin.substance_intake.aim::text
staging.lab_request.lab_request_id::text
clin.test_result.fk_episode::int4
clin.encounter.fk_patient::int4
clin.substance_intake.discontinued::timestamptz
ref.icpc_chapter.chapter::bpchar
ref.loinc.grouping_class::text
ref.paperwork_templates.name_long::text
dem.message_inbox.fk_staff::int4
dem.lnk_identity2comm.url::text
cfg.report_query.pk::int4
clin.test_org.modified_by::name
clin.allergy.fk_type::int4
clin.test_result.val_normal_range::text
clin.vaccination_course_constraint.modified_by::name
clin.clin_hx_family.modified_by::name
clin.vaccination.fk_episode::int4
ref.data_source.modified_by::name
dem.lnk_org_unit2comm.row_version::int4
dem.urb.postcode::text
cfg.report_query.row_version::int4
clin.clin_diag.pk::int4
clin.clin_hx_family.narrative::text
dem.address.number::text
clin.episode.description::text
clin.coded_phrase.pk_audit::int4
clin.lnk_tst2norm.row_version::int4
blobs.doc_desc.modified_by::name
dem.lnk_job2person.fk_occupation::int4
clin.vaccination_course.modified_by::name
clin.lnk_vaccination_course2schedule.modified_by::name
dem.lnk_identity2comm.pk::int4
dem.org_unit.row_version::int4
dem.lnk_job2person.pk::int4
ref.data_source.lang::text
dem.identity_tag.modified_when::timestamptz
dem.staff_role.pk_audit::int4
clin.test_result.row_version::int4
clin.lnk_substance2episode.fk_substance::int4
dem.lnk_org_unit2ext_id.pk_audit::int4
ref.branded_drug.is_fake::bool
ref.icpc_component.typical_soap_cat::_text
ref.lnk_substance2brand.modified_when::timestamptz
ref.loinc.pk::int4
clin.lnk_constraint2vacc_course.row_version::int4
dem.names.id_identity::int4
clin.meta_test_type.pk::int4
clin.substance_intake.clin_when::timestamptz
dem.staff.pk::int4
ref.loinc_staging.naa_ccr_id::text
clin.clin_aux_note.soap_cat::text
clin.clin_item_type.row_version::int4
dem.lnk_org_unit2ext_id.modified_when::timestamptz
dem.org_unit.modified_by::name
ref.loinc_staging.panel_elements::text
ref.atc_staging.atc::text
ref.tag_image.modified_by::name
dem.names.id::int4
clin.substance_intake.narrative::text
ref.coding_system_root.pk_coding_system::int4
dem.identity.cob::bpchar
clin.vaccination_course.pk::int4
dem.urb.name::text
clin.lnk_substance2episode.modified_by::name
clin.hospital_stay.pk::int4
staging.test_result.val_normal_max::numeric
clin.lnk_ttype2unified_type.fk_test_type::int4
clin.lnk_pat2vaccination_course.fk_patient::int4
dem.occupation.modified_by::name
ref.loinc_staging.scale_type::text
clin.encounter_type.description::text
clin.episode.is_open::bool
dem.names.lastnames::text
ref.atc.fk_data_source::int4
blobs.reviewed_doc_objs.is_technically_abnormal::bool
ref.loinc.method_type::text
clin.procedure.soap_cat::text
blobs.doc_med.modified_by::name
clin.clin_narrative.pk_item::int4
dem.identity.karyotype::text
staging.lab_request.ordered_service::text
clin.procedure.fk_hospital_stay::int4
clin.coded_phrase.code::text
clin.coded_phrase.term::text
ref.lnk_substance2brand.row_version::int4
clin.clin_narrative.soap_cat::text
clin.reviewed_test_results.fk_reviewed_row::int4
clin.clin_root_item.row_version::int4
clin.keyword_expansion.keyword::text
staging.test_result.val_num::numeric
clin.incoming_data_unmatchable.dob::date
clin.incoming_data_unmatchable.postcode::text
ref.atc_staging.comment::text
dem.message_inbox.comment::text
clin.review_root.pk_audit::int4
clin.vacc_indication.atcs_single_indication::_text
dem.lnk_identity2ext_id.id_identity::int4
ref.consumable_substance.row_version::int4
clin.operation.modified_when::timestamptz
blobs.reviewed_doc_objs.comment::text
ref.loinc_staging.comments::text
dem.lnk_identity2ext_id.comment::text
dem.lnk_identity2comm.is_confidential::bool
clin.keyword_expansion.owner::text
blobs.reviewed_doc_objs.pk_audit::int4
ref.icpc.see_also::_text
dem.lnk_identity2primary_doc.fk_primary_doc::int4
clin.vaccination_course_constraint.pk_audit::int4
clin.test_result.val_normal_min::numeric
dem.lnk_job2person.modified_when::timestamptz
clin.waiting_list.row_version::int4
ref.loinc_staging.property::text
clin.test_type.modified_by::name
dem.identity_tag.pk_audit::int4
clin.test_type.modified_when::timestamptz
ref.icpc_thesaurus.pk::int4
clin.active_substance.pk::int4
ref.paperwork_templates.external_version::text
clin.vaccine_batches.pk::int4
dem.lnk_identity2ext_id.row_version::int4
cfg.config.profile::bpchar
clin.reviewed_test_results.modified_when::timestamptz
clin.test_result.val_unit::text
ref.atc_staging.name::text
clin.procedure.pk_audit::int4
clin.allergy.clin_when::timestamptz
clin.vaccine.comment::text
ref.icpc.exclusions::_text
clin.lnk_ttype2unified_type.pk::int4
clin.clin_item_type.type::text
clin.clin_hx_family.pk_audit::int4
dem.relation_types.biological::bool
ref.tag_image.pk_audit::int4
clin.hx_family_item.age_noted::text
clin.health_issue.row_version::int4
blobs.doc_obj.comment::text
dem.identity.dob::timestamptz
clin.vacc_route.id::int4
clin.clin_aux_note.clin_when::timestamptz
clin.clin_aux_note.pk_audit::int4
ref.loinc.code_status::text
blobs.reviewed_doc_objs.fk_reviewer::int4
ref.branded_drug.modified_when::timestamptz
staging.test_result.val_normal_min::numeric
clin.allergy.modified_when::timestamptz
clin.form_data.row_version::int4
ref.paperwork_templates.modified_by::name
clin.form_instances.modified_by::name
clin.vaccination_definition.min_interval::interval
dem.org_unit.description::text
dem.lnk_job2person.row_version::int4
staging.lab_request.is_pending::bool
ref.loinc.grouping_class_type::int2
dem.lnk_person2relative.pk_audit::int4
cfg.cfg_data.pk::int4
staging.test_result.fk_type::int4
dem.lnk_person_org_address.id_type::int4
clin.vacc_indication.row_version::int4
clin.substance_intake.duration::interval
clin.test_result.fk_request::int4
dem.gender_label.comment::text
ref.data_source.name_long::text
clin.lab_request.ordered_service::text
staging.test_result.pk_audit::int4
clin.lnk_vaccine2inds.row_version::int4
clin.vaccination_definition.comment::text
dem.lnk_org_unit2comm.modified_when::timestamptz
dem.staff.is_active::bool
blobs.lnk_doc2hospital_stay.fk_stay::int4
dem.staff_role.pk::int4
ref.loinc.is_set_root::bool
dem.inbox_item_type.row_version::int4
clin.incoming_data_unmatchable.external_data_id::text
ref.data_source.source::text
clin.vaccination.modified_when::timestamptz
blobs.lnk_doc_med2episode.row_version::int4
clin.test_type.code::text
ref.icpc.short_description::text
dem.address.subunit::text
clin.lnk_pat2vaccination_course.modified_when::timestamptz
ref.document_type.pk::int4
dem.lnk_person2relative.id_relation_type::int4
ref.tag_image.row_version::int4
dem.address.addendum::text
clin.procedure.row_version::int4
dem.identity.pupic::bpchar
clin.substance_intake.pk_item::int4
clin._enum_allergy_type.value::text
clin.waiting_list.list_position::int4
clin.clin_root_item.soap_cat::text
clin.vaccine.fk_brand::int4
clin.vaccination.fk_provider::int4
clin.vacc_indication.modified_by::name
clin.clin_narrative.modified_when::timestamptz
dem.identity_tag.fk_tag::int4
clin.vaccine.modified_by::name
ref.branded_drug.row_version::int4
staging.test_result.modified_when::timestamptz
dem.address.id_street::int4
staging.lab_request.request_status::text
clin.allergy.pk_audit::int4
clin.clin_aux_note.pk_item::int4
ref.branded_drug.external_code::text
ref.tag_image.modified_when::timestamptz
clin.incoming_data_unmatchable.requestor::text
ref.lnk_substance2brand.pk_audit::int4
clin.substance_intake.fk_episode::int4
clin.incoming_data_unmatchable.modified_when::timestamptz
dem.relation_types.id::int4
clin.form_instances.pk_item::int4
ref.loinc_staging.example_units::text
dem.relation_types.modified_by::name
ref.lnk_substance2brand.fk_substance::int4
ref.data_source.modified_when::timestamptz
ref.branded_drug.pk_audit::int4
clin.hx_family_item.fk_narrative_condition::int4
blobs.lnk_doc_med2episode.pk::int4
dem.country.id::int4
ref.loinc.external_copyright_notice::text
ref.atc.unit::text
clin.lnk_type2item.pk_audit::int4
ref.loinc_staging.final::text
clin.lnk_type2item.modified_by::name
clin.form_data.fk_instance::int4
clin.lnk_constraint2vacc_course.fk_vaccination_course::int4
clin.encounter.modified_by::name
ref.lnk_substance2brand.modified_by::name
cfg.cfg_data.value::bytea
dem.marital_status.name::text
ref.loinc_staging.answer_list::text
clin.lnk_ttype2unified_type.fk_test_type_unified::int4
dem.message_inbox.fk_patient::int4
clin.lnk_tst2norm.pk_audit::int4
ref.document_type.scope::text
ref.code_thesaurus_root.fk_code::int4
clin.operation.modified_by::name
clin.hospital_stay.pk_audit::int4
clin.lnk_type2item.fk_type::int4
clin.test_org.fk_med_contact::int4
clin.episode.summary::text
blobs.doc_type.pk::int4
clin.clin_hx_family.pk_item::int4
ref.loinc.exact_component_synonym::text
clin.test_org.row_version::int4
clin.vacc_route.modified_when::timestamptz
ref.loinc.units_required::text
ref.loinc_staging.code_table::text
clin.clin_diag.clinically_relevant::bool
clin.meta_test_type.abbrev::text
clin.meta_test_type.comment::text
ref.tag_image.image::bytea
clin.form_instances.fk_episode::int4
staging.test_result.val_alpha::text
ref.branded_drug.pk::int4
clin.episode.modified_by::name
dem.org_category.pk::int4
staging.test_result.material_detail::text
clin.lab_request.lab_rxd_when::timestamptz
dem.relation_types.row_version::int4
clin.lnk_tst2norm.modified_by::name
clin.lnk_vaccine2inds.modified_by::name
ref.icpc_component.component::int2
dem.gender_label.modified_when::timestamptz
ref.loinc_staging.survey_question_text::text
clin.review_root.row_version::int4
clin.lab_request.lab_request_id::text
dem.state.name::text
clin.vaccination_course_constraint.modified_when::timestamptz
dem.lnk_org_unit2comm.pk_audit::int4
ref.loinc.naa_ccr_id::text
clin.substance_intake.pk::int4
blobs.doc_med.pk::int4
clin.form_instances.narrative::text
clin.waiting_list.pk::int4
dem.gender_label.sort_weight::int4
clin.hx_family_item.pk_audit::int4
ref.consumable_substance.pk_audit::int4
clin.episode.fk_health_issue::int4
clin.health_issue.grouping::text
dem.address.pk_audit::int4
clin.allergy.definite::bool
dem.org_unit.modified_when::timestamptz
dem.identity.fk_emergency_contact::int4
cfg.report_query.pk_audit::int4
dem.message_inbox.pk_audit::int4
clin.hospital_stay.modified_by::name
clin.reviewed_test_results.fk_reviewer::int4
clin.test_result.narrative::text
clin.waiting_list.area::text
blobs.lnk_doc_med2episode.modified_by::name
clin.hospital_stay.modified_when::timestamptz
clin.clin_diag.pk_audit::int4
ref.loinc_staging.survey_question_source::text
dem.identity.fk_primary_provider::int4
clin.procedure.clin_when::timestamptz
clin.vaccination_schedule.pk_audit::int4
dem.gender_label.pk_audit::int4
dem.staff.short_alias::text
clin.review_root.modified_when::timestamptz
cfg.cfg_item.workplace::text
clin.test_org.modified_when::timestamptz
dem.identity_tag.modified_by::name
ref.loinc.order_obs::text
clin.lab_request.request_status::text
clin.test_org.fk_org::int4
clin.clin_root_item.fk_episode::int4
dem.lnk_person2relative.started::date
ref.atc.administration_route::text
clin.lab_request.fk_test_org::int4
dem.identity.pk_audit::int4
clin.lnk_pat2vaccination_course.modified_by::name
clin.test_org.contact::text
dem.gender_label.pk::int4
ref.consumable_substance.modified_by::name
clin.allergy.fk_encounter::int4
clin.incoming_data_unmatchable.fk_identity_disambiguated::int4
clin.operation.fk_health_issue::int4
clin.lab_request.is_pending::bool
ref.icpc.comment::text
blobs.doc_obj.fk_doc::int4
clin.lab_request.modified_when::timestamptz
clin.soap_cat_ranks.rank::int4
ref.paperwork_templates.name_short::text
staging.test_result.pk_item::int4
dem.staff_role.comment::text
ref.loinc.fk_data_source::int4
clin.incoming_data_unmatched.postcode::text
clin.operation.pk_audit::int4
blobs.doc_desc.pk::int4
staging.test_result.note_test_org::text
cfg.cfg_str_array.value::_text
cfg.cfg_string.fk_item::int4
staging.test_result.norm_ref_group::text
ref.consumable_substance.atc_code::text
clin.clin_narrative.fk_episode::int4
ref.atc.ddd::numeric
ref.tag_image.pk::int4
ref.consumable_substance.modified_when::timestamptz
clin.incoming_data_unmatched.lastnames::text
dem.lnk_org_unit2ext_id.modified_by::name
ref.loinc_staging.example_answers::text
clin.form_instances.pk::int4
clin.clin_narrative.pk::int4
clin.soap_cat_ranks.pk::int4
clin.allergy.substance::text
clin.coded_phrase.row_version::int4
dem.lnk_org_unit2ext_id.pk::int4
blobs.lnk_doc_med2episode.fk_doc_med::int4
clin.substance_intake.fk_drug_component::int4
dem.staff.modified_when::timestamptz
dem.org.modified_by::name
ref.atc_staging.unit::text
clin.clin_item_type.pk_audit::int4
blobs.lnk_doc2hospital_stay.modified_when::timestamptz
clin.clin_hx_family.row_version::int4
dem.names.active::bool
dem.org.row_version::int4
clin.clin_root_item.modified_when::timestamptz
clin.lnk_tst2norm.modified_when::timestamptz
clin.vaccine.id_route::int4
clin.allergy.narrative::text
dem.names.preferred::text
ref.paperwork_templates.in_use::bool
clin.hx_family_item.pk::int4
clin.vaccination.narrative::text
ref.atc.code::text
blobs.doc_desc.text::text
ref.loinc.survey_question_source::text
ref.consumable_substance.pk::int4
clin.test_result.modified_by::name
ref.code_thesaurus_root.synonym::text
clin.health_issue.pk::int4
ref.loinc_staging.formula::text
clin.clin_hx_family.fk_hx_family_item::int4
clin.episode.diagnostic_certainty_classification::text
clin.waiting_list.fk_patient::int4
ref.loinc_staging.reference::text
clin.vaccination.clin_when::timestamptz
clin.keyword_expansion.expansion::text
dem.inbox_item_type.description::text
clin.allergy_state.row_version::int4
dem.inbox_item_type.pk::int4
clin.lnk_pat2vaccination_course.fk_course::int4
ref.loinc_staging.normal_range::text
clin.vaccination_course_constraint.description::text
cfg.config.crypt_algo::text
clin.health_issue.age_noted::interval
clin.incoming_data_unmatchable.lastnames::text
clin.vaccination_definition.modified_when::timestamptz
ref.loinc.ipcc_units::text
clin.clin_root_item.pk_audit::int4
ref.coding_system_root.fk_data_source::int4
clin.hospital_stay.discharge::timestamptz
dem.lnk_identity2ext_id.modified_by::name
clin.procedure.pk::int4
ref.loinc.reference::text
ref.loinc.inpc_percentage::text
cfg.report_query.label::text
cfg.cfg_template.cfg_group::text
blobs.doc_desc.row_version::int4
clin.test_org.fk_adm_contact::int4
dem.message_inbox.ufk_context::_int4
ref.loinc.example_answers::text
ref.loinc.formula::text
ref.loinc_staging.method_type::text
ref.papersizes.pk::int4
clin.procedure.is_ongoing::bool
clin.episode.modified_when::timestamptz
dem.identity.emergency_contact::text
dem.lnk_person_org_address.id_org::int4
blobs.lnk_doc_med2episode.fk_episode::int4
clin.allergy_state.comment::text
dem.urb.modified_by::name
staging.test_result.material::text
staging.lab_request.results_reported_when::timestamptz
dem.street.pk_audit::int4
clin.test_org.comment::text
dem.lnk_person_org_address.id_address::int4
clin.vaccination_course.row_version::int4
clin.form_data.fk_form_field::int4
dem.inbox_item_category.modified_when::timestamptz
dem.staff_role.name::text
dem.inbox_item_category.is_user::bool
ref.loinc.property::text
clin.clin_aux_note.row_version::int4
ref.papersizes.name::text
ref.loinc.component::text
blobs.lnk_doc_med2episode.modified_when::timestamptz
clin.lnk_substance2episode.fk_episode::int4
ref.icpc.inclusions::text
dem.lnk_person2relative.row_version::int4
clin.clin_aux_note.modified_by::name
clin.review_root.clinically_relevant::bool
clin.encounter.started::timestamptz
clin.vacc_indication.pk_audit::int4
dem.staff_role.row_version::int4
ref.loinc_staging.molar_mass::text
clin.active_substance.row_version::int4
clin.form_instances.clin_when::timestamptz
dem.gender_label.row_version::int4
ref.loinc_staging.submitted_units::text
dem.inbox_item_category.pk_audit::int4
dem.gender_label.tag::text
clin.vaccine_batches.pk_audit::int4
clin.vaccination_schedule.modified_when::timestamptz
clin.vaccination_schedule.comment::text
dem.gender_label.label::text
clin.health_issue.modified_by::name
clin.substance_intake.fk_encounter::int4
clin.incoming_data_unmatched.gender::text
blobs.lnk_doc2hospital_stay.pk::int4
clin.allergy_state.last_confirmed::timestamptz
clin.allergy.atc_code::text
dem.message_inbox.row_version::int4
clin.vaccination.site::text
ref.loinc.cdisc_common_tests::text
clin.active_substance.modified_when::timestamptz
ref.loinc_staging.external_copyright_notice::text
clin.clin_aux_note.fk_encounter::int4
clin.vaccination_definition.is_booster::bool
clin.review_root.comment::text
clin.health_issue.diagnostic_certainty_classification::text
clin.reviewed_test_results.pk::int4
ref.coding_system_root.term::text
clin.vaccination_course.is_active::bool
clin.incoming_data_unmatchable.data::bytea
dem.country.deprecated::date
clin.vaccine.is_live::bool
ref.loinc.term::text
clin.lnk_type2item.row_version::int4
ref.data_source.description::text
dem.names.comment::text
clin.lab_request.fk_requestor::int4
dem.country.code::bpchar
staging.test_result.soap_cat::text
ref.loinc_staging.related_names_1_old::text
blobs.doc_med.pk_audit::int4
i18n.keys.orig::text
dem.state.modified_by::name
ref.atc.comment::text
clin.incoming_data_unmatched.pk::int4
clin.substance_intake.modified_by::name
clin.test_type.abbrev::text
ref.loinc_staging.scope::text
dem.inbox_item_category.description::text
staging.test_result.val_unit::text
clin.incoming_data_unmatched.firstnames::text
clin.vaccination.pk_audit::int4
ref.loinc.normal_range::text
ref.loinc.scale_type::text
clin.substance_intake.soap_cat::text
ref.atc_staging.adro::text
dem.staff.db_user::name
clin.incoming_data_unmatched.other_info::text
clin.form_data.pk::int4
dem.lnk_org_unit2comm.url::text
dem.urb.id_state::int4
clin.hx_family_item.condition::text
ref.loinc_staging.change_type::text
clin.active_substance.description::text
ref.paperwork_templates.engine::text
blobs.doc_desc.pk_audit::int4
ref.loinc_staging.hl7_field_subfield_id::text
clin.vaccination_course.fk_indication::int4
ref.loinc_staging.species::text
dem.street.id_urb::int4
dem.lnk_job2person.modified_by::name
clin.allergy.soap_cat::text
clin.vaccination.modified_by::name
cfg.report_query.modified_by::name
dem.identity_tag.comment::text
clin.health_issue.modified_when::timestamptz
clin.encounter.source_time_zone::interval
ref.icpc_component.pk::int4
dem.identity.deleted::bool
dem.state.row_version::int4
dem.address.row_version::int4
clin.lnk_type2item.modified_when::timestamptz
clin.procedure.fk_encounter::int4
dem.inbox_item_type.is_user::bool
dem.enum_ext_id_types.issuer::text
clin.keyword_expansion.fk_staff::int4
i18n.translations.orig::text
clin.hx_family_item.modified_when::timestamptz
dem.lnk_identity2ext_id.modified_when::timestamptz
clin.allergy.generic_specific::bool
dem.staff.pk_audit::int4
clin.vacc_route.row_version::int4
clin.lnk_constraint2vacc_course.pk_audit::int4
ref.loinc.pk_coding_system::int4
dem.org.fk_category::int4
clin.form_instances.modified_when::timestamptz
clin.test_result.pk_item::int4
ref.loinc.short_name::text
blobs.doc_med.fk_type::int4
staging.test_result.pk::int4
dem.lnk_person2relative.id_relative::int4
ref.atc_staging.ddd::text
dem.lnk_org_unit2comm.fk_org_unit::int4
staging.lab_request.pk_item::int4
dem.relation_types.inverse::int4
ref.icpc_thesaurus.synonym::text
dem.staff_role.modified_when::timestamptz
clin.incoming_data_unmatchable.modified_by::name
dem.inbox_item_type.modified_when::timestamptz
clin.substance_intake.discontinue_reason::text
clin.episode.pk_audit::int4
clin.incoming_data_unmatchable.request_id::text
ref.icpc.pk_coding_system::int4
dem.lnk_identity2primary_doc.pk::int4
clin.vacc_indication.modified_when::timestamptz
staging.test_result.val_target_max::numeric
blobs.lnk_doc2hospital_stay.modified_by::name
clin.allergy.fk_episode::int4
ref.loinc.system::text
clin.incoming_data_unmatchable.row_version::int4
clin.incoming_data_unmatchable.firstnames::text
dem.message_inbox.modified_by::name
clin.form_instances.soap_cat::text
dem.address.id::int4
dem.occupation.row_version::int4
dem.lnk_person2relative.id_identity::int4
dem.staff.fk_role::int4
clin.health_issue.clinically_relevant::bool
dem.street.modified_by::name
clin.lnk_type2item.fk_item::int4
ref.loinc.submitted_units::text
ref.data_source.pk::int4
ref.data_source.name_short::text
dem.state.modified_when::timestamptz
clin.vaccination_definition.pk_audit::int4
clin.test_type.pk_audit::int4
clin.incoming_data_unmatched.fk_identity_disambiguated::int4
dem.address_type.name::text
clin.clin_aux_note.fk_episode::int4
clin.form_instances.fk_encounter::int4
clin.vaccination_schedule.row_version::int4
cfg.cfg_item.owner::name
clin.test_result.note_test_org::text
dem.lnk_org_unit2comm.pk::int4
clin.vaccination.batch_no::text
clin.clin_diag.row_version::int4
ref.paperwork_templates.modified_when::timestamptz
clin.vaccine.row_version::int4
clin.vaccine.pk::int4
dem.occupation.modified_when::timestamptz
clin.clin_narrative.clin_when::timestamptz
dem.inbox_item_type.pk_audit::int4
dem.lnk_person2relative.ended::date
dem.org_category.description::text
blobs.doc_med.ext_ref::text
staging.lab_request.soap_cat::text
staging.test_result.fk_episode::int4
clin.clin_diag.laterality::bpchar
dem.message_inbox.modified_when::timestamptz
clin.substance_intake.preparation::text
ref.loinc_staging.exact_component_synonym::text
clin.lnk_vaccine2inds.fk_vaccine::int4
clin.vaccination_schedule.name::text
dem.identity.comment::text
blobs.reviewed_doc_objs.modified_by::name
clin.incoming_data_unmatched.data::bytea
clin.allergy_state.has_allergy::int4
dem.lnk_identity2comm.fk_type::int4
clin.vaccination.row_version::int4
cfg.config.username::bpchar
clin.reviewed_test_results.pk_audit::int4
ref.loinc.survey_question_text::text
i18n.translations.lang::text
clin.lnk_tst2norm.id_norm::int4
clin.hx_family_item.dob_relative::timestamptz
clin.lnk_substance2episode.row_version::int4
clin.incoming_data_unmatched.requestor::text
clin.hospital_stay.pk_item::int4
ref.loinc_staging.loinc_num::text
clin.incoming_data_unmatched.row_version::int4
clin.encounter.pk_audit::int4
clin.clin_diag.fk_narrative::int4
clin.lab_request.pk::int4
clin.hospital_stay.soap_cat::text
staging.lab_request.pk::int4
clin.waiting_list.comment::text
dem.staff_role.modified_by::name
dem.lnk_org_unit2comm.modified_by::name
dem.street.modified_when::timestamptz
clin.clin_hx_family.soap_cat::text
cfg.cfg_template.name::text
clin.clin_narrative.narrative::text
dem.lnk_identity2ext_id.external_id::text
ref.loinc.maps_to::text
i18n.translations.trans::text
blobs.doc_desc.fk_doc::int4
staging.test_result.fk_intended_reviewer::int4
clin.review_root.fk_reviewed_row::int4
clin.test_result.norm_ref_group::text
ref.loinc_staging.acs_synonyms::text
ref.icpc.code::text
clin.form_data.modified_when::timestamptz
dem.lnk_person_org_address.id_identity::int4
ref.coding_system_root.code::text
dem.street.row_version::int4
dem.street.id::int4
dem.identity_tag.row_version::int4
dem.urb.modified_when::timestamptz
dem.occupation.id::int4
dem.org_unit.fk_address::int4
clin.vacc_route.pk_audit::int4
clin.form_data.pk_audit::int4
staging.test_result.narrative::text
dem.street.postcode::text
cfg.config.hash_algo::text
cfg.config.id::int4
ref.loinc_staging.ipcc_units::text
clin.coded_phrase.xfk_coding_system::text
ref.loinc.panel_elements::text
ref.loinc.loinc_internal_source::text
ref.icpc.fk_chapter::bpchar
clin.lnk_vaccination_course2schedule.modified_when::timestamptz
ref.paperwork_templates.data::bytea
dem.name_gender_map.gender::bpchar
dem.state.pk_audit::int4
clin.lnk_tst2norm.id::int4
clin.test_result.material::text
blobs.lnk_doc_med2episode.pk_audit::int4
dem.identity_tag.fk_identity::int4
dem.street.suburb::text
clin.health_issue.summary::text
staging.test_result.orig_intended_reviewer::text
clin.vaccination_course_constraint.pk::int4
ref.icpc.term::text
dem.lnk_person_org_address.id::int4
dem.address_type.id::int4
clin.clin_item_type.pk::int4
ref.branded_drug.atc_code::text
ref.code_thesaurus_root.pk_thesaurus::int4
clin.operation.row_version::int4
ref.loinc.long_common_name::text
ref.loinc_staging.map_to::text
clin.waiting_list.modified_by::name
clin.clin_narrative.fk_encounter::int4
ref.loinc_staging.order_obs::text
staging.test_result.fk_request::int4
clin.test_result.fk_encounter::int4
clin.substance_intake.fk_substance::int4
blobs.lnk_doc2hospital_stay.fk_document::int4
clin.test_result.val_target_range::text
dem.staff.row_version::int4
clin.vaccination.fk_encounter::int4
dem.lnk_person2relative.id::int4
clin.incoming_data_unmatchable.pk::int4
clin.health_issue.fk_encounter::int4
clin.test_type.comment::text
clin.lnk_vaccination_course2schedule.fk_schedule::int4
clin.active_substance.modified_by::name
clin.encounter_type.pk::int4
clin.substance_intake.intake_is_approved_of::bool
clin.lab_request.pk_item::int4
clin.hospital_stay.clin_when::timestamptz
clin.lnk_tst2norm.id_test::int4
dem.address.lat_lon::point
clin.review_root.modified_by::name
clin.incoming_data_unmatchable.gender::text
ref.icpc.pk::int4
ref.consumable_substance.amount::numeric
ref.loinc_staging.related_names_2::text
clin.vaccination_definition.modified_by::name
clin.encounter.assessment_of_encounter::text
clin.substance_intake.row_version::int4
clin.allergy_state.modified_by::name
blobs.reviewed_doc_objs.clinically_relevant::bool
clin.encounter.row_version::int4
dem.address.modified_when::timestamptz
clin.vaccination_definition.id::int4
ref.data_source.row_version::int4
clin.vaccine_batches.fk_vaccine::int4
dem.org_unit.pk::int4
clin.lab_request.results_reported_when::timestamptz