OpenMRS 3.4.0 Data Model
 
Search by table name, column name, or datatype. By default, the search will be for table name. Add a period (or start with a period) to search by column name. Add a colon (or start with a colon) to search by datatype. Basic regular expressions are supported. Want to run this locally? Just save this file locally and open it with your browser; no internet required. Adding "#query" to the end of the URL will automatically perform that search when the page is loaded, so you can share links to specific searches.
ExampleSearch for...
foobartable names containing "foobar"
.foobarcolumn names containing "foobar"
:intcolumns with datatype containing "int"
:concept.concept_idcolumns that are a foreign key to concept.concept_id
foobar.bazcolumn names containing "baz" within tables with names containing "foobar"
^foo$table with exact name "foo"
.^bar$columns with exact name "bar"
:^int$columns with exact datatype "int"
^foo.*bar$tables with names starting with "foo" and ending with "bar"
foo.*bar.^baz:varcharcolumn names starting with "baz" and datatype containing "varchar" within tables containing "foo" followed by "bar"
hotkeys: "/" jumps to search box, "?" toggle help. Click on help to dismiss.
address_hierarchy_address_to_entry_map
address_to_entry_map_id
integer (10)
address_id
person_address.person_address_id
entry_id
address_hierarchy_entry.address_hierarchy_entry_id
uuid
char (38)
address_hierarchy_entry
address_hierarchy_entry_id
integer (10)
name
varchar (160)
level_id
address_hierarchy_level.address_hierarchy_level_id
parent_id
address_hierarchy_entry.address_hierarchy_entry_id
user_generated_id
varchar (11)
latitude
double (22)
longitude
double (22)
elevation
double (22)
uuid
char (38)
address_hierarchy_level
address_hierarchy_level_id
integer (10)
name
varchar (160)
parent_level_id
address_hierarchy_level.address_hierarchy_level_id
address_field
varchar (50)
uuid
char (38)
required
bit (1)
allergy
allergy_id
integer (10)
patient_id
patient.patient_id
severity_concept_id
concept.concept_id
coded_allergen
concept.concept_id
non_coded_allergen
varchar (255)
allergen_type
varchar (50)
comments
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
form_namespace_and_path
varchar (255)
encounter_id
encounter.encounter_id
allergy_reaction
allergy_reaction_id
integer (10)
allergy_id
allergy.allergy_id
reaction_concept_id
concept.concept_id
reaction_non_coded
varchar (255)
uuid
char (38)
appointment_service
appointment_service_id
integer (10)
name
varchar (50)
description
long varchar (65535)
start_time
time (8)
end_time
time (8)
location_id
location.location_id
speciality_id
appointment_speciality.speciality_id
max_appointments_limit
integer (10)
duration_mins
integer (10)
color
varchar (8)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (38)
initial_appointment_status
varchar (45)
appointment_service_type
appointment_service_type_id
integer (10)
appointment_service_id
appointment_service.appointment_service_id
name
varchar (50)
duration_mins
integer (10)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (38)
appointment_service_weekly_availability
service_weekly_availability_id
integer (10)
service_id
appointment_service.appointment_service_id
day_of_week
varchar (45)
start_time
time (8)
end_time
time (8)
max_appointments_limit
integer (10)
uuid
varchar (38)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
date_created
timestamp (19)
creator
users.user_id
date_changed
timestamp (19)
changed_by
integer (10)
appointment_speciality
speciality_id
integer (10)
name
varchar (50)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
uuid
varchar (38)
voided
bit (1)
bed
bed_id
integer (10)
bed_number
varchar (50)
status
varchar (255)
bed_type_id
bed_type.bed_type_id
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
bed_location_map
bed_location_map_id
integer (10)
location_id
location.location_id
bed_row_number
integer (10)
bed_column_number
integer (10)
bed_id
bed.bed_id
bed_patient_assignment_map
bed_patient_assignment_map_id
integer (10)
patient_id
patient.patient_id
bed_id
bed.bed_id
date_started
timestamp (19)
date_stopped
timestamp (19)
encounter_id
encounter.encounter_id
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
bed_tag
bed_tag_id
integer (10)
name
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
bed_tag_map
bed_tag_map_id
integer (10)
bed_id
bed.bed_id
bed_tag_id
bed_tag.bed_tag_id
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
bed_type
bed_type_id
integer (10)
name
varchar (255)
display_name
varchar (10)
description
varchar (255)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retire_reason
varchar (255)
retired_by
users.user_id
date_retired
timestamp (19)
calculation_registration
calculation_registration_id
integer (10)
token
varchar (255)
provider_class_name
varchar (512)
calculation_name
varchar (512)
configuration
long varchar (65535)
uuid
char (38)
care_setting
care_setting_id
integer (10)
name
varchar (255)
description
varchar (255)
care_setting_type
varchar (50)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
clob_datatype_storage
id
integer (10)
uuid
char (38)
value
long varchar (2147483647)
cohort
cohort_id
integer (10)
name
varchar (255)
description
varchar (1000)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
location_id
location.location_id
startDate
timestamp (19)
endDate
timestamp (19)
is_group_cohort
bit (1)
cohort_type_id
cohort_type.cohort_type_id
definition_handler
varchar (255)
definition_handler_config
long varchar (2147483647)
cohort_attribute
cohort_attribute_id
integer (10)
cohort_id
cohort.cohort_id
value_reference
varchar (255)
attribute_type_id
cohort_attribute_type.cohort_attribute_type_id
date_created
timestamp (19)
creator
users.user_id
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (255)
cohort_attribute_type
cohort_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (255)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
max_occurs
integer (10)
min_occurs
integer (10)
date_created
timestamp (19)
creator
users.user_id
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (255)
cohort_member
cohort_id
cohort.cohort_id
patient_id
patient.patient_id
cohort_member_id
integer (10)
start_date
timestamp (19)
end_date
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
date_changed
date (10)
changed_by
users.user_id
cohort_member_attribute
cohort_member_attribute_id
integer (10)
cohort_member_id
cohort_member.cohort_member_id
value_reference
long varchar (65535)
cohort_member_attribute_type_id
cohort_member_attribute_type.cohort_member_attribute_type_id
date_created
timestamp (19)
creator
users.user_id
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
cohort_member_attribute_type
cohort_member_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (255)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
max_occurs
integer (10)
min_occurs
integer (10)
date_created
timestamp (19)
creator
users.user_id
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
cohort_type
cohort_type_id
integer (10)
name
varchar (255)
description
varchar (255)
date_created
timestamp (19)
creator
users.user_id
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (255)
concept
concept_id
integer (10)
retired
bit (1)
short_name
varchar (255)
description
long varchar (65535)
form_text
long varchar (65535)
datatype_id
concept_datatype.concept_datatype_id
class_id
concept_class.concept_class_id
is_set
bit (1)
creator
users.user_id
date_created
timestamp (19)
version
varchar (50)
changed_by
users.user_id
date_changed
timestamp (19)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
concept_answer
concept_answer_id
integer (10)
concept_id
concept.concept_id
answer_concept
concept.concept_id
answer_drug
drug.drug_id
creator
users.user_id
date_created
timestamp (19)
sort_weight
double (22)
uuid
char (38)
concept_attribute
concept_attribute_id
integer (10)
concept_id
concept.concept_id
attribute_type_id
concept_attribute_type.concept_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
concept_attribute_type
concept_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
concept_class
concept_class_id
integer (10)
name
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
date_changed
timestamp (19)
changed_by
users.user_id
concept_complex
concept_id
concept.concept_id
handler
varchar (255)
concept_datatype
concept_datatype_id
integer (10)
name
varchar (255)
hl7_abbreviation
varchar (3)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
concept_description
concept_description_id
integer (10)
concept_id
concept.concept_id
description
long varchar (65535)
locale
varchar (50)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
concept_map_type
concept_map_type_id
integer (10)
name
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
is_hidden
bit (1)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
concept_name
concept_name_id
integer (10)
concept_id
concept.concept_id
name
varchar (255)
locale
varchar (50)
locale_preferred
bit (1)
creator
users.user_id
date_created
timestamp (19)
concept_name_type
varchar (50)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
date_changed
timestamp (19)
changed_by
users.user_id
concept_name_tag
concept_name_tag_id
integer (10)
tag
varchar (50)
description
long varchar (65535)
creator
integer (10)
date_created
timestamp (19)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
date_changed
timestamp (19)
changed_by
users.user_id
concept_name_tag_map
concept_name_id
concept_name.concept_name_id
concept_name_tag_id
concept_name_tag.concept_name_tag_id
concept_numeric
concept_id
concept.concept_id
hi_absolute
double (22)
hi_critical
double (22)
hi_normal
double (22)
low_absolute
double (22)
low_critical
double (22)
low_normal
double (22)
units
varchar (50)
allow_decimal
bit (1)
display_precision
integer (10)
concept_proposal
concept_proposal_id
integer (10)
concept_id
concept.concept_id
encounter_id
encounter.encounter_id
original_text
varchar (255)
final_text
varchar (255)
obs_id
obs.obs_id
obs_concept_id
concept.concept_id
state
varchar (32)
comments
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
locale
varchar (50)
uuid
char (38)
concept_proposal_tag_map
concept_proposal_id
concept_proposal.concept_proposal_id
concept_name_tag_id
concept_name_tag.concept_name_tag_id
concept_reference_map
concept_map_id
integer (10)
concept_reference_term_id
concept_reference_term.concept_reference_term_id
concept_map_type_id
concept_map_type.concept_map_type_id
creator
users.user_id
date_created
timestamp (19)
concept_id
concept.concept_id
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
concept_reference_range
concept_reference_range_id
integer (10)
concept_id
concept_numeric.concept_id
criteria
varchar (255)
hi_absolute
double (22)
hi_critical
double (22)
hi_normal
double (22)
low_absolute
double (22)
low_critical
double (22)
low_normal
double (22)
uuid
char (38)
concept_reference_source
concept_source_id
integer (10)
name
varchar (50)
description
long varchar (65535)
hl7_code
varchar (50)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
unique_id
varchar (250)
date_changed
timestamp (19)
changed_by
users.user_id
concept_reference_term
concept_reference_term_id
integer (10)
concept_source_id
concept_reference_source.concept_source_id
name
varchar (255)
code
varchar (255)
version
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
date_changed
timestamp (19)
changed_by
users.user_id
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
concept_reference_term_map
concept_reference_term_map_id
integer (10)
term_a_id
concept_reference_term.concept_reference_term_id
term_b_id
concept_reference_term.concept_reference_term_id
a_is_to_b_id
concept_map_type.concept_map_type_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
concept_set
concept_set_id
integer (10)
concept_id
integer (10)
concept_set
concept.concept_id
sort_weight
double (22)
creator
users.user_id
date_created
timestamp (19)
uuid
char (38)
concept_state_conversion
concept_state_conversion_id
integer (10)
concept_id
concept.concept_id
program_workflow_id
program_workflow.program_workflow_id
program_workflow_state_id
program_workflow_state.program_workflow_state_id
uuid
char (38)
concept_stop_word
concept_stop_word_id
integer (10)
word
varchar (50)
locale
varchar (50)
uuid
char (38)
conditions
condition_id
integer (10)
additional_detail
varchar (255)
previous_version
conditions.condition_id
condition_coded
concept.concept_id
condition_non_coded
varchar (255)
condition_coded_name
concept_name.concept_name_id
clinical_status
varchar (50)
verification_status
varchar (50)
onset_date
timestamp (19)
date_created
timestamp (19)
voided
bit (1)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (38)
creator
users.user_id
voided_by
users.user_id
changed_by
users.user_id
patient_id
patient.patient_id
end_date
timestamp (19)
date_changed
timestamp (19)
encounter_id
encounter.encounter_id
form_namespace_and_path
varchar (255)
diagnosis_attribute
diagnosis_attribute_id
integer (10)
diagnosis_id
encounter_diagnosis.diagnosis_id
attribute_type_id
diagnosis_attribute_type.diagnosis_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
diagnosis_attribute_type
diagnosis_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
drug
drug_id
integer (10)
concept_id
concept.concept_id
name
varchar (255)
combination
bit (1)
dosage_form
concept.concept_id
maximum_daily_dose
double (22)
minimum_daily_dose
double (22)
route
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
changed_by
users.user_id
date_changed
timestamp (19)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
strength
varchar (255)
dose_limit_units
concept.concept_id
drug_ingredient
drug_id
drug.drug_id
ingredient_id
concept.concept_id
uuid
char (38)
strength
double (22)
units
concept.concept_id
drug_order
order_id
orders.order_id
drug_inventory_id
drug.drug_id
dose
double (22)
as_needed
bit (1)
dosing_type
varchar (255)
quantity
double (22)
as_needed_condition
varchar (255)
num_refills
integer (10)
dosing_instructions
long varchar (65535)
duration
integer (10)
duration_units
concept.concept_id
quantity_units
concept.concept_id
route
concept.concept_id
dose_units
concept.concept_id
frequency
order_frequency.order_frequency_id
brand_name
varchar (255)
dispense_as_written
bit (1)
drug_non_coded
varchar (255)
drug_reference_map
drug_reference_map_id
integer (10)
drug_id
drug.drug_id
term_id
concept_reference_term.concept_reference_term_id
concept_map_type
concept_map_type.concept_map_type_id
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
encounter
encounter_id
integer (10)
encounter_type
encounter_type.encounter_type_id
patient_id
patient.patient_id
location_id
location.location_id
form_id
form.form_id
encounter_datetime
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
visit_id
visit.visit_id
uuid
char (38)
encounter_diagnosis
diagnosis_id
integer (10)
diagnosis_coded
concept.concept_id
diagnosis_non_coded
varchar (255)
diagnosis_coded_name
concept_name.concept_name_id
encounter_id
encounter.encounter_id
patient_id
patient.patient_id
condition_id
conditions.condition_id
certainty
varchar (255)
dx_rank
integer (10)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
form_namespace_and_path
varchar (255)
encounter_provider
encounter_provider_id
integer (10)
encounter_id
encounter.encounter_id
provider_id
provider.provider_id
encounter_role_id
encounter_role.encounter_role_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
date_voided
timestamp (19)
voided_by
users.user_id
void_reason
varchar (255)
uuid
char (38)
encounter_role
encounter_role_id
integer (10)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
encounter_type
encounter_type_id
integer (10)
name
varchar (50)
description
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
edit_privilege
privilege.privilege
view_privilege
privilege.privilege
changed_by
users.user_id
date_changed
timestamp (19)
fhir_concept_source
fhir_concept_source_id
integer (10)
concept_source_id
concept_reference_source.concept_source_id
url
varchar (255)
name
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
fhir_contact_point_map
fhir_contact_point_map_id
integer (10)
attribute_type_domain
varchar (100)
attribute_type_id
integer (10)
rank
integer (10)
system
varchar (50)
use
varchar (50)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
date_voided
timestamp (19)
voided_by
users.user_id
void_reason
varchar (255)
uuid
varchar (38)
fhir_diagnostic_report
diagnostic_report_id
integer (10)
status
varchar (50)
concept_id
concept.concept_id
subject_id
patient.patient_id
encounter_id
encounter.encounter_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
issued
timestamp (19)
fhir_diagnostic_report_performers
diagnostic_report_id
fhir_diagnostic_report.diagnostic_report_id
provider_id
provider.provider_id
fhir_diagnostic_report_results
diagnostic_report_id
fhir_diagnostic_report.diagnostic_report_id
obs_id
obs.obs_id
fhir_encounter_class_map
encounter_class_map_id
integer (10)
location_id
location.location_id
encounter_class
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retired_reason
varchar (255)
uuid
char (36)
fhir_observation_category_map
observation_category_map_id
integer (10)
concept_class_id
concept_class.concept_class_id
observation_category
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retired_reason
varchar (255)
uuid
char (36)
fhir_patient_identifier_system
fhir_patient_identifier_system_id
integer (10)
patient_identifier_type_id
patient_identifier_type.patient_identifier_type_id
url
varchar (255)
name
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
fhir_reference
reference_id
integer (10)
target_type
varchar (255)
reference
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
name
varchar (255)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
target_uuid
char (38)
fhir_task
task_id
integer (10)
status
varchar (255)
status_reason
varchar (255)
description
varchar (255)
uuid
char (38)
intent
varchar (255)
owner_reference_id
fhir_reference.reference_id
encounter_reference_id
fhir_reference.reference_id
for_reference_id
fhir_reference.reference_id
based_on
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
name
varchar (255)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
location_reference_id
fhir_reference.reference_id
execution_start_time
timestamp (19)
execution_end_time
timestamp (19)
task_code
concept.concept_id
comment
varchar (255)
fhir_task_based_on_reference
task_id
fhir_task.task_id
reference_id
fhir_reference.reference_id
fhir_task_input
task_input_id
integer (10)
task_id
fhir_task.task_id
type_id
concept.concept_id
value_datetime
timestamp (19)
value_numeric
double (22)
value_text
varchar (255)
value_reference_id
fhir_reference.reference_id
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
name
varchar (255)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
fhir_task_output
task_output_id
integer (10)
task_id
fhir_task.task_id
type_id
concept.concept_id
value_datetime
timestamp (19)
value_numeric
double (22)
value_text
varchar (255)
value_reference_id
fhir_reference.reference_id
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
name
varchar (255)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
fhir_task_part_of_reference
task_id
fhir_task.task_id
reference_id
fhir_reference.reference_id
field
field_id
integer (10)
name
varchar (255)
description
long varchar (65535)
field_type
field_type.field_type_id
concept_id
concept.concept_id
table_name
varchar (50)
attribute_name
varchar (50)
default_value
long varchar (65535)
select_multiple
bit (1)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
field_answer
field_id
field.field_id
answer_id
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
uuid
char (38)
field_type
field_type_id
integer (10)
name
varchar (50)
description
long varchar (65535)
is_set
bit (1)
creator
users.user_id
date_created
timestamp (19)
uuid
char (38)
form
form_id
integer (10)
name
varchar (255)
version
varchar (50)
build
integer (10)
published
bit (1)
xslt
long varchar (65535)
template
long varchar (65535)
description
long varchar (65535)
encounter_type
encounter_type.encounter_type_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retired_reason
varchar (255)
uuid
char (38)
form_field
form_field_id
integer (10)
form_id
form.form_id
field_id
field.field_id
field_number
integer (10)
field_part
varchar (5)
page_number
integer (10)
parent_form_field
form_field.form_field_id
min_occurs
integer (10)
max_occurs
integer (10)
required
bit (1)
changed_by
users.user_id
date_changed
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
sort_weight
real (12)
uuid
char (38)
form_resource
form_resource_id
integer (10)
form_id
form.form_id
name
varchar (255)
value_reference
long varchar (65535)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
uuid
char (38)
date_changed
timestamp (19)
changed_by
users.user_id
global_property
property
varchar (255)
property_value
long varchar (65535)
description
long varchar (65535)
uuid
char (38)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_changed
timestamp (19)
changed_by
users.user_id
view_privilege
privilege.privilege
edit_privilege
privilege.privilege
delete_privilege
privilege.privilege
hl7_in_archive
hl7_in_archive_id
integer (10)
hl7_source
integer (10)
hl7_source_key
varchar (255)
hl7_data
long varchar (65535)
date_created
timestamp (19)
message_state
integer (10)
uuid
char (38)
hl7_in_error
hl7_in_error_id
integer (10)
hl7_source
integer (10)
hl7_source_key
long varchar (65535)
hl7_data
long varchar (65535)
error
varchar (255)
error_details
long varchar (16777215)
date_created
timestamp (19)
uuid
char (38)
hl7_in_queue
hl7_in_queue_id
integer (10)
hl7_source
hl7_source.hl7_source_id
hl7_source_key
long varchar (65535)
hl7_data
long varchar (65535)
message_state
integer (10)
date_processed
timestamp (19)
error_msg
long varchar (65535)
date_created
timestamp (19)
uuid
char (38)
hl7_source
hl7_source_id
integer (10)
name
varchar (255)
description
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
uuid
char (38)
idgen_auto_generation_option
id
integer (10)
identifier_type
patient_identifier_type.patient_identifier_type_id
source
idgen_identifier_source.id
manual_entry_enabled
bit (1)
automatic_generation_enabled
bit (1)
location
location.location_id
uuid
char (36)
idgen_id_pool
id
idgen_identifier_source.id
source
idgen_identifier_source.id
batch_size
integer (10)
min_pool_size
integer (10)
sequential
bit (1)
refill_with_scheduled_task
bit (1)
idgen_identifier_source
id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (1000)
identifier_type
patient_identifier_type.patient_identifier_type_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
idgen_log_entry
id
integer (10)
source
idgen_identifier_source.id
identifier
varchar (50)
date_generated
timestamp (19)
generated_by
users.user_id
comment
varchar (255)
idgen_pooled_identifier
id
integer (10)
uuid
char (38)
pool_id
idgen_id_pool.id
identifier
varchar (50)
date_used
timestamp (19)
comment
varchar (255)
idgen_remote_source
id
idgen_identifier_source.id
url
varchar (255)
user
varchar (50)
password
varchar (20)
idgen_reserved_identifier
id
integer (10)
source
idgen_identifier_source.id
identifier
varchar (50)
idgen_seq_id_gen
id
idgen_identifier_source.id
next_sequence_value
integer (10)
base_character_set
varchar (255)
first_identifier_base
varchar (50)
prefix
varchar (100)
suffix
varchar (100)
min_length
integer (10)
max_length
integer (10)
liquibasechangelog
ID
varchar (255)
AUTHOR
varchar (255)
FILENAME
varchar (255)
DATEEXECUTED
timestamp (19)
ORDEREXECUTED
integer (10)
EXECTYPE
varchar (10)
MD5SUM
varchar (35)
DESCRIPTION
varchar (255)
COMMENTS
varchar (255)
TAG
varchar (255)
LIQUIBASE
varchar (20)
CONTEXTS
varchar (255)
LABELS
varchar (255)
DEPLOYMENT_ID
varchar (10)
liquibasechangeloglock
ID
integer (10)
LOCKED
bit (1)
LOCKGRANTED
timestamp (19)
LOCKEDBY
varchar (255)
location
location_id
integer (10)
name
varchar (255)
description
varchar (255)
address1
varchar (255)
address2
varchar (255)
city_village
varchar (255)
state_province
varchar (255)
postal_code
varchar (50)
country
varchar (50)
latitude
varchar (50)
longitude
varchar (50)
creator
users.user_id
date_created
timestamp (19)
county_district
varchar (255)
address3
varchar (255)
address4
varchar (255)
address5
varchar (255)
address6
varchar (255)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
parent_location
location.location_id
uuid
char (38)
changed_by
users.user_id
date_changed
timestamp (19)
address7
varchar (255)
address8
varchar (255)
address9
varchar (255)
address10
varchar (255)
address11
varchar (255)
address12
varchar (255)
address13
varchar (255)
address14
varchar (255)
address15
varchar (255)
location_type_concept_id
concept.concept_id
location_attribute
location_attribute_id
integer (10)
location_id
location.location_id
attribute_type_id
location_attribute_type.location_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
location_attribute_type
location_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
location_tag
location_tag_id
integer (10)
name
varchar (50)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
changed_by
users.user_id
date_changed
timestamp (19)
location_tag_map
location_id
location.location_id
location_tag_id
location_tag.location_tag_id
medication_dispense
medication_dispense_id
integer (10)
uuid
char (38)
patient_id
patient.patient_id
encounter_id
encounter.encounter_id
concept
concept.concept_id
drug_id
drug.drug_id
location_id
location.location_id
dispenser
provider.provider_id
drug_order_id
drug_order.order_id
status
concept.concept_id
status_reason
concept.concept_id
type
concept.concept_id
quantity
double (22)
quantity_units
concept.concept_id
dose
double (22)
dose_units
concept.concept_id
route
concept.concept_id
frequency
order_frequency.order_frequency_id
as_needed
bit (1)
dosing_instructions
long varchar (65535)
date_prepared
timestamp (19)
date_handed_over
timestamp (19)
was_substituted
bit (1)
substitution_type
concept.concept_id
substitution_reason
concept.concept_id
form_namespace_and_path
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
metadatamapping_metadata_set
metadata_set_id
integer (10)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (255)
uuid
char (38)
metadatamapping_metadata_set_member
metadata_set_member_id
integer (10)
metadata_set_id
metadatamapping_metadata_set.metadata_set_id
metadata_class
varchar (1024)
metadata_uuid
varchar (38)
sort_weight
double (22)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (255)
uuid
char (38)
metadatamapping_metadata_source
metadata_source_id
integer (10)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
changed_by
users.user_id
date_created
timestamp (19)
date_changed
timestamp (19)
retired
bit (1)
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (255)
uuid
char (38)
metadatamapping_metadata_term_mapping
metadata_term_mapping_id
integer (10)
metadata_source_id
metadatamapping_metadata_source.metadata_source_id
code
varchar (255)
metadata_class
varchar (1024)
metadata_uuid
varchar (38)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (255)
uuid
char (38)
note
note_id
integer (10)
note_type
varchar (50)
patient_id
patient.patient_id
obs_id
obs.obs_id
encounter_id
encounter.encounter_id
text
long varchar (65535)
priority
integer (10)
parent
note.note_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
notification_alert
alert_id
integer (10)
text
varchar (512)
satisfied_by_any
bit (1)
alert_read
bit (1)
date_to_expire
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
notification_alert_recipient
alert_id
notification_alert.alert_id
user_id
users.user_id
alert_read
bit (1)
date_changed
timestamp (19)
uuid
char (38)
notification_template
template_id
integer (10)
name
varchar (50)
template
long varchar (65535)
subject
varchar (100)
sender
varchar (255)
recipients
varchar (512)
ordinal
integer (10)
uuid
char (38)
obs
obs_id
integer (10)
person_id
person.person_id
concept_id
concept.concept_id
encounter_id
encounter.encounter_id
order_id
orders.order_id
obs_datetime
timestamp (19)
location_id
location.location_id
obs_group_id
obs.obs_id
accession_number
varchar (255)
value_group_id
integer (10)
value_coded
concept.concept_id
value_coded_name_id
concept_name.concept_name_id
value_drug
drug.drug_id
value_datetime
timestamp (19)
value_numeric
double (22)
value_modifier
varchar (2)
value_text
long varchar (65535)
value_complex
varchar (1000)
comments
varchar (255)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
previous_version
obs.obs_id
form_namespace_and_path
varchar (255)
status
varchar (16)
interpretation
varchar (32)
obs_reference_range
obs_reference_range_id
integer (10)
obs_id
obs.obs_id
hi_absolute
double (22)
hi_critical
double (22)
hi_normal
double (22)
low_absolute
double (22)
low_critical
double (22)
low_normal
double (22)
uuid
char (38)
openconceptlab_import
import_id
bigint (19)
uuid
char (38)
local_date_started
timestamp (19)
local_date_stopped
timestamp (19)
ocl_date_started
timestamp (19)
error_message
varchar (1024)
release_version
varchar (512)
subscription_url
long varchar (65535)
openconceptlab_item
item_id
bigint (19)
import_id
openconceptlab_import.import_id
type
varchar (512)
uuid
char (38)
version_url
varchar (1024)
url
varchar (1024)
hashed_url
binary (16)
state
integer (10)
error_message
varchar (1024)
updated_on
timestamp (19)
order_attribute
order_attribute_id
integer (10)
order_id
orders.order_id
attribute_type_id
order_attribute_type.order_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
order_attribute_type
order_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
order_frequency
order_frequency_id
integer (10)
concept_id
concept.concept_id
frequency_per_day
double (22)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
order_group
order_group_id
integer (10)
order_set_id
order_set.order_set_id
patient_id
patient.patient_id
encounter_id
encounter.encounter_id
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
order_group_reason
concept.concept_id
parent_order_group
order_group.order_group_id
previous_order_group
order_group.order_group_id
order_group_attribute
order_group_attribute_id
integer (10)
order_group_id
order_group.order_group_id
attribute_type_id
order_group_attribute_type.order_group_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
order_group_attribute_type
order_group_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
order_set
order_set_id
integer (10)
operator
varchar (50)
name
varchar (255)
description
varchar (1000)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
category
concept.concept_id
order_set_attribute
order_set_attribute_id
integer (10)
order_set_id
order_set.order_set_id
attribute_type_id
order_set_attribute_type.order_set_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
order_set_attribute_type
order_set_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
order_set_member
order_set_member_id
integer (10)
order_type
order_type.order_type_id
order_template
long varchar (65535)
order_template_type
varchar (1024)
order_set_id
order_set.order_set_id
sequence_number
integer (10)
concept_id
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
order_template
order_template_id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (255)
concept
concept.concept_id
drug
drug.drug_id
template
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
order_type
order_type_id
integer (10)
name
varchar (255)
description
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
java_class_name
varchar (255)
parent
order_type.order_type_id
changed_by
users.user_id
date_changed
timestamp (19)
order_type_class_map
order_type_id
order_type.order_type_id
concept_class_id
concept_class.concept_class_id
orders
order_id
integer (10)
order_type_id
order_type.order_type_id
concept_id
integer (10)
orderer
provider.provider_id
encounter_id
encounter.encounter_id
instructions
long varchar (65535)
date_activated
timestamp (19)
auto_expire_date
timestamp (19)
date_stopped
timestamp (19)
order_reason
concept.concept_id
order_reason_non_coded
varchar (255)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
patient_id
patient.patient_id
accession_number
varchar (255)
uuid
char (38)
urgency
varchar (50)
order_number
varchar (50)
previous_order_id
orders.order_id
order_action
varchar (50)
comment_to_fulfiller
varchar (1024)
care_setting
care_setting.care_setting_id
scheduled_date
timestamp (19)
order_group_id
order_group.order_group_id
sort_weight
double (22)
fulfiller_comment
varchar (1024)
fulfiller_status
varchar (50)
form_namespace_and_path
varchar (255)
patient
patient_id
person.person_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
allergy_status
varchar (50)
patient_appointment
patient_appointment_id
integer (10)
provider_id
provider.provider_id
appointment_number
varchar (50)
patient_id
patient.patient_id
start_date_time
timestamp (19)
end_date_time
timestamp (19)
appointment_service_id
appointment_service.appointment_service_id
appointment_service_type_id
appointment_service_type.appointment_service_type_id
status
varchar (45)
location_id
location.location_id
appointment_kind
varchar (45)
comments
varchar (255)
uuid
varchar (38)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
related_appointment_id
patient_appointment.patient_appointment_id
tele_health_video_link
varchar (255)
priority
varchar (45)
date_appointment_scheduled
timestamp (19)
patient_appointment_audit
patient_appointment_audit_id
integer (10)
appointment_id
patient_appointment.patient_appointment_id
uuid
varchar (38)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
status
varchar (45)
notes
varchar (1000)
patient_appointment_fulfilling_encounter_map
patient_appointment_id
patient_appointment.patient_appointment_id
fulfilling_encounter_id
encounter.encounter_id
patient_appointment_occurrence
patient_appointment_timings_id
patient_appointment_recurring_time.patient_appointment_timings_id
patient_appointment_id
patient_appointment.patient_appointment_id
patient_appointment_provider
patient_appointment_provider_id
integer (10)
patient_appointment_id
patient_appointment.patient_appointment_id
provider_id
provider.provider_id
response
varchar (32)
comments
varchar (1000)
date_created
timestamp (19)
creator
integer (10)
date_changed
timestamp (19)
changed_by
integer (10)
voided
bit (1)
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
varchar (38)
patient_appointment_recurring_time
patient_appointment_timings_id
integer (10)
recurrence_type
varchar (20)
period
integer (10)
frequency
integer (10)
end_date
timestamp (19)
days_of_week
varchar (100)
patient_identifier
patient_identifier_id
integer (10)
patient_id
patient.patient_id
identifier
varchar (50)
identifier_type
patient_identifier_type.patient_identifier_type_id
preferred
bit (1)
location_id
location.location_id
creator
users.user_id
date_created
timestamp (19)
date_changed
timestamp (19)
changed_by
users.user_id
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
patient_program_id
patient_program.patient_program_id
patient_identifier_type
patient_identifier_type_id
integer (10)
name
varchar (50)
description
long varchar (65535)
format
varchar (255)
check_digit
bit (1)
creator
users.user_id
date_created
timestamp (19)
required
bit (1)
format_description
varchar (255)
validator
varchar (200)
location_behavior
varchar (50)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
uniqueness_behavior
varchar (50)
date_changed
timestamp (19)
changed_by
users.user_id
patient_program
patient_program_id
integer (10)
patient_id
patient.patient_id
program_id
program.program_id
date_enrolled
timestamp (19)
date_completed
timestamp (19)
location_id
location.location_id
outcome_concept_id
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
patient_program_attribute
patient_program_attribute_id
integer (10)
patient_program_id
patient_program.patient_program_id
attribute_type_id
program_attribute_type.program_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
patient_state
patient_state_id
integer (10)
patient_program_id
patient_program.patient_program_id
state
program_workflow_state.program_workflow_state_id
start_date
date (10)
end_date
date (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
form_namespace_and_path
varchar (255)
encounter_id
encounter.encounter_id
patientflags_displaypoint
displaypoint_id
integer (10)
name
varchar (255)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit (1)
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
patientflags_flag
flag_id
integer (10)
name
varchar (255)
criteria
varchar (5000)
message
varchar (255)
enabled
bit (1)
evaluator
varchar (255)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit (1)
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
priority_id
integer (10)
patientflags_flag_tag
flag_id
patientflags_flag.flag_id
tag_id
patientflags_tag.tag_id
patientflags_patient_flag
patient_flag_id
integer (10)
patient_id
patient.patient_id
flag_id
patientflags_flag.flag_id
uuid
char (38)
message
varchar (255)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
patientflags_priority
priority_id
integer (10)
name
varchar (255)
style
varchar (255)
p_rank
integer (10)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit (1)
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
patientflags_tag
tag_id
integer (10)
name
varchar (255)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit (1)
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
patientflags_tag_displaypoint
tag_id
patientflags_tag.tag_id
displaypoint_id
patientflags_displaypoint.displaypoint_id
patientflags_tag_role
tag_id
patientflags_tag.tag_id
role
role.role
person
person_id
integer (10)
gender
varchar (50)
birthdate
date (10)
birthdate_estimated
bit (1)
dead
bit (1)
death_date
timestamp (19)
cause_of_death
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
deathdate_estimated
bit (1)
birthtime
time (8)
cause_of_death_non_coded
varchar (255)
person_address
person_address_id
integer (10)
person_id
person.person_id
preferred
bit (1)
address1
varchar (255)
address2
varchar (255)
city_village
varchar (255)
state_province
varchar (255)
postal_code
varchar (50)
country
varchar (50)
latitude
varchar (50)
longitude
varchar (50)
start_date
timestamp (19)
end_date
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
county_district
varchar (255)
address3
varchar (255)
address4
varchar (255)
address5
varchar (255)
address6
varchar (255)
date_changed
timestamp (19)
changed_by
users.user_id
uuid
char (38)
address7
varchar (255)
address8
varchar (255)
address9
varchar (255)
address10
varchar (255)
address11
varchar (255)
address12
varchar (255)
address13
varchar (255)
address14
varchar (255)
address15
varchar (255)
person_attribute
person_attribute_id
integer (10)
person_id
person.person_id
value
varchar (50)
person_attribute_type_id
person_attribute_type.person_attribute_type_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
person_attribute_type
person_attribute_type_id
integer (10)
name
varchar (50)
description
long varchar (65535)
format
varchar (50)
foreign_key
integer (10)
searchable
bit (1)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
edit_privilege
privilege.privilege
sort_weight
double (22)
uuid
char (38)
person_merge_log
person_merge_log_id
integer (10)
winner_person_id
person.person_id
loser_person_id
person.person_id
creator
users.user_id
date_created
timestamp (19)
merged_data
long varchar (65535)
uuid
char (38)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
person_name
person_name_id
integer (10)
preferred
bit (1)
person_id
person.person_id
prefix
varchar (50)
given_name
varchar (50)
middle_name
varchar (50)
family_name_prefix
varchar (50)
family_name
varchar (50)
family_name2
varchar (50)
family_name_suffix
varchar (50)
degree
varchar (50)
creator
users.user_id
date_created
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
changed_by
integer (10)
date_changed
timestamp (19)
uuid
char (38)
privilege
privilege
varchar (255)
description
long varchar (65535)
uuid
char (38)
program
program_id
integer (10)
concept_id
concept.concept_id
outcomes_concept_id
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
name
varchar (50)
description
long varchar (65535)
uuid
char (38)
program_attribute_type
program_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
program_workflow
program_workflow_id
integer (10)
program_id
program.program_id
concept_id
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
program_workflow_state
program_workflow_state_id
integer (10)
program_workflow_id
program_workflow.program_workflow_id
concept_id
concept.concept_id
initial
bit (1)
terminal
bit (1)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
changed_by
users.user_id
date_changed
timestamp (19)
uuid
char (38)
provider
provider_id
integer (10)
person_id
person.person_id
name
varchar (255)
identifier
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
role_id
concept.concept_id
speciality_id
concept.concept_id
provider_attribute
provider_attribute_id
integer (10)
provider_id
provider.provider_id
attribute_type_id
provider_attribute_type.provider_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
provider_attribute_type
provider_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
queue
queue_id
integer (10)
name
varchar (255)
description
varchar (255)
location_id
location.location_id
service
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
varchar (38)
priority_concept_set
concept.concept_id
status_concept_set
concept.concept_id
queue_entry
queue_entry_id
integer (10)
queue_id
queue.queue_id
patient_id
patient.patient_id
priority
concept.concept_id
priority_comment
varchar (255)
status
concept.concept_id
sort_weight
double (22)
location_waiting_for
location.location_id
provider_waiting_for
provider.provider_id
started_at
timestamp (19)
ended_at
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
queue_coming_from
queue.queue_id
visit_id
visit.visit_id
queue_room
queue_room_id
integer (10)
queue_id
queue.queue_id
name
varchar (255)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
referral_order
order_id
orders.order_id
specimen_source
concept.concept_id
laterality
varchar (20)
clinical_history
long varchar (65535)
frequency
order_frequency.order_frequency_id
number_of_repeats
integer (10)
location
concept.concept_id
relationship
relationship_id
integer (10)
person_a
person.person_id
relationship
relationship_type.relationship_type_id
person_b
person.person_id
start_date
timestamp (19)
end_date
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
date_changed
timestamp (19)
changed_by
users.user_id
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
relationship_type
relationship_type_id
integer (10)
a_is_to_b
varchar (50)
b_is_to_a
varchar (50)
preferred
bit (1)
weight
integer (10)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
date_changed
timestamp (19)
changed_by
users.user_id
report_object
report_object_id
integer (10)
name
varchar (255)
description
varchar (1000)
report_object_type
varchar (255)
report_object_sub_type
varchar (255)
xml_data
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
report_schema_xml
report_schema_id
integer (10)
name
varchar (255)
description
long varchar (65535)
xml_data
long varchar (65535)
uuid
char (38)
reporting_report_design
id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (1000)
renderer_type
varchar (255)
properties
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
report_definition_uuid
char (38)
reporting_report_design_resource
id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (1000)
report_design_id
reporting_report_design.id
content_type
varchar (100)
extension
varchar (20)
contents
long varbinary (2147483647)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
reporting_report_processor
id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (1000)
processor_type
varchar (255)
configuration
long varchar (16777215)
run_on_success
bit (1)
run_on_error
bit (1)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
report_design_id
reporting_report_design.id
processor_mode
varchar (255)
reporting_report_request
id
integer (10)
uuid
char (38)
base_cohort_uuid
char (38)
base_cohort_parameters
long varchar (65535)
report_definition_uuid
char (38)
report_definition_parameters
long varchar (65535)
renderer_type
varchar (255)
renderer_argument
varchar (255)
requested_by
users.user_id
request_datetime
timestamp (19)
priority
varchar (255)
status
varchar (255)
evaluation_start_datetime
timestamp (19)
evaluation_complete_datetime
timestamp (19)
render_complete_datetime
timestamp (19)
description
varchar (1000)
schedule
varchar (100)
process_automatically
bit (1)
minimum_days_to_preserve
integer (10)
role
role
varchar (50)
description
varchar (255)
uuid
char (38)
role_privilege
role
role.role
privilege
privilege.privilege
role_role
parent_role
role.role
child_role
role.role
room_provider_map
room_provider_map_id
integer (10)
queue_room_id
queue_room.queue_room_id
provider_id
provider.provider_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
scheduler_task_config
task_config_id
integer (10)
name
varchar (255)
description
varchar (1024)
schedulable_class
long varchar (65535)
start_time
timestamp (19)
start_time_pattern
varchar (50)
repeat_interval
integer (10)
start_on_startup
bit (1)
started
bit (1)
created_by
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
last_execution_time
timestamp (19)
uuid
char (38)
scheduler_task_config_property
task_config_property_id
integer (10)
name
varchar (255)
value
long varchar (65535)
task_config_id
scheduler_task_config.task_config_id
serialized_object
serialized_object_id
integer (10)
name
varchar (255)
description
varchar (5000)
type
varchar (255)
subtype
varchar (255)
serialization_class
varchar (255)
serialized_data
long varchar (16777215)
date_created
timestamp (19)
creator
users.user_id
date_changed
timestamp (19)
changed_by
users.user_id
retired
bit (1)
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (1000)
uuid
char (38)
test_order
order_id
orders.order_id
specimen_source
concept.concept_id
laterality
varchar (20)
clinical_history
long varchar (65535)
frequency
order_frequency.order_frequency_id
number_of_repeats
integer (10)
location
concept.concept_id
user_property
user_id
users.user_id
property
varchar (255)
property_value
long varchar (2147483647)
user_role
user_id
users.user_id
role
role.role
users
user_id
integer (10)
system_id
varchar (50)
username
varchar (50)
password
varchar (128)
salt
varchar (128)
secret_question
varchar (255)
secret_answer
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
person_id
person.person_id
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
activation_key
varchar (255)
email
varchar (255)
USER
char (32)
CURRENT_CONNECTIONS
bigint (19)
TOTAL_CONNECTIONS
bigint (19)
MAX_SESSION_CONTROLLED_MEMORY
bigint (20)
MAX_SESSION_TOTAL_MEMORY
bigint (20)
visit
visit_id
integer (10)
patient_id
patient.patient_id
visit_type_id
visit_type.visit_type_id
date_started
timestamp (19)
date_stopped
timestamp (19)
indication_concept_id
concept.concept_id
location_id
location.location_id
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
visit_attribute
visit_attribute_id
integer (10)
visit_id
visit.visit_id
attribute_type_id
visit_attribute_type.visit_attribute_type_id
value_reference
long varchar (65535)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit (1)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
visit_attribute_type
visit_attribute_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
datatype
varchar (255)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
min_occurs
integer (10)
max_occurs
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
visit_type
visit_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit (1)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)