Key care-related tables in the v20 database

This listing simply provides an idea of the table layouts (and normalization) in GNUmed.

Table names are supplied in one column, and view names in the other, for the simple reason of compactness.

No horizontal correspondence is intended or expected between side-by-side items.

Demographics schema

Tables Views
address
address_type
country
enum_comm_types
enum_ext_id_types
gender_label
identity
identity_tag
inbox_item_category
inbox_item_type
lnk_identity2comm
lnk_identity2ext_id
lnk_job2person
lnk_org_unit2comm
lnk_org_unit2ext_id
lnk_person2address
lnk_person2relative
lnk_person_org_address
marital_status
message_inbox
name_gender_map
names
occupation
org
org_category
org_unit
praxis_branch
relation_types
staff
state
street
urb
v_address
v_basic_address
v_basic_person
v_external_ids4identity
v_external_ids4org_unit
v_gender_labels
v_identity_tags
v_inbox_item_type
v_message_inbox
v_org_unit_comms
v_org_units
v_org_units_no_praxis_check
v_orgs
v_pat_addresses
v_person_comms
v_person_jobs
v_person_names
v_persons
v_praxis_branches
v_staff
v_state
v_street
v_uniq_zipped_urbs
v_urb
v_zip2data
v_zip2street
v_zip2urb

Clin schema

Tables Views
_enum_allergy_type
allergy
allergy_state
clin_aux_note
clin_diag
clin_item_type
clin_narrative
clin_root_item
encounter
encounter_type
episode
export_item
external_care
family_history
fhx_relation_type
form_data
form_instances
health_issue
hospital_stay
incoming_data_unmatchable
incoming_data_unmatched
lab_request
meta_test_type
patient
procedure
review_root
reviewed_test_results
soap_cat_ranks
substance_intake
suppressed_hint
test_org
test_panel
test_result
test_type
vacc_indication
vacc_route
vaccination
vaccination_course
vaccination_course_constraint
vaccination_definition
vaccination_schedule
vaccine
vaccine_batches
waiting_list
v_brand_intakes
v_emr_journal
v_export_items
v_external_care
v_external_care_journal
v_family_history
v_family_history_journal
v_health_issues
v_health_issues_journal
v_hospital_stays
v_hospital_stays_journal
v_incoming_data_unmatched
v_indications4vaccine
v_linked_codes
v_most_recent_encounters
v_narrative
v_narrative4search
v_nonbrand_intakes
v_pat_allergies
v_pat_allergies_journal
v_pat_allergy_state
v_pat_allergy_state_journal
v_pat_encounters
v_pat_encounters_journal
v_pat_episodes
v_pat_episodes_journal
v_pat_items
v_pat_last_vacc4indication
v_pat_narrative_journal
v_pat_substance_intake_journal
v_pat_vaccinations
v_pat_vaccinations_journal
v_pat_vaccs4indication
v_potential_problem_list
v_problem_list
v_procedures
v_procedures_at_hospital
v_procedures_at_hospital_journal
v_procedures_journal
v_procedures_not_at_hospital
v_procedures_not_at_hospital_journal
v_reviewed_items
v_substance_intakes
v_suppressed_hints
v_suppressed_hints_journal
v_test_orgs
v_test_panels
v_test_results
v_test_results_journal
v_test_types
v_vaccination_courses_in_schedule
v_vaccination_definitions4course
v_vaccines
v_waiting_list

Blobs schema

Tables Views
doc_desc
doc_med
doc_obj
doc_type
lnk_doc2hospital_stay
lnk_doc_med2episode
reviewed_doc_objs
v_doc_desc
v_doc_med
v_doc_med_journal
v_doc_type
v_latest_mugshot
v_obj4doc_no_data
v_reviewed_doc_objects
v_unreviewed_docs
v_unreviewed_docs_inbox
v_unreviewed_docs_summary

Reference schema

Tables Views
atc
atc_staging
auto_hint
billable
branded_drug
coda
code_thesaurus_root
coding_system_root
consumable_substance
data_source
document_type
form_types
icd10
icd9
icpc
icpc_chapter
icpc_component
icpc_thesaurus
keyword_expansion
lnk_substance2brand
loinc
ops
other_code
papersizes
paperwork_templates
tag_image
v_atc
v_auto_hints
v_billables
v_branded_drugs
v_coded_terms
v_drug_components
v_generic_codes
v_icpc
v_icpc_thesaurus
v_keyword_expansions
v_paperwork_templates
v_tag_images_no_data
v_your_keyword_expansions
Topic revision: 22 Jan 2015, JamesBusser
 
Download.png
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding Foswiki? Send feedback
Powered by Olark