OpenMRS Reference Application 1.9 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)
allergy_reaction
allergy_reaction_id
integer (10)
allergy_id
allergy.allergy_id
reaction_concept_id
concept.concept_id
reaction_non_coded
varchar (255)
appframework_component_state
component_state_id
integer (10)
component_id
varchar (255)
component_type
varchar (50)
appframework_user_app
json
long varchar (16777215)
appointmentscheduling_appointment
appointment_id
integer (10)
time_slot_id
appointmentscheduling_time_slot.time_slot_id
patient_id
patient.patient_id
appointment_type_id
appointmentscheduling_appointment_type.appointment_type_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
cancel_reason
varchar (1024)
appointmentscheduling_appointment_block
appointment_block_id
integer (10)
location_id
location.location_id
provider_id
provider.provider_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
appointmentscheduling_appointment_request
appointment_request_id
integer (10)
patient_id
patient.patient_id
appointment_type_id
appointmentscheduling_appointment_type.appointment_type_id
provider_id
provider.provider_id
requested_by
provider.provider_id
requested_on
timestamp (19)
min_time_frame_value
integer (10)
min_time_frame_units
varchar (255)
max_time_frame_value
integer (10)
max_time_frame_units
varchar (255)
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
appointmentscheduling_appointment_status_history
appointment_status_history_id
integer (10)
appointment_id
appointmentscheduling_appointment.appointment_id
appointmentscheduling_appointment_type
appointment_type_id
integer (10)
description
varchar (1024)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
appointmentscheduling_block_type_map
appointment_type_id
appointmentscheduling_appointment_type.appointment_type_id
appointment_block_id
appointmentscheduling_appointment_block.appointment_block_id
appointmentscheduling_time_slot
appointment_block_id
appointmentscheduling_appointment_block.appointment_block_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
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)
chartsearch_bookmark
bookmark_name
long varchar (65535)
search_phrase
long varchar (65535)
selected_categories
long varchar (65535)
patient_id
patient.patient_id
chartsearch_categories
filter_query
varchar (255)
chartsearch_category_displayname
displayname_id
integer (10)
preference_id
chartsearch_preference.preference_id
category_id
chartsearch_categories.category_id
chartsearch_history
search_phrase
long varchar (65535)
last_searched_at
timestamp (19)
patient_id
patient.patient_id
chartsearch_note
comment
long varchar (65535)
search_phrase
long varchar (65535)
priority
long varchar (65535)
created_or_last_modified_at
timestamp (19)
patient_id
patient.patient_id
chartsearch_preference
preference_id
integer (10)
enable_duplicateresults
bit
enable_multiplefiltering
bit
personalnotes_colors
varchar (255)
chartsearch_synonym_groups
chartsearch_synonyms
group_id
chartsearch_synonym_groups.group_id
clob_datatype_storage
value
long varchar (2147483647)
cohort
description
varchar (1000)
date_created
timestamp (19)
date_voided
timestamp (19)
date_changed
timestamp (19)
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)
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_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
previous_condition_id
conditions.condition_id
patient_id
patient.patient_id
concept_id
concept.concept_id
condition_non_coded
varchar (1024)
additional_detail
varchar (1024)
end_reason
concept.concept_id
date_created
timestamp (19)
date_voided
timestamp (19)
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)
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
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_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)
view_privilege
privilege.privilege
edit_privilege
privilege.privilege
date_changed
timestamp (19)
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)
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)
htmlformentry_html_form
xml_data
long varchar (16777215)
date_created
timestamp (19)
date_changed
timestamp (19)
description
varchar (1000)
date_retired
timestamp (19)
retire_reason
varchar (255)
idgen_auto_generation_option
identifier_type
patient_identifier_type.patient_identifier_type_id
source
idgen_identifier_source.id
automatic_generation_enabled
bit
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
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)
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_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
logic_rule_definition
description
varchar (1000)
rule_content
varchar (2048)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
logic_rule_token
logic_rule_token_id
integer (10)
date_created
timestamp (19)
changed_by
person.person_id
date_changed
timestamp (19)
logic_rule_token_tag
logic_rule_token_id
logic_rule_token.logic_rule_token_id
logic_token_registration
token_registration_id
integer (10)
date_created
timestamp (19)
date_changed
timestamp (19)
provider_class_name
varchar (512)
provider_token
varchar (512)
configuration
varchar (2000)
logic_token_registration_tag
token_registration_id
logic_token_registration.token_registration_id
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)
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_set
description
varchar (1000)
date_created
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
date_changed
timestamp (19)
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_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
patient
patient_id
person.person_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
allergy_status
varchar (50)
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_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_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)
person
cause_of_death
concept.concept_id
date_created
timestamp (19)
date_changed
timestamp (19)
date_voided
timestamp (19)
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 (2147483647)
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_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)
provider_role_id
providermanagement_provider_role.provider_role_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)
providermanagement_provider_role
provider_role_id
integer (10)
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
providermanagement_provider_role_provider_attribute_type
provider_role_id
providermanagement_provider_role.provider_role_id
provider_attribute_type_id
provider_attribute_type.provider_attribute_type_id
providermanagement_provider_role_relationship_type
provider_role_id
providermanagement_provider_role.provider_role_id
relationship_type_id
relationship_type.relationship_type_id
providermanagement_provider_role_supervisee_provider_role
provider_role_id
providermanagement_provider_role.provider_role_id
supervisee_provider_role_id
providermanagement_provider_role.provider_role_id
providermanagement_provider_suggestion
provider_suggestion_id
integer (10)
relationship_type_id
relationship_type.relationship_type_id
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
providermanagement_supervision_suggestion
supervision_suggestion_id
integer (10)
provider_role_id
providermanagement_provider_role.provider_role_id
suggestion_type
varchar (50)
description
varchar (1000)
date_created
timestamp (19)
date_changed
timestamp (19)
date_retired
timestamp (19)
retire_reason
varchar (255)
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
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)
minimum_days_to_preserve
integer (10)
role_privilege
privilege
privilege.privilege
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)
uiframework_user_defined_page_view
template_type
varchar (50)
template_text
long varchar (16777215)
date_created
timestamp (19)
user_property
property_value
varchar (255)
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)
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)