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.
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
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)
comment
varchar (1024)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
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)
appframework_component_state
component_state_id
integer (10)
uuid
char (38)
component_id
varchar (255)
component_type
varchar (50)
enabled
bit
appframework_user_app
app_id
varchar (50)
json
long varchar (16777215)
appointmentscheduling_appointment
appointment_id
integer (10)
time_slot_id
appointmentscheduling_time_slot.time_slot_id
visit_id
visit.visit_id
patient_id
patient.patient_id
appointment_type_id
appointmentscheduling_appointment_type.appointment_type_id
status
varchar (255)
reason
varchar (1024)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
tinyint (3)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
cancel_reason
varchar (1024)
appointmentscheduling_appointment_block
appointment_block_id
integer (10)
location_id
location.location_id
provider_id
provider.provider_id
start_date
timestamp (19)
end_date
timestamp (19)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
tinyint (3)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
appointmentscheduling_appointment_request
appointment_request_id
integer (10)
patient_id
patient.patient_id
appointment_type_id
appointmentscheduling_appointment_type.appointment_type_id
status
varchar (255)
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)
notes
varchar (1024)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
tinyint (3)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
appointmentscheduling_appointment_status_history
appointment_status_history_id
integer (10)
appointment_id
appointmentscheduling_appointment.appointment_id
status
varchar (255)
start_date
timestamp (19)
end_date
timestamp (19)
appointmentscheduling_appointment_type
appointment_type_id
integer (10)
name
varchar (255)
description
varchar (1024)
duration
integer (10)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
tinyint (3)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
confidential
tinyint (3)
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
time_slot_id
integer (10)
appointment_block_id
appointmentscheduling_appointment_block.appointment_block_id
start_date
timestamp (19)
end_date
timestamp (19)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
tinyint (3)
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
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
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)
chartsearch_bookmark
bookmark_id
integer (10)
bookmark_name
long varchar (65535)
search_phrase
long varchar (65535)
selected_categories
long varchar (65535)
uuid
char (38)
user_id
users.user_id
patient_id
patient.patient_id
default_search
bit
chartsearch_categories
category_id
integer (10)
name
varchar (50)
filter_query
varchar (255)
description
varchar (255)
uuid
char (38)
chartsearch_category_displayname
displayname_id
integer (10)
uuid
char (38)
diplay_name
varchar (15)
preference_id
chartsearch_preference.preference_id
category_id
chartsearch_categories.category_id
chartsearch_history
search_id
integer (10)
search_phrase
long varchar (65535)
last_searched_at
timestamp (19)
uuid
char (38)
user_id
users.user_id
patient_id
patient.patient_id
chartsearch_note
note_id
integer (10)
comment
long varchar (65535)
search_phrase
long varchar (65535)
priority
long varchar (65535)
created_or_last_modified_at
timestamp (19)
uuid
char (38)
display_color
char (10)
user_id
users.user_id
patient_id
patient.patient_id
chartsearch_preference
preference_id
integer (10)
uuid
char (38)
enable_history
bit
enable_bookmark
bit
enable_notes
bit
enable_duplicateresults
bit
enable_multiplefiltering
bit
enable_quicksearches
bit
enable_defaultsearch
bit
personalnotes_colors
varchar (255)
user_id
users.user_id
chartsearch_synonym_groups
group_id
integer (10)
group_name
varchar (255)
is_category
bit
chartsearch_synonyms
synonym_id
integer (10)
group_id
chartsearch_synonym_groups.group_id
name
varchar (255)
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
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)
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
voided_by
integer (10)
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
concept
concept_id
integer (10)
retired
bit
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
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
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
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
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
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
retired
bit
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
creator
users.user_id
date_created
timestamp (19)
concept_name_type
varchar (50)
voided
bit
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
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)
precise
bit
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_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
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
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)
previous_condition_id
conditions.condition_id
patient_id
patient.patient_id
status
varchar (255)
concept_id
concept.concept_id
condition_non_coded
varchar (1024)
onset_date
timestamp (19)
additional_detail
varchar (1024)
end_date
timestamp (19)
end_reason
concept.concept_id
creator
users.user_id
date_created
timestamp (19)
voided
bit
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
drug
drug_id
integer (10)
concept_id
concept.concept_id
name
varchar (255)
combination
bit
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
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)
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
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
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
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
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_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
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
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
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
view_privilege
privilege.privilege
edit_privilege
privilege.privilege
changed_by
users.user_id
date_changed
timestamp (19)
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
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit
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
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
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
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
changed_by
users.user_id
date_changed
timestamp (19)
creator
users.user_id
date_created
timestamp (19)
sort_weight
double (22)
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
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)
htmlformentry_html_form
id
integer (10)
form_id
form.form_id
name
varchar (255)
xml_data
long varchar (16777215)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit
uuid
char (38)
description
varchar (1000)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
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
automatic_generation_enabled
bit
location
location.location_id
idgen_id_pool
id
idgen_identifier_source.id
source
idgen_identifier_source.id
batch_size
integer (10)
min_pool_size
integer (10)
sequential
bit
refill_with_scheduled_task
bit
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
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 (20)
suffix
varchar (20)
min_length
integer (10)
max_length
integer (10)
liquibasechangelog
ID
varchar (63)
AUTHOR
varchar (63)
FILENAME
varchar (200)
DATEEXECUTED
timestamp (19)
ORDEREXECUTED
integer (10)
EXECTYPE
varchar (10)
MD5SUM
varchar (35)
DESCRIPTION
varchar (255)
COMMENTS
varchar (255)
TAG
varchar (255)
LIQUIBASE
varchar (20)
liquibasechangeloglock
ID
integer (10)
LOCKED
bit
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
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_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
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
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
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
logic_rule_definition
id
integer (10)
uuid
char (38)
name
varchar (255)
description
varchar (1000)
rule_content
varchar (2048)
language
varchar (255)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
smallint (5)
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
logic_rule_token
logic_rule_token_id
integer (10)
creator
person.person_id
date_created
timestamp (19)
changed_by
person.person_id
date_changed
timestamp (19)
token
varchar (512)
class_name
varchar (512)
state
varchar (512)
uuid
char (38)
logic_rule_token_tag
logic_rule_token_id
logic_rule_token.logic_rule_token_id
tag
varchar (512)
logic_token_registration
token_registration_id
integer (10)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
token
varchar (512)
provider_class_name
varchar (512)
provider_token
varchar (512)
configuration
varchar (2000)
uuid
char (38)
logic_token_registration_tag
token_registration_id
logic_token_registration.token_registration_id
tag
varchar (512)
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
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
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
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
date_retired
timestamp (19)
retired_by
users.user_id
retire_reason
varchar (255)
uuid
char (38)
metadatasharing_exported_package
exported_package_id
integer (10)
uuid
char (38)
group_uuid
char (38)
version
integer (10)
published
bit
date_created
timestamp (19)
name
varchar (64)
description
varchar (256)
content
long varbinary (2147483647)
metadatasharing_imported_item
imported_item_id
integer (10)
uuid
char (38)
classname
varchar (256)
existing_uuid
char (38)
date_imported
timestamp (19)
date_changed
timestamp (19)
import_type
tinyint (3)
assessed
bit
metadatasharing_imported_package
imported_package_id
integer (10)
uuid
char (38)
group_uuid
char (38)
subscription_url
varchar (512)
subscription_status
tinyint (3)
date_created
timestamp (19)
date_imported
timestamp (19)
name
varchar (64)
description
varchar (256)
import_config
varchar (1024)
remote_version
integer (10)
version
integer (10)
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
alert_read
bit
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
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
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)
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
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
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_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
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_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
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_type
order_type_id
integer (10)
name
varchar (255)
description
long varchar (65535)
creator
users.user_id
date_created
timestamp (19)
retired
bit
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
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)
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
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
allergy_status
varchar (50)
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
location_id
location.location_id
creator
users.user_id
date_created
timestamp (19)
date_changed
timestamp (19)
changed_by
users.user_id
voided
bit
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
patient_identifier_type
patient_identifier_type_id
integer (10)
name
varchar (50)
description
long varchar (65535)
format
varchar (255)
check_digit
bit
creator
users.user_id
date_created
timestamp (19)
required
bit
format_description
varchar (255)
validator
varchar (200)
location_behavior
varchar (50)
retired
bit
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
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
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
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
person
person_id
integer (10)
gender
varchar (50)
birthdate
date (10)
birthdate_estimated
bit
dead
bit
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
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
uuid
char (38)
deathdate_estimated
bit
birthtime
time (8)
person_address
person_address_id
integer (10)
person_id
person.person_id
preferred
bit
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
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
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
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit
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 (2147483647)
uuid
char (38)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit
voided_by
users.user_id
date_voided
timestamp (19)
void_reason
varchar (255)
person_name
person_name_id
integer (10)
preferred
bit
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
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
name
varchar (50)
description
long varchar (65535)
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
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
terminal
bit
creator
users.user_id
date_created
timestamp (19)
retired
bit
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
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
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)
uuid
char (38)
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
voided
bit
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
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
providermanagement_provider_role
provider_role_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
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
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)
criteria
varchar (5000)
evaluator
varchar (255)
relationship_type_id
relationship_type.relationship_type_id
name
varchar (255)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
providermanagement_supervision_suggestion
supervision_suggestion_id
integer (10)
criteria
varchar (5000)
evaluator
varchar (255)
provider_role_id
providermanagement_provider_role.provider_role_id
suggestion_type
varchar (50)
name
varchar (255)
description
varchar (1000)
creator
integer (10)
date_created
timestamp (19)
changed_by
integer (10)
date_changed
timestamp (19)
retired
bit
retired_by
integer (10)
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
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
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
weight
integer (10)
description
varchar (255)
creator
users.user_id
date_created
timestamp (19)
retired
bit
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
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
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 (50)
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
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
run_on_error
bit
creator
users.user_id
date_created
timestamp (19)
changed_by
users.user_id
date_changed
timestamp (19)
retired
bit
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
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
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
started
bit
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
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)
uiframework_user_defined_page_view
page_view_id
integer (10)
name
varchar (100)
template_type
varchar (50)
template_text
long varchar (16777215)
uuid
varchar (38)
creator
integer (10)
date_created
timestamp (19)
user_property
user_id
users.user_id
property
varchar (100)
property_value
varchar (255)
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
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)
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
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
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
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
retired_by
users.user_id
date_retired
timestamp (19)
retire_reason
varchar (255)
uuid
char (38)