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.
Example | Search for... |
foobar | table names containing "foobar" |
.foobar | column names containing "foobar" |
:int | columns with datatype containing "int" |
:concept.concept_id | columns that are a foreign key to concept.concept_id |
foobar.baz | column 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:varchar | column 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
address_hierarchy_entry
address_hierarchy_entry_id
integer (10)
level_id
address_hierarchy_level.address_hierarchy_level_id
parent_id
address_hierarchy_entry.address_hierarchy_entry_id
user_generated_id
varchar (11)
address_hierarchy_level
address_hierarchy_level_id
integer (10)
parent_level_id
address_hierarchy_level.address_hierarchy_level_id
address_field
varchar (50)
allergy
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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)
appointment_service
appointment_service_id
integer (10)
description
long varchar (65535)
location_id
location.location_id
speciality_id
appointment_speciality.speciality_id
max_appointments_limit
integer (10)
duration_mins
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
initial_appointment_status
varchar (45)
appointment_service_type
appointment_service_type_id
integer (10)
appointment_service_id
appointment_service.appointment_service_id
duration_mins
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
appointment_service_weekly_availability
service_weekly_availability_id
integer (10)
service_id
appointment_service.appointment_service_id
max_appointments_limit
integer (10)
date_voided
timestamp (19)
date_created
timestamp (19)
date_changed
timestamp (19)
appointment_speciality
speciality_id
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
bed
bed_type_id
bed_type.bed_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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_patient_assignment_map
bed_patient_assignment_map_id
integer (10)
patient_id
patient.patient_id
date_started
timestamp (19)
date_stopped
timestamp (19)
encounter_id
encounter.encounter_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
bed_tag
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
bed_tag_map
bed_tag_map_id
integer (10)
bed_tag_id
bed_tag.bed_tag_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
bed_type
date_created
timestamp (19)
date_changed
timestamp (19)
retire_reason
varchar (255)
date_retired
timestamp (19)
calculation_registration
calculation_registration_id
integer (10)
provider_class_name
varchar (512)
calculation_name
varchar (512)
configuration
long varchar (65535)
care_setting
care_setting_id
integer (10)
care_setting_type
varchar (50)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
clob_datatype_storage
value
long varchar (2147483647)
cohort
description
varchar (1000)
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
location_id
location.location_id
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)
date_changed
timestamp (19)
date_voided
timestamp (19)
cohort_attribute_type
cohort_attribute_type_id
integer (10)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
cohort_member
cohort_id
cohort.cohort_id
patient_id
patient.patient_id
cohort_member_id
integer (10)
date_created
timestamp (19)
date_voided
timestamp (19)
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)
date_changed
timestamp (19)
date_voided
timestamp (19)
cohort_member_attribute_type
cohort_member_attribute_type_id
integer (10)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
cohort_type
cohort_type_id
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
concept
description
long varchar (65535)
form_text
long varchar (65535)
datatype_id
concept_datatype.concept_datatype_id
class_id
concept_class.concept_class_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
concept_answer
concept_answer_id
integer (10)
concept_id
concept.concept_id
answer_concept
concept.concept_id
date_created
timestamp (19)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
concept_attribute_type
concept_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
concept_class
concept_class_id
integer (10)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
concept_complex
concept_id
concept.concept_id
concept_datatype
concept_datatype_id
integer (10)
hl7_abbreviation
varchar (3)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
concept_description
concept_description_id
integer (10)
concept_id
concept.concept_id
description
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
concept_map_type
concept_map_type_id
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
concept_name
concept_name_id
integer (10)
concept_id
concept.concept_id
date_created
timestamp (19)
concept_name_type
varchar (50)
date_voided
timestamp (19)
date_changed
timestamp (19)
concept_name_tag
concept_name_tag_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
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
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)
obs_concept_id
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
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
date_created
timestamp (19)
concept_id
concept.concept_id
date_changed
timestamp (19)
concept_reference_range
concept_reference_range_id
integer (10)
concept_id
concept_numeric.concept_id
concept_reference_source
concept_source_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
concept_reference_term
concept_reference_term_id
integer (10)
concept_source_id
concept_reference_source.concept_source_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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
date_created
timestamp (19)
date_changed
timestamp (19)
concept_set
concept_set_id
integer (10)
concept_set
concept.concept_id
date_created
timestamp (19)
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
concept_stop_word
concept_stop_word_id
integer (10)
conditions
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)
date_created
timestamp (19)
date_voided
timestamp (19)
patient_id
patient.patient_id
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
diagnosis_attribute_type
diagnosis_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
drug
concept_id
concept.concept_id
dosage_form
concept.concept_id
maximum_daily_dose
double (22)
minimum_daily_dose
double (22)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
dose_limit_units
concept.concept_id
drug_ingredient
ingredient_id
concept.concept_id
drug_order
drug_inventory_id
drug.drug_id
as_needed_condition
varchar (255)
dosing_instructions
long varchar (65535)
duration_units
concept.concept_id
quantity_units
concept.concept_id
dose_units
concept.concept_id
frequency
order_frequency.order_frequency_id
dispense_as_written
bit (1)
drug_non_coded
varchar (255)
drug_reference_map
drug_reference_map_id
integer (10)
term_id
concept_reference_term.concept_reference_term_id
concept_map_type
concept_map_type.concept_map_type_id
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
encounter
encounter_type
encounter_type.encounter_type_id
patient_id
patient.patient_id
location_id
location.location_id
encounter_datetime
timestamp (19)
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
encounter_diagnosis
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
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
encounter_role
encounter_role_id
integer (10)
description
varchar (1024)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
encounter_type
encounter_type_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
edit_privilege
privilege.privilege
view_privilege
privilege.privilege
date_changed
timestamp (19)
fhir_concept_source
fhir_concept_source_id
integer (10)
concept_source_id
concept_reference_source.concept_source_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
fhir_diagnostic_report
diagnostic_report_id
integer (10)
concept_id
concept.concept_id
subject_id
patient.patient_id
encounter_id
encounter.encounter_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
fhir_diagnostic_report_results
diagnostic_report_id
fhir_diagnostic_report.diagnostic_report_id
fhir_encounter_class_map
encounter_class_map_id
integer (10)
location_id
location.location_id
encounter_class
varchar (255)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retired_reason
varchar (255)
fhir_observation_category_map
observation_category_map_id
integer (10)
concept_class_id
concept_class.concept_class_id
observation_category
varchar (255)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retired_reason
varchar (255)
fhir_patient_identifier_system
fhir_patient_identifier_system_id
integer (10)
patient_identifier_type_id
patient_identifier_type.patient_identifier_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
fhir_reference
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
fhir_task
status_reason
varchar (255)
owner_reference_id
fhir_reference.reference_id
encounter_reference_id
fhir_reference.reference_id
for_reference_id
fhir_reference.reference_id
date_created
timestamp (19)
date_changed
timestamp (19)
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
fhir_task_based_on_reference
reference_id
fhir_reference.reference_id
fhir_task_output
task_output_id
integer (10)
type_id
concept.concept_id
value_datetime
timestamp (19)
value_reference_id
fhir_reference.reference_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
fhir_task_part_of_reference
reference_id
fhir_reference.reference_id
field
description
long varchar (65535)
field_type
field_type.field_type_id
concept_id
concept.concept_id
attribute_name
varchar (50)
default_value
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
field_answer
answer_id
concept.concept_id
date_created
timestamp (19)
field_type
field_type_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
global_property
property_value
long varchar (65535)
description
long varchar (65535)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_changed
timestamp (19)
view_privilege
privilege.privilege
edit_privilege
privilege.privilege
delete_privilege
privilege.privilege
hl7_in_archive
hl7_in_archive_id
integer (10)
hl7_source_key
varchar (255)
hl7_data
long varchar (65535)
date_created
timestamp (19)
message_state
integer (10)
hl7_in_error
hl7_in_error_id
integer (10)
hl7_source_key
long varchar (65535)
hl7_data
long varchar (65535)
error_details
long varchar (16777215)
date_created
timestamp (19)
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)
hl7_source
hl7_source_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
idgen_auto_generation_option
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
idgen_id_pool
id
idgen_identifier_source.id
source
idgen_identifier_source.id
min_pool_size
integer (10)
refill_with_scheduled_task
bit (1)
idgen_identifier_source
description
varchar (1000)
identifier_type
patient_identifier_type.patient_identifier_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
idgen_log_entry
source
idgen_identifier_source.id
date_generated
timestamp (19)
generated_by
users.user_id
idgen_remote_source
id
idgen_identifier_source.id
idgen_reserved_identifier
source
idgen_identifier_source.id
idgen_seq_id_gen
id
idgen_identifier_source.id
next_sequence_value
integer (10)
base_character_set
varchar (255)
first_identifier_base
varchar (50)
liquibasechangelog
DATEEXECUTED
timestamp (19)
ORDEREXECUTED
integer (10)
DEPLOYMENT_ID
varchar (10)
liquibasechangeloglock
LOCKGRANTED
timestamp (19)
location
city_village
varchar (255)
state_province
varchar (255)
date_created
timestamp (19)
county_district
varchar (255)
date_retired
timestamp (19)
retire_reason
varchar (255)
parent_location
location.location_id
date_changed
timestamp (19)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
location_attribute_type
location_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
location_tag
location_tag_id
integer (10)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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)
patient_id
patient.patient_id
encounter_id
encounter.encounter_id
concept
concept.concept_id
location_id
location.location_id
dispenser
provider.provider_id
drug_order_id
drug_order.order_id
status_reason
concept.concept_id
quantity_units
concept.concept_id
dose_units
concept.concept_id
frequency
order_frequency.order_frequency_id
dosing_instructions
long varchar (65535)
date_prepared
timestamp (19)
date_handed_over
timestamp (19)
substitution_type
concept.concept_id
substitution_reason
concept.concept_id
form_namespace_and_path
varchar (255)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
note
patient_id
patient.patient_id
encounter_id
encounter.encounter_id
date_created
timestamp (19)
date_changed
timestamp (19)
notification_alert
date_to_expire
timestamp (19)
date_created
timestamp (19)
date_changed
timestamp (19)
notification_alert_recipient
alert_id
notification_alert.alert_id
date_changed
timestamp (19)
notification_template
template
long varchar (65535)
obs
person_id
person.person_id
concept_id
concept.concept_id
encounter_id
encounter.encounter_id
obs_datetime
timestamp (19)
location_id
location.location_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_datetime
timestamp (19)
value_modifier
varchar (2)
value_text
long varchar (65535)
value_complex
varchar (1000)
date_created
timestamp (19)
date_voided
timestamp (19)
previous_version
obs.obs_id
form_namespace_and_path
varchar (255)
interpretation
varchar (32)
obs_reference_range
obs_reference_range_id
integer (10)
openconceptlab_import
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
import_id
openconceptlab_import.import_id
version_url
varchar (1024)
error_message
varchar (1024)
order_attribute
order_attribute_id
integer (10)
attribute_type_id
order_attribute_type.order_attribute_type_id
value_reference
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
order_attribute_type
order_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
order_frequency
order_frequency_id
integer (10)
concept_id
concept.concept_id
frequency_per_day
double (22)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
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
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
order_group_attribute_type
order_group_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
order_set
description
varchar (1000)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
order_set_attribute_type
order_set_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
order_template
order_template_id
integer (10)
concept
concept.concept_id
template
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
order_type
order_type_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
java_class_name
varchar (255)
parent
order_type.order_type_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_type_id
order_type.order_type_id
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)
date_created
timestamp (19)
date_voided
timestamp (19)
patient_id
patient.patient_id
accession_number
varchar (255)
previous_order_id
orders.order_id
comment_to_fulfiller
varchar (1024)
care_setting
care_setting.care_setting_id
scheduled_date
timestamp (19)
order_group_id
order_group.order_group_id
fulfiller_comment
varchar (1024)
fulfiller_status
varchar (50)
form_namespace_and_path
varchar (255)
patient
patient_id
person.person_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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
location_id
location.location_id
appointment_kind
varchar (45)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
related_appointment_id
patient_appointment.patient_appointment_id
tele_health_video_link
varchar (255)
date_appointment_scheduled
timestamp (19)
patient_appointment_audit
patient_appointment_audit_id
integer (10)
appointment_id
patient_appointment.patient_appointment_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
patient_appointment_recurring_time
patient_appointment_timings_id
integer (10)
recurrence_type
varchar (20)
days_of_week
varchar (100)
patient_identifier
patient_identifier_id
integer (10)
patient_id
patient.patient_id
identifier_type
patient_identifier_type.patient_identifier_type_id
location_id
location.location_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
patient_program_id
patient_program.patient_program_id
patient_identifier_type
patient_identifier_type_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
format_description
varchar (255)
location_behavior
varchar (50)
date_retired
timestamp (19)
retire_reason
varchar (255)
uniqueness_behavior
varchar (50)
date_changed
timestamp (19)
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
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
patient_state
patient_state_id
integer (10)
patient_program_id
patient_program.patient_program_id
state
program_workflow_state.program_workflow_state_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
form_namespace_and_path
varchar (255)
encounter_id
encounter.encounter_id
patientflags_displaypoint
displaypoint_id
integer (10)
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
patientflags_flag
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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
date_voided
timestamp (19)
date_created
timestamp (19)
date_changed
timestamp (19)
patientflags_priority
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
patientflags_tag
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
patientflags_tag_displaypoint
tag_id
patientflags_tag.tag_id
displaypoint_id
patientflags_displaypoint.displaypoint_id
patientflags_tag_role
tag_id
patientflags_tag.tag_id
person
birthdate_estimated
bit (1)
cause_of_death
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
deathdate_estimated
bit (1)
cause_of_death_non_coded
varchar (255)
person_address
person_address_id
integer (10)
person_id
person.person_id
city_village
varchar (255)
state_province
varchar (255)
date_created
timestamp (19)
date_voided
timestamp (19)
county_district
varchar (255)
date_changed
timestamp (19)
person_attribute
person_attribute_id
integer (10)
person_id
person.person_id
person_attribute_type_id
person_attribute_type.person_attribute_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
person_attribute_type
person_attribute_type_id
integer (10)
description
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
edit_privilege
privilege.privilege
person_merge_log
person_merge_log_id
integer (10)
winner_person_id
person.person_id
loser_person_id
person.person_id
date_created
timestamp (19)
merged_data
long varchar (65535)
date_changed
timestamp (19)
date_voided
timestamp (19)
person_name
person_name_id
integer (10)
person_id
person.person_id
family_name_prefix
varchar (50)
family_name_suffix
varchar (50)
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
privilege
description
long varchar (65535)
program
concept_id
concept.concept_id
outcomes_concept_id
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
description
long varchar (65535)
program_attribute_type
program_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
program_workflow
program_workflow_id
integer (10)
program_id
program.program_id
concept_id
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
program_workflow_state
program_workflow_state_id
integer (10)
program_workflow_id
program_workflow.program_workflow_id
concept_id
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
provider
person_id
person.person_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
provider_attribute_type
provider_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
queue
location_id
location.location_id
service
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
priority_concept_set
concept.concept_id
status_concept_set
concept.concept_id
queue_entry
queue_entry_id
integer (10)
patient_id
patient.patient_id
priority
concept.concept_id
priority_comment
varchar (255)
location_waiting_for
location.location_id
provider_waiting_for
provider.provider_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
queue_coming_from
queue.queue_id
queue_room
queue_room_id
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
referral_order
specimen_source
concept.concept_id
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)
relationship
relationship_type.relationship_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
relationship_type
relationship_type_id
integer (10)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
report_object
report_object_id
integer (10)
description
varchar (1000)
report_object_type
varchar (255)
report_object_sub_type
varchar (255)
xml_data
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
report_schema_xml
report_schema_id
integer (10)
description
long varchar (65535)
xml_data
long varchar (65535)
reporting_report_design
description
varchar (1000)
renderer_type
varchar (255)
properties
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
report_definition_uuid
char (38)
reporting_report_design_resource
description
varchar (1000)
report_design_id
reporting_report_design.id
content_type
varchar (100)
contents
long varbinary (2147483647)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
reporting_report_processor
description
varchar (1000)
processor_type
varchar (255)
configuration
long varchar (16777215)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
report_design_id
reporting_report_design.id
processor_mode
varchar (255)
reporting_report_request
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)
evaluation_start_datetime
timestamp (19)
evaluation_complete_datetime
timestamp (19)
render_complete_datetime
timestamp (19)
description
varchar (1000)
process_automatically
bit (1)
minimum_days_to_preserve
integer (10)
role_privilege
privilege
privilege.privilege
room_provider_map
room_provider_map_id
integer (10)
queue_room_id
queue_room.queue_room_id
provider_id
provider.provider_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
scheduler_task_config
task_config_id
integer (10)
description
varchar (1024)
schedulable_class
long varchar (65535)
start_time_pattern
varchar (50)
repeat_interval
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
last_execution_time
timestamp (19)
scheduler_task_config_property
task_config_property_id
integer (10)
value
long varchar (65535)
task_config_id
scheduler_task_config.task_config_id
serialized_object
serialized_object_id
integer (10)
description
varchar (5000)
serialization_class
varchar (255)
serialized_data
long varchar (16777215)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (1000)
test_order
specimen_source
concept.concept_id
clinical_history
long varchar (65535)
frequency
order_frequency.order_frequency_id
number_of_repeats
integer (10)
location
concept.concept_id
user_property
property_value
long varchar (2147483647)
users
secret_question
varchar (255)
secret_answer
varchar (255)
date_created
timestamp (19)
date_changed
timestamp (19)
person_id
person.person_id
date_retired
timestamp (19)
retire_reason
varchar (255)
activation_key
varchar (255)
CURRENT_CONNECTIONS
bigint (19)
TOTAL_CONNECTIONS
bigint (19)
MAX_SESSION_CONTROLLED_MEMORY
bigint (20)
MAX_SESSION_TOTAL_MEMORY
bigint (20)
visit
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
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
visit_attribute
visit_attribute_id
integer (10)
attribute_type_id
visit_attribute_type.visit_attribute_type_id
value_reference
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
visit_attribute_type
visit_attribute_type_id
integer (10)
description
varchar (1024)
datatype_config
long varchar (65535)
preferred_handler
varchar (255)
handler_config
long varchar (65535)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
visit_type
visit_type_id
integer (10)
description
varchar (1024)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)