openEMR Table Schema Downloaded
openEMR Table Schema Downloaded from EasyManage
/* Table Schema SQL (mysql format) for [openEMR] */
/* Id: 5008448 Name: addresses */
create table addresses (
id INT
, line1 VARCHAR (255)
, line2 VARCHAR (255)
, city VARCHAR (255)
, state VARCHAR (35)
, zip VARCHAR (10)
, plus_four VARCHAR (4)
, country VARCHAR (255)
, foreign_id INT
, district VARCHAR (255)
);
/* Id: 5008450 Name: amc_misc_data */
create table amc_misc_data (
amc_id VARCHAR (31)
, pid INT
, map_category VARCHAR (255)
, map_id INT
, date_created TIMESTAMP
, date_completed TIMESTAMP
, soc_provided TIMESTAMP
);
/* Id: 5008452 Name: amendments */
create table amendments (
amendment_id INT
, amendment_date TIMESTAMP
, amendment_by VARCHAR (50)
, amendment_status VARCHAR (50)
, pid INT
, amendment_desc MEDIUMTEXT
, created_by INT
, modified_by INT
, created_time TIMESTAMP
, modified_time TIMESTAMP
);
/* Id: 5008454 Name: amendments_history */
create table amendments_history (
amendment_id INT
, amendment_note MEDIUMTEXT
, amendment_status VARCHAR (50)
, created_by INT
, created_time TIMESTAMP
);
/* Id: 5008456 Name: api_log */
create table api_log (
id INT
, log_id INT
, user_id INT
, patient_id INT
, ip_address VARCHAR (255)
, method VARCHAR (20)
, request VARCHAR (255)
, request_url MEDIUMTEXT
, request_body MEDIUMTEXT
, response MEDIUMTEXT
, created_time TIMESTAMP
);
/* Id: 5008458 Name: api_refresh_token */
create table api_refresh_token (
id INT
, user_id VARCHAR (40)
, client_id VARCHAR (80)
, token VARCHAR (128)
, expiry TIMESTAMP
, revoked VARCHAR (0)
);
/* Id: 5008460 Name: api_token */
create table api_token (
id INT
, user_id VARCHAR (40)
, token VARCHAR (128)
, expiry TIMESTAMP
, client_id VARCHAR (80)
, scope MEDIUMTEXT
, revoked VARCHAR (0)
, context MEDIUMTEXT
);
/* Id: 5008462 Name: ar_activity */
create table ar_activity (
pid INT
, encounter INT
, sequence_no INT
, code_type VARCHAR (12)
, code VARCHAR (20)
, modifier VARCHAR (12)
, payer_type INT
, post_time TIMESTAMP
, post_user INT
, session_id INT
, memo VARCHAR (255)
, pay_amount DECIMAL(38,6)
, adj_amount DECIMAL(38,6)
, modified_time TIMESTAMP
, follow_up VARCHAR (1)
, follow_up_note MEDIUMTEXT
, account_code VARCHAR (15)
, reason_code VARCHAR (255)
, deleted TIMESTAMP
, post_date TIMESTAMP
, payer_claim_number VARCHAR (30)
);
/* Id: 5008464 Name: ar_session */
create table ar_session (
session_id INT
, payer_id INT
, user_id INT
, closed VARCHAR (0)
, reference VARCHAR (255)
, check_date TIMESTAMP
, deposit_date TIMESTAMP
, pay_total DECIMAL(38,6)
, created_time TIMESTAMP
, modified_time TIMESTAMP
, global_amount DECIMAL(38,6)
, payment_type VARCHAR (50)
, description MEDIUMTEXT
, adjustment_code VARCHAR (50)
, post_to_date TIMESTAMP
, patient_id INT
, payment_method VARCHAR (25)
);
/* Id: 5008466 Name: audit_details */
create table audit_details (
id INT
, table_name VARCHAR (100)
, field_name VARCHAR (100)
, field_value MEDIUMTEXT
, audit_master_id INT
, entry_identification VARCHAR (255)
);
/* Id: 5008468 Name: audit_master */
create table audit_master (
id INT
, pid INT
, user_id INT
, approval_status INT
, comments MEDIUMTEXT
, created_time TIMESTAMP
, modified_time TIMESTAMP
, ip_address VARCHAR (100)
, type INT
, is_qrda_document VARCHAR (0)
, is_unstructured_document VARCHAR (0)
);
/* Id: 5008470 Name: automatic_notification */
create table automatic_notification (
notification_id INT
, sms_gateway_type VARCHAR (255)
, provider_name VARCHAR (100)
, message MEDIUMTEXT
, email_sender VARCHAR (100)
, email_subject VARCHAR (100)
, type VARCHAR (5)
);
/* Id: 5008472 Name: background_services */
create table background_services (
name VARCHAR (31)
, title VARCHAR (127)
, active VARCHAR (0)
, running VARCHAR (0)
, next_run TIMESTAMP
, execute_interval INT
, function VARCHAR (127)
, require_once VARCHAR (255)
, sort_order INT
);
/* Id: 5008474 Name: batchcom */
create table batchcom (
id INT
, patient_id INT
, sent_by INT
, msg_type VARCHAR (60)
, msg_subject VARCHAR (255)
, msg_text MEDIUMTEXT
, msg_date_sent TIMESTAMP
);
/* Id: 5008476 Name: benefit_eligibility */
create table benefit_eligibility (
response_id INT
, verification_id INT
, type VARCHAR (4)
, benefit_type VARCHAR (255)
, start_date TIMESTAMP
, end_date TIMESTAMP
, coverage_level VARCHAR (255)
, coverage_type VARCHAR (512)
, plan_type VARCHAR (255)
, plan_description VARCHAR (255)
, coverage_period VARCHAR (255)
, amount DECIMAL(38,6)
, percent DECIMAL(38,6)
, network_ind VARCHAR (2)
, message VARCHAR (512)
, response_status VARCHAR (2)
, response_create_date TIMESTAMP
, response_modify_date TIMESTAMP
);
/* Id: 5008478 Name: billing */
create table billing (
id INT
, date TIMESTAMP
, code_type VARCHAR (15)
, code VARCHAR (20)
, pid INT
, provider_id INT
, user INT
, groupname VARCHAR (255)
, authorized VARCHAR (0)
, encounter INT
, code_text MEDIUMTEXT
, billed VARCHAR (0)
, activity VARCHAR (0)
, payer_id INT
, bill_process INT
, bill_date TIMESTAMP
, process_date TIMESTAMP
, process_file VARCHAR (255)
, modifier VARCHAR (12)
, units INT
, fee DECIMAL(38,6)
, justify VARCHAR (255)
, target VARCHAR (30)
, x12_partner_id INT
, ndc_info VARCHAR (255)
, notecodes VARCHAR (25)
, external_id VARCHAR (20)
, pricelevel VARCHAR (31)
, revenue_code VARCHAR (6)
, chargecat VARCHAR (31)
);
/* Id: 5008480 Name: calendar_external */
create table calendar_external (
id INT
, date TIMESTAMP
, description VARCHAR (45)
, source VARCHAR (45)
);
/* Id: 5008482 Name: categories */
create table categories (
id INT
, name VARCHAR (255)
, value VARCHAR (255)
, parent INT
, lft INT
, rght INT
, aco_spec VARCHAR (63)
, codes VARCHAR (255)
);
/* Id: 5008484 Name: categories_seq */
create table categories_seq (
id INT
);
/* Id: 5008486 Name: categories_to_documents */
create table categories_to_documents (
category_id INT
, document_id INT
);
/* Id: 5008488 Name: ccda */
create table ccda (
id INT
, uuid MEDIUMBLOB
, pid INT
, encounter INT
, ccda_data MEDIUMTEXT
, time VARCHAR (50)
, status INT
, updated_date TIMESTAMP
, user_id VARCHAR (50)
, couch_docid VARCHAR (100)
, couch_revid VARCHAR (100)
, hash VARCHAR (255)
, view INT
, transfer INT
, emr_transfer INT
, encrypted INT
, transaction_id INT
);
/* Id: 5008490 Name: ccda_components */
create table ccda_components (
ccda_components_id INT
, ccda_components_field VARCHAR (100)
, ccda_components_name VARCHAR (100)
, ccda_type INT
);
/* Id: 5008492 Name: ccda_field_mapping */
create table ccda_field_mapping (
id INT
, table_id INT
, ccda_field VARCHAR (100)
);
/* Id: 5008494 Name: ccda_sections */
create table ccda_sections (
ccda_sections_id INT
, ccda_components_id INT
, ccda_sections_field VARCHAR (100)
, ccda_sections_name VARCHAR (100)
, ccda_sections_req_mapping INT
);
/* Id: 5008496 Name: ccda_table_mapping */
create table ccda_table_mapping (
id INT
, ccda_component VARCHAR (100)
, ccda_component_section VARCHAR (100)
, form_dir VARCHAR (100)
, form_type INT
, form_table VARCHAR (100)
, user_id INT
, deleted INT
, timestamp TIMESTAMP
);
/* Id: 5008498 Name: chart_tracker */
create table chart_tracker (
ct_pid INT
, ct_when TIMESTAMP
, ct_userid INT
, ct_location VARCHAR (31)
);
/* Id: 5008500 Name: claims */
create table claims (
patient_id INT
, encounter_id INT
, version INT
, payer_id INT
, status INT
, payer_type INT
, bill_process INT
, bill_time TIMESTAMP
, process_time TIMESTAMP
, process_file VARCHAR (255)
, target VARCHAR (30)
, x12_partner_id INT
, submitted_claim MEDIUMTEXT
);
/* Id: 5008502 Name: clinical_plans */
create table clinical_plans (
id VARCHAR (31)
, pid INT
, normal_flag VARCHAR (0)
, cqm_flag VARCHAR (0)
, cqm_2011_flag VARCHAR (0)
, cqm_2014_flag VARCHAR (0)
, cqm_measure_group VARCHAR (10)
);
/* Id: 5008504 Name: clinical_plans_rules */
create table clinical_plans_rules (
plan_id VARCHAR (31)
, rule_id VARCHAR (31)
);
/* Id: 5008506 Name: clinical_rules */
create table clinical_rules (
id VARCHAR (31)
, pid INT
, active_alert_flag VARCHAR (0)
, passive_alert_flag VARCHAR (0)
, cqm_flag VARCHAR (0)
, cqm_2011_flag VARCHAR (0)
, cqm_2014_flag VARCHAR (0)
, cqm_nqf_code VARCHAR (10)
, cqm_pqri_code VARCHAR (10)
, amc_flag VARCHAR (0)
, amc_2011_flag VARCHAR (0)
, amc_2014_flag VARCHAR (0)
, amc_2015_flag VARCHAR (0)
, amc_code VARCHAR (10)
, amc_code_2014 VARCHAR (30)
, amc_code_2015 VARCHAR (30)
, amc_2014_stage1_flag VARCHAR (0)
, amc_2014_stage2_flag VARCHAR (0)
, patient_reminder_flag VARCHAR (0)
, bibliographic_citation VARCHAR (255)
, developer VARCHAR (255)
, funding_source VARCHAR (255)
, release_version VARCHAR (255)
, web_reference VARCHAR (255)
, linked_referential_cds VARCHAR (50)
, access_control VARCHAR (255)
, patient_dob_usage MEDIUMTEXT
, patient_ethnicity_usage MEDIUMTEXT
, patient_health_status_usage MEDIUMTEXT
, patient_gender_identity_usage MEDIUMTEXT
, patient_language_usage MEDIUMTEXT
, patient_race_usage MEDIUMTEXT
, patient_sex_usage MEDIUMTEXT
, patient_sexual_orientation_usage MEDIUMTEXT
, patient_sodh_usage MEDIUMTEXT
);
/* Id: 5008508 Name: clinical_rules_log */
create table clinical_rules_log (
id INT
, date TIMESTAMP
, pid INT
, uid INT
, category VARCHAR (255)
, value MEDIUMTEXT
, new_value MEDIUMTEXT
, facility_id INT
);
/* Id: 5008510 Name: code_types */
create table code_types (
ct_key VARCHAR (15)
, ct_id INT
, ct_seq INT
, ct_mod INT
, ct_just VARCHAR (15)
, ct_mask VARCHAR (9)
, ct_fee VARCHAR (0)
, ct_rel VARCHAR (0)
, ct_nofs VARCHAR (0)
, ct_diag VARCHAR (0)
, ct_active VARCHAR (0)
, ct_label VARCHAR (31)
, ct_external VARCHAR (0)
, ct_claim VARCHAR (0)
, ct_proc VARCHAR (0)
, ct_term VARCHAR (0)
, ct_problem VARCHAR (0)
, ct_drug VARCHAR (0)
);
/* Id: 5008512 Name: codes */
create table codes (
id INT
, code_text MEDIUMTEXT
, code_text_short MEDIUMTEXT
, code VARCHAR (25)
, code_type INT
, modifier VARCHAR (12)
, units INT
, fee DECIMAL(38,6)
, superbill VARCHAR (31)
, related_code VARCHAR (255)
, taxrates VARCHAR (255)
, cyp_factor DECIMAL(38,6)
, active VARCHAR (0)
, reportable VARCHAR (0)
, financial_reporting VARCHAR (0)
, revenue_code VARCHAR (6)
);
/* Id: 5008514 Name: codes_history */
create table codes_history (
log_id INT
, date TIMESTAMP
, code VARCHAR (25)
, modifier VARCHAR (12)
, active VARCHAR (0)
, diagnosis_reporting VARCHAR (0)
, financial_reporting VARCHAR (0)
, category VARCHAR (255)
, code_type_name VARCHAR (255)
, code_text MEDIUMTEXT
, code_text_short MEDIUMTEXT
, prices MEDIUMTEXT
, action_type VARCHAR (25)
, update_by VARCHAR (255)
);
/* Id: 5008516 Name: contact */
create table contact (
id INT
, foreign_table_name VARCHAR (255)
, foreign_id INT
);
/* Id: 5008518 Name: contact_address */
create table contact_address (
id INT
, contact_id INT
, address_id INT
, priority INT
, type VARCHAR (255)
, use VARCHAR (255)
, notes MEDIUMTEXT
, status VARCHAR (1)
, is_primary VARCHAR (1)
, created_date TIMESTAMP
, period_start TIMESTAMP
, period_end TIMESTAMP
, inactivated_reason VARCHAR (45)
);
/* Id: 5008520 Name: customlists */
create table customlists (
cl_list_slno INT
, cl_list_id INT
, cl_list_item_id INT
, cl_list_type INT
, cl_list_item_short VARCHAR (10)
, cl_list_item_long MEDIUMTEXT
, cl_list_item_level INT
, cl_order INT
, cl_deleted VARCHAR (0)
, cl_creator INT
);
/* Id: 5008522 Name: dated_reminders */
create table dated_reminders (
dr_id INT
, dr_from_ID INT
, dr_message_text VARCHAR (160)
, dr_message_sent_date TIMESTAMP
, dr_message_due_date TIMESTAMP
, pid INT
, message_priority VARCHAR (0)
, message_processed VARCHAR (0)
, processed_date TIMESTAMP
, dr_processed_by INT
);
/* Id: 5008524 Name: dated_reminders_link */
create table dated_reminders_link (
dr_link_id INT
, dr_id INT
, to_id INT
);
/* Id: 5008526 Name: direct_message_log */
create table direct_message_log (
id INT
, msg_type VARCHAR (1)
, msg_id VARCHAR (127)
, sender VARCHAR (255)
, recipient VARCHAR (255)
, create_ts TIMESTAMP
, status VARCHAR (1)
, status_info VARCHAR (511)
, status_ts TIMESTAMP
, patient_id INT
, user_id INT
);
/* Id: 5008528 Name: document_template_profiles */
create table document_template_profiles (
id INT
, template_id INT
, profile VARCHAR (64)
, template_name VARCHAR (255)
, category VARCHAR (64)
, provider INT
, modified_date TIMESTAMP
, member_of VARCHAR (64)
, active VARCHAR (0)
, recurring VARCHAR (0)
, event_trigger VARCHAR (31)
, period INT
, notify_trigger VARCHAR (31)
, notify_period INT
);
/* Id: 5008530 Name: document_templates */
create table document_templates (
id INT
, pid INT
, provider INT
, encounter INT
, modified_date TIMESTAMP
, profile VARCHAR (63)
, category VARCHAR (63)
, location VARCHAR (255)
, template_name VARCHAR (255)
, status VARCHAR (31)
, send_date TIMESTAMP
, end_date TIMESTAMP
, size INT
, template_content MEDIUMBLOB
, mime VARCHAR (31)
);
/* Id: 5008532 Name: documents */
create table documents (
id INT
, uuid MEDIUMBLOB
, type VARCHAR (9)
, size INT
, date TIMESTAMP
, date_expires TIMESTAMP
, url VARCHAR (255)
, thumb_url VARCHAR (255)
, mimetype VARCHAR (255)
, pages INT
, owner INT
, revision TIMESTAMP
, foreign_id INT
, docdate TIMESTAMP
, hash VARCHAR (255)
, list_id INT
, name VARCHAR (255)
, drive_uuid MEDIUMBLOB
, couch_docid VARCHAR (100)
, couch_revid VARCHAR (100)
, storagemethod INT
, path_depth INT
, imported INT
, encounter_id INT
, encounter_check VARCHAR (0)
, audit_master_approval_status INT
, audit_master_id INT
, documentationOf VARCHAR (255)
, encrypted INT
, document_data MEDIUMTEXT
, deleted VARCHAR (0)
, foreign_reference_id INT
, foreign_reference_table VARCHAR (40)
);
/* Id: 5008534 Name: documents_legal_categories */
create table documents_legal_categories (
dlc_id INT
, dlc_category_type INT
, dlc_category_name VARCHAR (45)
, dlc_category_parent INT
);
/* Id: 5008536 Name: documents_legal_detail */
create table documents_legal_detail (
dld_id INT
, dld_pid INT
, dld_facility INT
, dld_provider INT
, dld_encounter INT
, dld_master_docid INT
, dld_signed INT
, dld_signed_time TIMESTAMP
, dld_filepath VARCHAR (75)
, dld_filename VARCHAR (45)
, dld_signing_person VARCHAR (50)
, dld_sign_level INT
, dld_content VARCHAR (50)
, dld_file_for_pdf_generation MEDIUMBLOB
, dld_denial_reason MEDIUMTEXT
, dld_moved INT
, dld_patient_comments MEDIUMTEXT
);
/* Id: 5008538 Name: documents_legal_master */
create table documents_legal_master (
dlm_category INT
, dlm_subcategory INT
, dlm_document_id INT
, dlm_document_name VARCHAR (75)
, dlm_filepath VARCHAR (75)
, dlm_facility INT
, dlm_provider INT
, dlm_sign_height DECIMAL(38,6)
, dlm_sign_width DECIMAL(38,6)
, dlm_filename VARCHAR (45)
, dlm_effective_date TIMESTAMP
, dlm_version INT
, content VARCHAR (255)
, dlm_savedsign VARCHAR (255)
, dlm_review VARCHAR (255)
, dlm_upload_type INT
);
/* Id: 5008540 Name: drug_inventory */
create table drug_inventory (
inventory_id INT
, drug_id INT
, lot_number VARCHAR (20)
, expiration TIMESTAMP
, manufacturer VARCHAR (255)
, on_hand INT
, warehouse_id VARCHAR (31)
, vendor_id INT
, last_notify TIMESTAMP
, destroy_date TIMESTAMP
, destroy_method VARCHAR (255)
, destroy_witness VARCHAR (255)
, destroy_notes VARCHAR (255)
);
/* Id: 5008542 Name: drug_sales */
create table drug_sales (
sale_id INT
, drug_id INT
, inventory_id INT
, prescription_id INT
, pid INT
, encounter INT
, user VARCHAR (255)
, sale_date TIMESTAMP
, quantity INT
, fee DECIMAL(38,6)
, billed VARCHAR (0)
, xfer_inventory_id INT
, distributor_id INT
, notes VARCHAR (255)
, bill_date TIMESTAMP
, pricelevel VARCHAR (31)
, selector VARCHAR (255)
, trans_type INT
, chargecat VARCHAR (31)
);
/* Id: 5008544 Name: drug_templates */
create table drug_templates (
drug_id INT
, selector VARCHAR (255)
, dosage VARCHAR (10)
, period INT
, quantity INT
, refills INT
, taxrates VARCHAR (255)
, pkgqty DECIMAL(38,6)
);
/* Id: 5008546 Name: drugs */
create table drugs (
drug_id INT
, uuid MEDIUMBLOB
, name VARCHAR (255)
, ndc_number VARCHAR (20)
, on_order INT
, reorder_point DECIMAL(38,6)
, max_level DECIMAL(38,6)
, last_notify TIMESTAMP
, reactions MEDIUMTEXT
, form VARCHAR (31)
, size VARCHAR (25)
, unit VARCHAR (31)
, route VARCHAR (31)
, substitute INT
, related_code VARCHAR (255)
, cyp_factor DECIMAL(38,6)
, active VARCHAR (0)
, allow_combining VARCHAR (0)
, allow_multiple VARCHAR (0)
, drug_code VARCHAR (25)
, consumable VARCHAR (0)
, dispensable VARCHAR (0)
, date_created TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008548 Name: dsi_source_attributes */
create table dsi_source_attributes (
id INT
, client_id VARCHAR (80)
, list_id VARCHAR (100)
, option_id VARCHAR (100)
, clinical_rule_id VARCHAR (31)
, source_value MEDIUMTEXT
, created_by INT
, last_updated_by INT
, created_at TIMESTAMP
, last_updated_at TIMESTAMP
);
/* Id: 5008550 Name: edi_sequences */
create table edi_sequences (
id INT
);
/* Id: 5008552 Name: eligibility_verification */
create table eligibility_verification (
verification_id INT
, response_id VARCHAR (32)
, insurance_id INT
, eligibility_check_date TIMESTAMP
, copay INT
, deductible INT
, deductiblemet VARCHAR (2)
, create_date TIMESTAMP
);
/* Id: 5008554 Name: email_queue */
create table email_queue (
id INT
, sender VARCHAR (255)
, recipient VARCHAR (255)
, subject VARCHAR (255)
, body MEDIUMTEXT
, datetime_queued TIMESTAMP
, sent INT
, datetime_sent TIMESTAMP
, error INT
, error_message MEDIUMTEXT
, datetime_error TIMESTAMP
, template_name VARCHAR (255)
);
/* Id: 5008556 Name: employer_data */
create table employer_data (
id INT
, name VARCHAR (255)
, street VARCHAR (255)
, street_line_2 MEDIUMTEXT
, postal_code VARCHAR (255)
, city VARCHAR (255)
, state VARCHAR (255)
, country VARCHAR (255)
, date TIMESTAMP
, pid INT
);
/* Id: 5008558 Name: enc_category_map */
create table enc_category_map (
rule_enc_id VARCHAR (31)
, main_cat_id INT
);
/* Id: 5008560 Name: erx_narcotics */
create table erx_narcotics (
id INT
, drug VARCHAR (255)
, dea_number VARCHAR (5)
, csa_sch VARCHAR (2)
, narc VARCHAR (2)
, other_names VARCHAR (255)
);
/* Id: 5008562 Name: erx_rx_log */
create table erx_rx_log (
id INT
, prescription_id INT
, date VARCHAR (25)
, time VARCHAR (15)
, code INT
, status MEDIUMTEXT
, message_id VARCHAR (100)
, read INT
);
/* Id: 5008564 Name: erx_ttl_touch */
create table erx_ttl_touch (
patient_id INT
, process VARCHAR (11)
, updated TIMESTAMP
);
/* Id: 5008566 Name: esign_signatures */
create table esign_signatures (
id INT
, tid INT
, table VARCHAR (255)
, uid INT
, datetime TIMESTAMP
, is_lock VARCHAR (0)
, amendment MEDIUMTEXT
, hash VARCHAR (255)
, signature_hash VARCHAR (255)
);
/* Id: 5008568 Name: export_job */
create table export_job (
id INT
, uuid MEDIUMBLOB
, user_id VARCHAR (40)
, client_id VARCHAR (80)
, status VARCHAR (40)
, start_time TIMESTAMP
, resource_include_time TIMESTAMP
, output_format VARCHAR (128)
, request_uri VARCHAR (128)
, resources MEDIUMTEXT
, output MEDIUMTEXT
, errors MEDIUMTEXT
, access_token_id MEDIUMTEXT
);
/* Id: 5008570 Name: extended_log */
create table extended_log (
id INT
, date TIMESTAMP
, event VARCHAR (255)
, user VARCHAR (255)
, recipient VARCHAR (255)
, description MEDIUMTEXT
, patient_id INT
);
/* Id: 5008572 Name: external_encounters */
create table external_encounters (
ee_id INT
, ee_date TIMESTAMP
, ee_pid INT
, ee_provider_id VARCHAR (255)
, ee_facility_id VARCHAR (255)
, ee_encounter_diagnosis VARCHAR (255)
, ee_external_id VARCHAR (255)
);
/* Id: 5008574 Name: external_procedures */
create table external_procedures (
ep_id INT
, ep_date TIMESTAMP
, ep_code_type VARCHAR (20)
, ep_code VARCHAR (9)
, ep_pid INT
, ep_encounter INT
, ep_code_text MEDIUMTEXT
, ep_facility_id VARCHAR (255)
, ep_external_id VARCHAR (255)
);
/* Id: 5008576 Name: facility */
create table facility (
id INT
, uuid MEDIUMBLOB
, name VARCHAR (255)
, phone VARCHAR (30)
, fax VARCHAR (30)
, street VARCHAR (255)
, city VARCHAR (255)
, state VARCHAR (50)
, postal_code VARCHAR (11)
, country_code VARCHAR (30)
, federal_ein VARCHAR (15)
, website VARCHAR (255)
, email VARCHAR (255)
, service_location VARCHAR (0)
, billing_location VARCHAR (0)
, accepts_assignment VARCHAR (0)
, pos_code INT
, x12_sender_id VARCHAR (25)
, attn VARCHAR (65)
, domain_identifier VARCHAR (60)
, facility_npi VARCHAR (15)
, facility_taxonomy VARCHAR (15)
, tax_id_type VARCHAR (31)
, color VARCHAR (7)
, primary_business_entity INT
, facility_code VARCHAR (31)
, extra_validation VARCHAR (0)
, mail_street VARCHAR (30)
, mail_street2 VARCHAR (30)
, mail_city VARCHAR (50)
, mail_state VARCHAR (3)
, mail_zip VARCHAR (10)
, oid VARCHAR (255)
, iban VARCHAR (50)
, info MEDIUMTEXT
, weno_id VARCHAR (10)
, inactive VARCHAR (0)
, date_created TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008578 Name: facility_user_ids */
create table facility_user_ids (
id INT
, uid INT
, facility_id INT
, uuid MEDIUMBLOB
, field_id VARCHAR (31)
, field_value MEDIUMTEXT
, date_created TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008580 Name: fee_schedule */
create table fee_schedule (
id INT
, insurance_company_id INT
, plan VARCHAR (20)
, code VARCHAR (10)
, modifier VARCHAR (2)
, type VARCHAR (20)
, fee DECIMAL(38,6)
, effective_date TIMESTAMP
);
/* Id: 5008582 Name: fee_sheet_options */
create table fee_sheet_options (
fs_category VARCHAR (63)
, fs_option VARCHAR (63)
, fs_codes VARCHAR (255)
);
/* Id: 5008584 Name: form_care_plan */
create table form_care_plan (
id INT
, date TIMESTAMP
, pid INT
, encounter VARCHAR (255)
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, code VARCHAR (255)
, codetext MEDIUMTEXT
, description MEDIUMTEXT
, external_id VARCHAR (30)
, care_plan_type VARCHAR (30)
, note_related_to MEDIUMTEXT
, date_end TIMESTAMP
, reason_code VARCHAR (31)
, reason_description MEDIUMTEXT
, reason_date_low TIMESTAMP
, reason_date_high TIMESTAMP
, reason_status VARCHAR (31)
);
/* Id: 5008586 Name: form_clinical_instructions */
create table form_clinical_instructions (
id INT
, pid INT
, encounter VARCHAR (255)
, user VARCHAR (255)
, instruction MEDIUMTEXT
, date TIMESTAMP
, activity INT
);
/* Id: 5008588 Name: form_clinical_notes */
create table form_clinical_notes (
id INT
, form_id INT
, uuid MEDIUMBLOB
, date TIMESTAMP
, pid INT
, encounter VARCHAR (255)
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, code VARCHAR (255)
, codetext MEDIUMTEXT
, description MEDIUMTEXT
, external_id VARCHAR (30)
, clinical_notes_type VARCHAR (100)
, clinical_notes_category VARCHAR (100)
, note_related_to MEDIUMTEXT
, last_updated TIMESTAMP
);
/* Id: 5008590 Name: form_dictation */
create table form_dictation (
id INT
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, dictation MEDIUMTEXT
, additional_notes MEDIUMTEXT
);
/* Id: 5008592 Name: form_encounter */
create table form_encounter (
id INT
, uuid MEDIUMBLOB
, date TIMESTAMP
, reason MEDIUMTEXT
, facility MEDIUMTEXT
, facility_id INT
, pid INT
, encounter INT
, onset_date TIMESTAMP
, sensitivity VARCHAR (30)
, billing_note MEDIUMTEXT
, pc_catid INT
, last_level_billed INT
, last_level_closed INT
, last_stmt_date TIMESTAMP
, stmt_count INT
, provider_id INT
, supervisor_id INT
, invoice_refno VARCHAR (31)
, referral_source VARCHAR (31)
, billing_facility INT
, external_id VARCHAR (20)
, pos_code INT
, parent_encounter_id INT
, class_code VARCHAR (10)
, shift VARCHAR (31)
, voucher_number VARCHAR (255)
, discharge_disposition VARCHAR (100)
, encounter_type_code VARCHAR (31)
, encounter_type_description MEDIUMTEXT
, referring_provider_id INT
, date_end TIMESTAMP
, in_collection VARCHAR (0)
, last_update TIMESTAMP
, ordering_provider_id INT
);
/* Id: 5008594 Name: form_eye_acuity */
create table form_eye_acuity (
id INT
, pid INT
, SCODVA VARCHAR (25)
, SCOSVA VARCHAR (25)
, PHODVA VARCHAR (25)
, PHOSVA VARCHAR (25)
, CTLODVA VARCHAR (25)
, CTLOSVA VARCHAR (25)
, MRODVA VARCHAR (25)
, MROSVA VARCHAR (25)
, SCNEARODVA VARCHAR (25)
, SCNEAROSVA VARCHAR (25)
, MRNEARODVA VARCHAR (25)
, MRNEAROSVA VARCHAR (25)
, GLAREODVA VARCHAR (25)
, GLAREOSVA VARCHAR (25)
, GLARECOMMENTS VARCHAR (255)
, ARODVA VARCHAR (25)
, AROSVA VARCHAR (25)
, CRODVA VARCHAR (25)
, CROSVA VARCHAR (25)
, CTLODVA1 VARCHAR (25)
, CTLOSVA1 VARCHAR (25)
, PAMODVA VARCHAR (25)
, PAMOSVA VARCHAR (25)
, LIODVA VARCHAR (25)
, LIOSVA VARCHAR (25)
, WODVANEAR VARCHAR (25)
, OSVANEARCC VARCHAR (25)
, BINOCVA VARCHAR (25)
);
/* Id: 5008596 Name: form_eye_antseg */
create table form_eye_antseg (
id INT
, pid INT
, ODSCHIRMER1 VARCHAR (25)
, OSSCHIRMER1 VARCHAR (25)
, ODSCHIRMER2 VARCHAR (25)
, OSSCHIRMER2 VARCHAR (25)
, ODTBUT VARCHAR (25)
, OSTBUT VARCHAR (25)
, OSCONJ VARCHAR (25)
, ODCONJ MEDIUMTEXT
, ODCORNEA MEDIUMTEXT
, OSCORNEA MEDIUMTEXT
, ODAC MEDIUMTEXT
, OSAC MEDIUMTEXT
, ODLENS MEDIUMTEXT
, OSLENS MEDIUMTEXT
, ODIRIS MEDIUMTEXT
, OSIRIS MEDIUMTEXT
, PUPIL_NORMAL VARCHAR (2)
, ODPUPILSIZE1 VARCHAR (25)
, ODPUPILSIZE2 VARCHAR (25)
, ODPUPILREACTIVITY VARCHAR (25)
, ODAPD VARCHAR (25)
, OSPUPILSIZE1 VARCHAR (25)
, OSPUPILSIZE2 VARCHAR (25)
, OSPUPILREACTIVITY VARCHAR (25)
, OSAPD VARCHAR (25)
, DIMODPUPILSIZE1 VARCHAR (25)
, DIMODPUPILSIZE2 VARCHAR (25)
, DIMODPUPILREACTIVITY VARCHAR (25)
, DIMOSPUPILSIZE1 VARCHAR (25)
, DIMOSPUPILSIZE2 VARCHAR (25)
, DIMOSPUPILREACTIVITY VARCHAR (25)
, PUPIL_COMMENTS MEDIUMTEXT
, ODKTHICKNESS VARCHAR (25)
, OSKTHICKNESS VARCHAR (25)
, ODGONIO VARCHAR (25)
, OSGONIO VARCHAR (25)
, ANTSEG_COMMENTS MEDIUMTEXT
);
/* Id: 5008598 Name: form_eye_base */
create table form_eye_base (
id INT
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
);
/* Id: 5008600 Name: form_eye_biometrics */
create table form_eye_biometrics (
id INT
, pid INT
, ODK1 VARCHAR (10)
, ODK2 VARCHAR (10)
, ODK2AXIS VARCHAR (10)
, OSK1 VARCHAR (10)
, OSK2 VARCHAR (10)
, OSK2AXIS VARCHAR (10)
, ODAXIALLENGTH VARCHAR (20)
, OSAXIALLENGTH VARCHAR (20)
, ODPDMeasured VARCHAR (20)
, OSPDMeasured VARCHAR (20)
, ODACD VARCHAR (20)
, OSACD VARCHAR (20)
, ODW2W VARCHAR (20)
, OSW2W VARCHAR (20)
, ODLT VARCHAR (20)
, OSLT VARCHAR (20)
);
/* Id: 5008602 Name: form_eye_external */
create table form_eye_external (
id INT
, pid INT
, RUL MEDIUMTEXT
, LUL MEDIUMTEXT
, RLL MEDIUMTEXT
, LLL MEDIUMTEXT
, RBROW MEDIUMTEXT
, LBROW MEDIUMTEXT
, RMCT MEDIUMTEXT
, LMCT MEDIUMTEXT
, RADNEXA MEDIUMTEXT
, LADNEXA MEDIUMTEXT
, RMRD VARCHAR (25)
, LMRD VARCHAR (25)
, RLF VARCHAR (25)
, LLF VARCHAR (25)
, RVFISSURE VARCHAR (25)
, LVFISSURE VARCHAR (25)
, ODHERTEL VARCHAR (25)
, OSHERTEL VARCHAR (25)
, HERTELBASE VARCHAR (25)
, RCAROTID MEDIUMTEXT
, LCAROTID MEDIUMTEXT
, RTEMPART MEDIUMTEXT
, LTEMPART MEDIUMTEXT
, RCNV MEDIUMTEXT
, LCNV MEDIUMTEXT
, RCNVII MEDIUMTEXT
, LCNVII MEDIUMTEXT
, EXT_COMMENTS MEDIUMTEXT
);
/* Id: 5008604 Name: form_eye_hpi */
create table form_eye_hpi (
id INT
, pid INT
, CC1 VARCHAR (255)
, HPI1 MEDIUMTEXT
, QUALITY1 VARCHAR (255)
, TIMING1 VARCHAR (255)
, DURATION1 VARCHAR (255)
, CONTEXT1 VARCHAR (255)
, SEVERITY1 VARCHAR (255)
, MODIFY1 VARCHAR (255)
, ASSOCIATED1 VARCHAR (255)
, LOCATION1 VARCHAR (255)
, CHRONIC1 VARCHAR (255)
, CHRONIC2 VARCHAR (255)
, CHRONIC3 VARCHAR (255)
, CC2 MEDIUMTEXT
, HPI2 MEDIUMTEXT
, QUALITY2 MEDIUMTEXT
, TIMING2 MEDIUMTEXT
, DURATION2 MEDIUMTEXT
, CONTEXT2 MEDIUMTEXT
, SEVERITY2 MEDIUMTEXT
, MODIFY2 MEDIUMTEXT
, ASSOCIATED2 MEDIUMTEXT
, LOCATION2 MEDIUMTEXT
, CC3 MEDIUMTEXT
, HPI3 MEDIUMTEXT
, QUALITY3 MEDIUMTEXT
, TIMING3 MEDIUMTEXT
, DURATION3 MEDIUMTEXT
, CONTEXT3 MEDIUMTEXT
, SEVERITY3 MEDIUMTEXT
, MODIFY3 MEDIUMTEXT
, ASSOCIATED3 MEDIUMTEXT
, LOCATION3 MEDIUMTEXT
);
/* Id: 5008606 Name: form_eye_locking */
create table form_eye_locking (
id INT
, pid INT
, IMP MEDIUMTEXT
, PLAN MEDIUMTEXT
, Resource VARCHAR (50)
, Technician VARCHAR (50)
, LOCKED VARCHAR (3)
, LOCKEDDATE TIMESTAMP
, LOCKEDBY VARCHAR (50)
);
/* Id: 5008608 Name: form_eye_mag_dispense */
create table form_eye_mag_dispense (
id INT
, date TIMESTAMP
, encounter INT
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, REFDATE TIMESTAMP
, REFTYPE VARCHAR (10)
, RXTYPE VARCHAR (20)
, ODSPH VARCHAR (10)
, ODCYL VARCHAR (10)
, ODAXIS VARCHAR (10)
, OSSPH VARCHAR (10)
, OSCYL VARCHAR (10)
, OSAXIS VARCHAR (10)
, ODMIDADD VARCHAR (10)
, OSMIDADD VARCHAR (10)
, ODADD VARCHAR (10)
, OSADD VARCHAR (10)
, ODHPD VARCHAR (20)
, ODHBASE VARCHAR (20)
, ODVPD VARCHAR (20)
, ODVBASE VARCHAR (20)
, ODSLABOFF VARCHAR (20)
, ODVERTEXDIST VARCHAR (20)
, OSHPD VARCHAR (20)
, OSHBASE VARCHAR (20)
, OSVPD VARCHAR (20)
, OSVBASE VARCHAR (20)
, OSSLABOFF VARCHAR (20)
, OSVERTEXDIST VARCHAR (20)
, ODMPDD VARCHAR (20)
, ODMPDN VARCHAR (20)
, OSMPDD VARCHAR (20)
, OSMPDN VARCHAR (20)
, BPDD VARCHAR (20)
, BPDN VARCHAR (20)
, LENS_MATERIAL VARCHAR (20)
);
/* Id: 5008610 Name: form_eye_mag_impplan */
create table form_eye_mag_impplan (
id INT
, form_id INT
, pid INT
, title VARCHAR (255)
, code VARCHAR (50)
, codetype VARCHAR (50)
, codedesc VARCHAR (255)
, codetext VARCHAR (255)
, plan VARCHAR (3000)
, PMSFH_link VARCHAR (50)
, IMPPLAN_order INT
);
/* Id: 5008612 Name: form_eye_mag_orders */
create table form_eye_mag_orders (
id INT
, form_id INT
, pid INT
, ORDER_DETAILS VARCHAR (255)
, ORDER_STATUS VARCHAR (50)
, ORDER_PRIORITY VARCHAR (50)
, ORDER_DATE_PLACED TIMESTAMP
, ORDER_PLACED_BYWHOM VARCHAR (50)
, ORDER_DATE_COMPLETED TIMESTAMP
, ORDER_COMPLETED_BYWHOM VARCHAR (50)
);
/* Id: 5008614 Name: form_eye_mag_prefs */
create table form_eye_mag_prefs (
PEZONE VARCHAR (25)
, LOCATION VARCHAR (25)
, LOCATION_text VARCHAR (25)
, id INT
, selection VARCHAR (255)
, ZONE_ORDER INT
, GOVALUE VARCHAR (10)
, ordering INT
, FILL_ACTION VARCHAR (10)
, GORIGHT VARCHAR (50)
, GOLEFT VARCHAR (50)
, UNSPEC VARCHAR (50)
);
/* Id: 5008616 Name: form_eye_mag_wearing */
create table form_eye_mag_wearing (
id INT
, ENCOUNTER INT
, FORM_ID INT
, PID INT
, RX_NUMBER INT
, ODSPH VARCHAR (10)
, ODCYL VARCHAR (10)
, ODAXIS VARCHAR (10)
, OSSPH VARCHAR (10)
, OSCYL VARCHAR (10)
, OSAXIS VARCHAR (10)
, ODMIDADD VARCHAR (10)
, OSMIDADD VARCHAR (10)
, ODADD VARCHAR (10)
, OSADD VARCHAR (10)
, ODVA VARCHAR (10)
, OSVA VARCHAR (10)
, ODNEARVA VARCHAR (10)
, OSNEARVA VARCHAR (10)
, ODHPD VARCHAR (20)
, ODHBASE VARCHAR (20)
, ODVPD VARCHAR (20)
, ODVBASE VARCHAR (20)
, ODSLABOFF VARCHAR (20)
, ODVERTEXDIST VARCHAR (20)
, OSHPD VARCHAR (20)
, OSHBASE VARCHAR (20)
, OSVPD VARCHAR (20)
, OSVBASE VARCHAR (20)
, OSSLABOFF VARCHAR (20)
, OSVERTEXDIST VARCHAR (20)
, ODMPDD VARCHAR (20)
, ODMPDN VARCHAR (20)
, OSMPDD VARCHAR (20)
, OSMPDN VARCHAR (20)
, BPDD VARCHAR (20)
, BPDN VARCHAR (20)
, LENS_MATERIAL VARCHAR (20)
, LENS_TREATMENTS VARCHAR (100)
, RX_TYPE VARCHAR (25)
);
/* Id: 5008618 Name: form_eye_neuro */
create table form_eye_neuro (
id INT
, pid INT
, ACT VARCHAR (3)
, ACT5CCDIST MEDIUMTEXT
, ACT1CCDIST MEDIUMTEXT
, ACT2CCDIST MEDIUMTEXT
, ACT3CCDIST MEDIUMTEXT
, ACT4CCDIST MEDIUMTEXT
, ACT6CCDIST MEDIUMTEXT
, ACT7CCDIST MEDIUMTEXT
, ACT8CCDIST MEDIUMTEXT
, ACT9CCDIST MEDIUMTEXT
, ACT10CCDIST MEDIUMTEXT
, ACT11CCDIST MEDIUMTEXT
, ACT1SCDIST MEDIUMTEXT
, ACT2SCDIST MEDIUMTEXT
, ACT3SCDIST MEDIUMTEXT
, ACT4SCDIST MEDIUMTEXT
, ACT5SCDIST MEDIUMTEXT
, ACT6SCDIST MEDIUMTEXT
, ACT7SCDIST MEDIUMTEXT
, ACT8SCDIST MEDIUMTEXT
, ACT9SCDIST MEDIUMTEXT
, ACT10SCDIST MEDIUMTEXT
, ACT11SCDIST MEDIUMTEXT
, ACT1SCNEAR MEDIUMTEXT
, ACT2SCNEAR MEDIUMTEXT
, ACT3SCNEAR MEDIUMTEXT
, ACT4SCNEAR MEDIUMTEXT
, ACT5CCNEAR MEDIUMTEXT
, ACT6CCNEAR MEDIUMTEXT
, ACT7CCNEAR MEDIUMTEXT
, ACT8CCNEAR MEDIUMTEXT
, ACT9CCNEAR MEDIUMTEXT
, ACT10CCNEAR MEDIUMTEXT
, ACT11CCNEAR MEDIUMTEXT
, ACT5SCNEAR MEDIUMTEXT
, ACT6SCNEAR MEDIUMTEXT
, ACT7SCNEAR MEDIUMTEXT
, ACT8SCNEAR MEDIUMTEXT
);
/* Id: 5008620 Name: form_eye_postseg */
create table form_eye_postseg (
id INT
, pid INT
, ODDISC MEDIUMTEXT
, OSDISC MEDIUMTEXT
, ODCUP MEDIUMTEXT
, OSCUP MEDIUMTEXT
, ODMACULA MEDIUMTEXT
, OSMACULA MEDIUMTEXT
, ODVESSELS MEDIUMTEXT
, OSVESSELS MEDIUMTEXT
, ODVITREOUS MEDIUMTEXT
, OSVITREOUS MEDIUMTEXT
, ODPERIPH MEDIUMTEXT
, OSPERIPH MEDIUMTEXT
, ODCMT MEDIUMTEXT
, OSCMT MEDIUMTEXT
, RETINA_COMMENTS MEDIUMTEXT
, DIL_RISKS VARCHAR (2)
, DIL_MEDS MEDIUMTEXT
, WETTYPE VARCHAR (10)
, ATROPINE VARCHAR (25)
, CYCLOMYDRIL VARCHAR (25)
, TROPICAMIDE VARCHAR (25)
, CYCLOGYL VARCHAR (25)
, NEO25 VARCHAR (25)
);
/* Id: 5008622 Name: form_eye_refraction */
create table form_eye_refraction (
id INT
, pid INT
, MRODSPH VARCHAR (25)
, MRODCYL VARCHAR (25)
, MRODAXIS VARCHAR (25)
, MRODPRISM VARCHAR (25)
, MRODBASE VARCHAR (25)
, MRODADD VARCHAR (25)
, MROSSPH VARCHAR (25)
, MROSCYL VARCHAR (25)
, MROSAXIS VARCHAR (25)
, MROSPRISM VARCHAR (50)
, MROSBASE VARCHAR (50)
, MROSADD VARCHAR (25)
, MRODNEARSPHERE VARCHAR (25)
, MRODNEARCYL VARCHAR (25)
, MRODNEARAXIS VARCHAR (25)
, MRODPRISMNEAR VARCHAR (50)
, MRODBASENEAR VARCHAR (25)
, MROSNEARSHPERE VARCHAR (25)
, MROSNEARCYL VARCHAR (25)
, MROSNEARAXIS VARCHAR (125)
, MROSPRISMNEAR VARCHAR (50)
, MROSBASENEAR VARCHAR (25)
, CRODSPH VARCHAR (25)
, CRODCYL VARCHAR (25)
, CRODAXIS VARCHAR (25)
, CROSSPH VARCHAR (25)
, CROSCYL VARCHAR (25)
, CROSAXIS VARCHAR (25)
, CRCOMMENTS VARCHAR (255)
, BALANCED VARCHAR (2)
, ARODSPH VARCHAR (25)
, ARODCYL VARCHAR (25)
, ARODAXIS VARCHAR (25)
, AROSSPH VARCHAR (25)
, AROSCYL VARCHAR (25)
, AROSAXIS VARCHAR (25)
, ARODADD VARCHAR (25)
, AROSADD VARCHAR (25)
);
/* Id: 5008624 Name: form_eye_ros */
create table form_eye_ros (
id INT
, pid INT
, ROSGENERAL MEDIUMTEXT
, ROSHEENT MEDIUMTEXT
, ROSCV MEDIUMTEXT
, ROSPULM MEDIUMTEXT
, ROSGI MEDIUMTEXT
, ROSGU MEDIUMTEXT
, ROSDERM MEDIUMTEXT
, ROSNEURO MEDIUMTEXT
, ROSPSYCH MEDIUMTEXT
, ROSMUSCULO MEDIUMTEXT
, ROSIMMUNO MEDIUMTEXT
, ROSENDOCRINE MEDIUMTEXT
, ROSCOMMENTS MEDIUMTEXT
);
/* Id: 5008626 Name: form_eye_vitals */
create table form_eye_vitals (
id INT
, pid INT
, alert VARCHAR (3)
, oriented VARCHAR (3)
, confused VARCHAR (3)
, ODIOPAP VARCHAR (10)
, OSIOPAP VARCHAR (10)
, ODIOPTPN VARCHAR (10)
, OSIOPTPN VARCHAR (10)
, ODIOPFTN VARCHAR (10)
, OSIOPFTN VARCHAR (10)
, IOPTIME TIMESTAMP
, ODIOPPOST VARCHAR (10)
, OSIOPPOST VARCHAR (10)
, IOPPOSTTIME TIMESTAMP
, ODIOPTARGET VARCHAR (10)
, OSIOPTARGET VARCHAR (10)
, AMSLEROD INT
, AMSLEROS INT
, ODVF1 VARCHAR (0)
, ODVF2 VARCHAR (0)
, ODVF3 VARCHAR (0)
, ODVF4 VARCHAR (0)
, OSVF1 VARCHAR (0)
, OSVF2 VARCHAR (0)
, OSVF3 VARCHAR (0)
, OSVF4 VARCHAR (0)
);
/* Id: 5008628 Name: form_functional_cognitive_status */
create table form_functional_cognitive_status (
id INT
, date TIMESTAMP
, pid INT
, encounter VARCHAR (255)
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, code VARCHAR (255)
, codetext MEDIUMTEXT
, description MEDIUMTEXT
, external_id VARCHAR (30)
);
/* Id: 5008630 Name: form_group_attendance */
create table form_group_attendance (
id INT
, date TIMESTAMP
, group_id INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, encounter_id INT
, activity INT
);
/* Id: 5008632 Name: form_groups_encounter */
create table form_groups_encounter (
id INT
, date TIMESTAMP
, reason MEDIUMTEXT
, facility MEDIUMTEXT
, facility_id INT
, group_id INT
, encounter INT
, onset_date TIMESTAMP
, sensitivity VARCHAR (30)
, billing_note MEDIUMTEXT
, pc_catid INT
, last_level_billed INT
, last_level_closed INT
, last_stmt_date TIMESTAMP
, stmt_count INT
, provider_id INT
, supervisor_id INT
, invoice_refno VARCHAR (31)
, referral_source VARCHAR (31)
, billing_facility INT
, external_id VARCHAR (20)
, pos_code INT
, counselors VARCHAR (255)
, appt_id INT
);
/* Id: 5008634 Name: form_misc_billing_options */
create table form_misc_billing_options (
id INT
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, employment_related VARCHAR (0)
, auto_accident VARCHAR (0)
, accident_state VARCHAR (2)
, other_accident VARCHAR (0)
, medicaid_referral_code VARCHAR (2)
, epsdt_flag VARCHAR (0)
, provider_qualifier_code VARCHAR (2)
, provider_id INT
, outside_lab VARCHAR (0)
, lab_amount DECIMAL(38,6)
, is_unable_to_work VARCHAR (0)
, onset_date TIMESTAMP
, date_initial_treatment TIMESTAMP
, off_work_from TIMESTAMP
, off_work_to TIMESTAMP
, is_hospitalized VARCHAR (0)
, hospitalization_date_from TIMESTAMP
, hospitalization_date_to TIMESTAMP
, medicaid_resubmission_code VARCHAR (10)
, medicaid_original_reference VARCHAR (15)
, prior_auth_number VARCHAR (20)
, comments VARCHAR (255)
, replacement_claim VARCHAR (0)
, icn_resubmission_number VARCHAR (35)
, box_14_date_qual VARCHAR (3)
, box_15_date_qual VARCHAR (3)
);
/* Id: 5008636 Name: form_observation */
create table form_observation (
id INT
, date TIMESTAMP
, pid INT
, encounter VARCHAR (255)
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, code VARCHAR (255)
, observation VARCHAR (255)
, ob_value VARCHAR (255)
, ob_unit VARCHAR (255)
, description VARCHAR (255)
, code_type VARCHAR (255)
, table_code VARCHAR (255)
, ob_code VARCHAR (64)
, ob_type VARCHAR (64)
, ob_status VARCHAR (32)
, result_status VARCHAR (32)
, ob_reason_status VARCHAR (32)
, ob_reason_code VARCHAR (64)
, ob_reason_text MEDIUMTEXT
, ob_documentationof_table VARCHAR (255)
, ob_documentationof_table_id INT
, date_end TIMESTAMP
);
/* Id: 5008638 Name: form_questionnaire_assessments */
create table form_questionnaire_assessments (
id INT
, date TIMESTAMP
, response_id MEDIUMTEXT
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, copyright MEDIUMTEXT
, form_name VARCHAR (255)
, response_meta MEDIUMTEXT
, questionnaire_id MEDIUMTEXT
, questionnaire MEDIUMTEXT
, questionnaire_response MEDIUMTEXT
, lform MEDIUMTEXT
, lform_response MEDIUMTEXT
);
/* Id: 5008640 Name: form_reviewofs */
create table form_reviewofs (
id INT
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, fever VARCHAR (5)
, chills VARCHAR (5)
, night_sweats VARCHAR (5)
, weight_loss VARCHAR (5)
, poor_appetite VARCHAR (5)
, insomnia VARCHAR (5)
, fatigued VARCHAR (5)
, depressed VARCHAR (5)
, hyperactive VARCHAR (5)
, exposure_to_foreign_countries VARCHAR (5)
, cataracts VARCHAR (5)
, cataract_surgery VARCHAR (5)
, glaucoma VARCHAR (5)
, double_vision VARCHAR (5)
, blurred_vision VARCHAR (5)
, poor_hearing VARCHAR (5)
, headaches VARCHAR (5)
, ringing_in_ears VARCHAR (5)
, bloody_nose VARCHAR (5)
, sinusitis VARCHAR (5)
, sinus_surgery VARCHAR (5)
, dry_mouth VARCHAR (5)
, strep_throat VARCHAR (5)
, tonsillectomy VARCHAR (5)
, swollen_lymph_nodes VARCHAR (5)
, throat_cancer VARCHAR (5)
, throat_cancer_surgery VARCHAR (5)
, heart_attack VARCHAR (5)
, irregular_heart_beat VARCHAR (5)
, chest_pains VARCHAR (5)
, shortness_of_breath VARCHAR (5)
, high_blood_pressure VARCHAR (5)
, heart_failure VARCHAR (5)
);
/* Id: 5008642 Name: form_ros */
create table form_ros (
id INT
, pid INT
, activity INT
, date TIMESTAMP
, weight_change VARCHAR (3)
, weakness VARCHAR (3)
, fatigue VARCHAR (3)
, anorexia VARCHAR (3)
, fever VARCHAR (3)
, chills VARCHAR (3)
, night_sweats VARCHAR (3)
, insomnia VARCHAR (3)
, irritability VARCHAR (3)
, heat_or_cold VARCHAR (3)
, intolerance VARCHAR (3)
, change_in_vision VARCHAR (3)
, glaucoma_history VARCHAR (3)
, eye_pain VARCHAR (3)
, irritation VARCHAR (3)
, redness VARCHAR (3)
, excessive_tearing VARCHAR (3)
, double_vision VARCHAR (3)
, blind_spots VARCHAR (3)
, photophobia VARCHAR (3)
, hearing_loss VARCHAR (3)
, discharge VARCHAR (3)
, pain VARCHAR (3)
, vertigo VARCHAR (3)
, tinnitus VARCHAR (3)
, frequent_colds VARCHAR (3)
, sore_throat VARCHAR (3)
, sinus_problems VARCHAR (3)
, post_nasal_drip VARCHAR (3)
, nosebleed VARCHAR (3)
, snoring VARCHAR (3)
, apnea VARCHAR (3)
, breast_mass VARCHAR (3)
, breast_discharge VARCHAR (3)
, biopsy VARCHAR (3)
, abnormal_mammogram VARCHAR (3)
);
/* Id: 5008644 Name: form_soap */
create table form_soap (
id INT
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, subjective MEDIUMTEXT
, objective MEDIUMTEXT
, assessment MEDIUMTEXT
, plan MEDIUMTEXT
);
/* Id: 5008646 Name: form_taskman */
create table form_taskman (
ID INT
, REQ_DATE TIMESTAMP
, FROM_ID INT
, TO_ID INT
, PATIENT_ID INT
, DOC_TYPE VARCHAR (20)
, DOC_ID INT
, ENC_ID INT
, METHOD VARCHAR (20)
, COMPLETED VARCHAR (1)
, COMPLETED_DATE TIMESTAMP
, COMMENT VARCHAR (50)
, USERFIELD_1 VARCHAR (50)
);
/* Id: 5008648 Name: form_vital_details */
create table form_vital_details (
id INT
, form_id INT
, vitals_column VARCHAR (64)
, interpretation_list_id VARCHAR (100)
, interpretation_option_id VARCHAR (100)
, interpretation_codes VARCHAR (255)
, interpretation_title VARCHAR (255)
, reason_code VARCHAR (31)
, reason_description MEDIUMTEXT
, reason_status VARCHAR (31)
);
/* Id: 5008650 Name: form_vitals */
create table form_vitals (
id INT
, uuid MEDIUMBLOB
, date TIMESTAMP
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, activity INT
, bps VARCHAR (40)
, bpd VARCHAR (40)
, weight DECIMAL(38,6)
, height DECIMAL(38,6)
, temperature DECIMAL(38,6)
, temp_method VARCHAR (255)
, pulse DECIMAL(38,6)
, respiration DECIMAL(38,6)
, note VARCHAR (255)
, BMI DECIMAL(38,6)
, BMI_status VARCHAR (255)
, waist_circ DECIMAL(38,6)
, head_circ DECIMAL(38,6)
, oxygen_saturation DECIMAL(38,6)
, oxygen_flow_rate DECIMAL(38,6)
, external_id VARCHAR (20)
, ped_weight_height DECIMAL(38,6)
, ped_bmi DECIMAL(38,6)
, ped_head_circ DECIMAL(38,6)
, inhaled_oxygen_concentration DECIMAL(38,6)
, last_updated TIMESTAMP
);
/* Id: 5008652 Name: forms */
create table forms (
id INT
, date TIMESTAMP
, encounter INT
, form_name MEDIUMTEXT
, form_id INT
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
, deleted INT
, formdir MEDIUMTEXT
, therapy_group_id INT
, issue_id INT
, provider_id INT
);
/* Id: 5008654 Name: gacl_acl */
create table gacl_acl (
id INT
, section_value VARCHAR (150)
, allow INT
, enabled INT
, return_value MEDIUMTEXT
, note MEDIUMTEXT
, updated_date INT
);
/* Id: 5008656 Name: gacl_acl_sections */
create table gacl_acl_sections (
id INT
, value VARCHAR (150)
, order_value INT
, name VARCHAR (230)
, hidden INT
);
/* Id: 5008658 Name: gacl_acl_seq */
create table gacl_acl_seq (
id INT
);
/* Id: 5008660 Name: gacl_aco */
create table gacl_aco (
id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
, order_value INT
, name VARCHAR (255)
, hidden INT
);
/* Id: 5008662 Name: gacl_aco_map */
create table gacl_aco_map (
acl_id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
);
/* Id: 5008664 Name: gacl_aco_sections */
create table gacl_aco_sections (
id INT
, value VARCHAR (150)
, order_value INT
, name VARCHAR (230)
, hidden INT
);
/* Id: 5008666 Name: gacl_aco_sections_seq */
create table gacl_aco_sections_seq (
id INT
);
/* Id: 5008668 Name: gacl_aco_seq */
create table gacl_aco_seq (
id INT
);
/* Id: 5008670 Name: gacl_aro */
create table gacl_aro (
id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
, order_value INT
, name VARCHAR (255)
, hidden INT
);
/* Id: 5008672 Name: gacl_aro_groups */
create table gacl_aro_groups (
id INT
, parent_id INT
, lft INT
, rgt INT
, name VARCHAR (255)
, value VARCHAR (150)
);
/* Id: 5008674 Name: gacl_aro_groups_id_seq */
create table gacl_aro_groups_id_seq (
id INT
);
/* Id: 5008676 Name: gacl_aro_groups_map */
create table gacl_aro_groups_map (
acl_id INT
, group_id INT
);
/* Id: 5008678 Name: gacl_aro_map */
create table gacl_aro_map (
acl_id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
);
/* Id: 5008680 Name: gacl_aro_sections */
create table gacl_aro_sections (
id INT
, value VARCHAR (150)
, order_value INT
, name VARCHAR (230)
, hidden INT
);
/* Id: 5008682 Name: gacl_aro_sections_seq */
create table gacl_aro_sections_seq (
id INT
);
/* Id: 5008684 Name: gacl_aro_seq */
create table gacl_aro_seq (
id INT
);
/* Id: 5008686 Name: gacl_axo */
create table gacl_axo (
id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
, order_value INT
, name VARCHAR (255)
, hidden INT
);
/* Id: 5008688 Name: gacl_axo_groups */
create table gacl_axo_groups (
id INT
, parent_id INT
, lft INT
, rgt INT
, name VARCHAR (255)
, value VARCHAR (150)
);
/* Id: 5008690 Name: gacl_axo_groups_map */
create table gacl_axo_groups_map (
acl_id INT
, group_id INT
);
/* Id: 5008692 Name: gacl_axo_map */
create table gacl_axo_map (
acl_id INT
, section_value VARCHAR (150)
, value VARCHAR (150)
);
/* Id: 5008694 Name: gacl_axo_sections */
create table gacl_axo_sections (
id INT
, value VARCHAR (150)
, order_value INT
, name VARCHAR (230)
, hidden INT
);
/* Id: 5008696 Name: gacl_groups_aro_map */
create table gacl_groups_aro_map (
group_id INT
, aro_id INT
);
/* Id: 5008698 Name: gacl_groups_axo_map */
create table gacl_groups_axo_map (
group_id INT
, axo_id INT
);
/* Id: 5008700 Name: gacl_phpgacl */
create table gacl_phpgacl (
name VARCHAR (230)
, value VARCHAR (150)
);
/* Id: 5008702 Name: globals */
create table globals (
gl_name VARCHAR (63)
, gl_index INT
, gl_value VARCHAR (255)
);
/* Id: 5008704 Name: gprelations */
create table gprelations (
type1 INT
, id1 INT
, type2 INT
, id2 INT
);
/* Id: 5008706 Name: groups */
create table groups (
id INT
, name MEDIUMTEXT
, user MEDIUMTEXT
);
/* Id: 5008708 Name: history_data */
create table history_data (
id INT
, uuid MEDIUMBLOB
, coffee MEDIUMTEXT
, tobacco MEDIUMTEXT
, alcohol MEDIUMTEXT
, sleep_patterns MEDIUMTEXT
, exercise_patterns MEDIUMTEXT
, seatbelt_use MEDIUMTEXT
, counseling MEDIUMTEXT
, hazardous_activities MEDIUMTEXT
, recreational_drugs MEDIUMTEXT
, last_breast_exam VARCHAR (255)
, last_mammogram VARCHAR (255)
, last_gynocological_exam VARCHAR (255)
, last_rectal_exam VARCHAR (255)
, last_prostate_exam VARCHAR (255)
, last_physical_exam VARCHAR (255)
, last_sigmoidoscopy_colonoscopy VARCHAR (255)
, last_ecg VARCHAR (255)
, last_cardiac_echo VARCHAR (255)
, last_retinal VARCHAR (255)
, last_fluvax VARCHAR (255)
, last_pneuvax VARCHAR (255)
, last_ldl VARCHAR (255)
, last_hemoglobin VARCHAR (255)
, last_psa VARCHAR (255)
, last_exam_results VARCHAR (255)
, history_mother MEDIUMTEXT
, dc_mother MEDIUMTEXT
, history_father MEDIUMTEXT
, dc_father MEDIUMTEXT
, history_siblings MEDIUMTEXT
, dc_siblings MEDIUMTEXT
, history_offspring MEDIUMTEXT
, dc_offspring MEDIUMTEXT
, history_spouse MEDIUMTEXT
, dc_spouse MEDIUMTEXT
, relatives_cancer MEDIUMTEXT
, relatives_tuberculosis MEDIUMTEXT
, relatives_diabetes MEDIUMTEXT
);
/* Id: 5008710 Name: icd10_dx_order_code */
create table icd10_dx_order_code (
dx_id INT
, dx_code VARCHAR (7)
, formatted_dx_code VARCHAR (10)
, valid_for_coding VARCHAR (1)
, short_desc VARCHAR (60)
, long_desc MEDIUMTEXT
, active INT
, revision INT
);
/* Id: 5008712 Name: icd10_gem_dx_10_9 */
create table icd10_gem_dx_10_9 (
map_id INT
, dx_icd10_source VARCHAR (7)
, dx_icd9_target VARCHAR (5)
, flags VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008714 Name: icd10_gem_dx_9_10 */
create table icd10_gem_dx_9_10 (
map_id INT
, dx_icd9_source VARCHAR (5)
, dx_icd10_target VARCHAR (7)
, flags VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008716 Name: icd10_gem_pcs_10_9 */
create table icd10_gem_pcs_10_9 (
map_id INT
, pcs_icd10_source VARCHAR (7)
, pcs_icd9_target VARCHAR (5)
, flags VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008718 Name: icd10_gem_pcs_9_10 */
create table icd10_gem_pcs_9_10 (
map_id INT
, pcs_icd9_source VARCHAR (5)
, pcs_icd10_target VARCHAR (7)
, flags VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008720 Name: icd10_pcs_order_code */
create table icd10_pcs_order_code (
pcs_id INT
, pcs_code VARCHAR (7)
, valid_for_coding VARCHAR (1)
, short_desc VARCHAR (60)
, long_desc MEDIUMTEXT
, active INT
, revision INT
);
/* Id: 5008722 Name: icd10_reimbr_dx_9_10 */
create table icd10_reimbr_dx_9_10 (
map_id INT
, code VARCHAR (8)
, code_cnt INT
, ICD9_01 VARCHAR (5)
, ICD9_02 VARCHAR (5)
, ICD9_03 VARCHAR (5)
, ICD9_04 VARCHAR (5)
, ICD9_05 VARCHAR (5)
, ICD9_06 VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008724 Name: icd10_reimbr_pcs_9_10 */
create table icd10_reimbr_pcs_9_10 (
map_id INT
, code VARCHAR (8)
, code_cnt INT
, ICD9_01 VARCHAR (5)
, ICD9_02 VARCHAR (5)
, ICD9_03 VARCHAR (5)
, ICD9_04 VARCHAR (5)
, ICD9_05 VARCHAR (5)
, ICD9_06 VARCHAR (5)
, active INT
, revision INT
);
/* Id: 5008726 Name: icd9_dx_code */
create table icd9_dx_code (
dx_id INT
, dx_code VARCHAR (5)
, formatted_dx_code VARCHAR (6)
, short_desc VARCHAR (60)
, long_desc VARCHAR (300)
, active INT
, revision INT
);
/* Id: 5008728 Name: icd9_dx_long_code */
create table icd9_dx_long_code (
dx_id INT
, dx_code VARCHAR (5)
, long_desc VARCHAR (300)
, active INT
, revision INT
);
/* Id: 5008730 Name: icd9_sg_code */
create table icd9_sg_code (
sg_id INT
, sg_code VARCHAR (5)
, formatted_sg_code VARCHAR (6)
, short_desc VARCHAR (60)
, long_desc VARCHAR (300)
, active INT
, revision INT
);
/* Id: 5008732 Name: icd9_sg_long_code */
create table icd9_sg_long_code (
sq_id INT
, sg_code VARCHAR (5)
, long_desc VARCHAR (300)
, active INT
, revision INT
);
/* Id: 5008734 Name: immunization_observation */
create table immunization_observation (
imo_id INT
, imo_im_id INT
, imo_pid INT
, imo_criteria VARCHAR (255)
, imo_criteria_value VARCHAR (255)
, imo_user INT
, imo_code VARCHAR (255)
, imo_codetext VARCHAR (255)
, imo_codetype VARCHAR (255)
, imo_vis_date_published TIMESTAMP
, imo_vis_date_presented TIMESTAMP
, imo_date_observation TIMESTAMP
);
/* Id: 5008736 Name: immunizations */
create table immunizations (
id INT
, uuid MEDIUMBLOB
, patient_id INT
, administered_date TIMESTAMP
, immunization_id INT
, cvx_code VARCHAR (64)
, manufacturer VARCHAR (100)
, lot_number VARCHAR (50)
, administered_by_id INT
, administered_by VARCHAR (255)
, education_date TIMESTAMP
, vis_date TIMESTAMP
, note MEDIUMTEXT
, create_date TIMESTAMP
, update_date TIMESTAMP
, created_by INT
, updated_by INT
, amount_administered DECIMAL(38,6)
, amount_administered_unit VARCHAR (50)
, expiration_date TIMESTAMP
, route VARCHAR (100)
, administration_site VARCHAR (100)
, added_erroneously VARCHAR (0)
, external_id VARCHAR (20)
, completion_status VARCHAR (50)
, information_source VARCHAR (31)
, refusal_reason VARCHAR (31)
, ordering_provider INT
, reason_code VARCHAR (31)
, reason_description MEDIUMTEXT
);
/* Id: 5008738 Name: insurance_companies */
create table insurance_companies (
id INT
, uuid MEDIUMBLOB
, name VARCHAR (255)
, attn VARCHAR (255)
, cms_id VARCHAR (15)
, ins_type_code INT
, x12_receiver_id VARCHAR (25)
, x12_default_partner_id INT
, alt_cms_id VARCHAR (15)
, inactive VARCHAR (0)
, eligibility_id VARCHAR (32)
, x12_default_eligibility_id INT
, cqm_sop INT
, date_created TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008740 Name: insurance_data */
create table insurance_data (
id INT
, uuid MEDIUMBLOB
, type VARCHAR (9)
, provider VARCHAR (255)
, plan_name VARCHAR (255)
, policy_number VARCHAR (255)
, group_number VARCHAR (255)
, subscriber_lname VARCHAR (255)
, subscriber_mname VARCHAR (255)
, subscriber_fname VARCHAR (255)
, subscriber_relationship VARCHAR (255)
, subscriber_ss VARCHAR (255)
, subscriber_DOB TIMESTAMP
, subscriber_street VARCHAR (255)
, subscriber_postal_code VARCHAR (255)
, subscriber_city VARCHAR (255)
, subscriber_state VARCHAR (255)
, subscriber_country VARCHAR (255)
, subscriber_phone VARCHAR (255)
, subscriber_employer VARCHAR (255)
, subscriber_employer_street VARCHAR (255)
, subscriber_employer_postal_code VARCHAR (255)
, subscriber_employer_state VARCHAR (255)
, subscriber_employer_country VARCHAR (255)
, subscriber_employer_city VARCHAR (255)
, copay VARCHAR (255)
, date TIMESTAMP
, pid INT
, subscriber_sex VARCHAR (25)
, accept_assignment VARCHAR (5)
, policy_type VARCHAR (25)
, subscriber_street_line_2 MEDIUMTEXT
, subscriber_employer_street_line_ MEDIUMTEXT
, date_end TIMESTAMP
);
/* Id: 5008742 Name: insurance_numbers */
create table insurance_numbers (
id INT
, provider_id INT
, insurance_company_id INT
, provider_number VARCHAR (20)
, rendering_provider_number VARCHAR (20)
, group_number VARCHAR (20)
, provider_number_type VARCHAR (4)
, rendering_provider_number_type VARCHAR (4)
);
/* Id: 5008744 Name: insurance_type_codes */
create table insurance_type_codes (
id INT
, type VARCHAR (60)
, claim_type MEDIUMTEXT
);
/* Id: 5008746 Name: ip_tracking */
create table ip_tracking (
id INT
, ip_string VARCHAR (255)
, total_ip_login_fail_counter INT
, ip_login_fail_counter INT
, ip_last_login_fail TIMESTAMP
, ip_auto_block_emailed INT
, ip_force_block INT
, ip_no_prevent_timing_attack INT
);
/* Id: 5008748 Name: issue_encounter */
create table issue_encounter (
pid INT
, list_id INT
, encounter INT
, resolved VARCHAR (0)
);
/* Id: 5008750 Name: issue_types */
create table issue_types (
active VARCHAR (0)
, category VARCHAR (75)
, type VARCHAR (75)
, plural VARCHAR (75)
, singular VARCHAR (75)
, abbreviation VARCHAR (75)
, style INT
, force_show INT
, ordering INT
, aco_spec VARCHAR (63)
);
/* Id: 5008752 Name: jwt_grant_history */
create table jwt_grant_history (
id INT
, jti VARCHAR (100)
, client_id VARCHAR (80)
, jti_exp TIMESTAMP
, creation_date TIMESTAMP
);
/* Id: 5008754 Name: keys */
create table keys (
id INT
, name VARCHAR (20)
, value MEDIUMTEXT
);
/* Id: 5008756 Name: lang_constants */
create table lang_constants (
cons_id INT
, constant_name MEDIUMTEXT
);
/* Id: 5008758 Name: lang_custom */
create table lang_custom (
lang_description VARCHAR (100)
, lang_code VARCHAR (2)
, constant_name MEDIUMTEXT
, definition MEDIUMTEXT
);
/* Id: 5008760 Name: lang_definitions */
create table lang_definitions (
def_id INT
, cons_id INT
, lang_id INT
, definition MEDIUMTEXT
);
/* Id: 5008762 Name: lang_languages */
create table lang_languages (
lang_id INT
, lang_code VARCHAR (2)
, lang_description VARCHAR (100)
, lang_is_rtl INT
);
/* Id: 5008764 Name: layout_group_properties */
create table layout_group_properties (
grp_form_id VARCHAR (31)
, grp_group_id VARCHAR (31)
, grp_title VARCHAR (63)
, grp_subtitle VARCHAR (63)
, grp_mapping VARCHAR (31)
, grp_seq INT
, grp_activity VARCHAR (0)
, grp_repeats INT
, grp_columns INT
, grp_size INT
, grp_issue_type VARCHAR (75)
, grp_aco_spec VARCHAR (63)
, grp_save_close VARCHAR (0)
, grp_init_open VARCHAR (0)
, grp_referrals VARCHAR (0)
, grp_unchecked VARCHAR (0)
, grp_services VARCHAR (4095)
, grp_products VARCHAR (4095)
, grp_diags VARCHAR (4095)
, grp_last_update TIMESTAMP
);
/* Id: 5008766 Name: layout_options */
create table layout_options (
form_id VARCHAR (31)
, field_id VARCHAR (31)
, group_id VARCHAR (31)
, title MEDIUMTEXT
, seq INT
, data_type INT
, uor VARCHAR (0)
, fld_length INT
, max_length INT
, list_id VARCHAR (100)
, titlecols INT
, datacols INT
, default_value VARCHAR (255)
, edit_options VARCHAR (36)
, description MEDIUMTEXT
, fld_rows INT
, list_backup_id VARCHAR (100)
, source VARCHAR (1)
, conditions MEDIUMTEXT
, validation VARCHAR (100)
, codes VARCHAR (255)
);
/* Id: 5008768 Name: lbf_data */
create table lbf_data (
form_id INT
, field_id VARCHAR (31)
, field_value MEDIUMTEXT
);
/* Id: 5008770 Name: lbt_data */
create table lbt_data (
form_id INT
, field_id VARCHAR (31)
, field_value MEDIUMTEXT
);
/* Id: 5008772 Name: list_options */
create table list_options (
list_id VARCHAR (100)
, option_id VARCHAR (100)
, title VARCHAR (255)
, seq INT
, is_default VARCHAR (0)
, option_value DECIMAL(38,6)
, mapping VARCHAR (31)
, notes MEDIUMTEXT
, codes VARCHAR (255)
, toggle_setting_1 VARCHAR (0)
, toggle_setting_2 VARCHAR (0)
, activity INT
, subtype VARCHAR (31)
, edit_options VARCHAR (0)
, timestamp TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008774 Name: lists */
create table lists (
id INT
, uuid MEDIUMBLOB
, date TIMESTAMP
, type VARCHAR (255)
, subtype VARCHAR (31)
, title VARCHAR (255)
, udi VARCHAR (255)
, udi_data MEDIUMTEXT
, begdate TIMESTAMP
, enddate TIMESTAMP
, returndate TIMESTAMP
, occurrence INT
, classification INT
, referredby VARCHAR (255)
, extrainfo VARCHAR (255)
, diagnosis VARCHAR (255)
, activity INT
, comments MEDIUMTEXT
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, outcome INT
, destination VARCHAR (255)
, reinjury_id INT
, injury_part VARCHAR (31)
, injury_type VARCHAR (31)
, injury_grade VARCHAR (31)
, reaction VARCHAR (255)
, verification VARCHAR (36)
, external_allergyid INT
, erx_source VARCHAR (2)
, erx_uploaded VARCHAR (2)
, modifydate TIMESTAMP
, severity_al VARCHAR (50)
, external_id VARCHAR (20)
, list_option_id VARCHAR (100)
);
/* Id: 5008776 Name: lists_medication */
create table lists_medication (
id INT
, list_id INT
, drug_dosage_instructions MEDIUMTEXT
, usage_category VARCHAR (100)
, usage_category_title VARCHAR (255)
, request_intent VARCHAR (100)
, request_intent_title VARCHAR (255)
);
/* Id: 5008778 Name: lists_touch */
create table lists_touch (
pid INT
, type VARCHAR (255)
, date TIMESTAMP
);
/* Id: 5008780 Name: log */
create table log (
id INT
, date TIMESTAMP
, event VARCHAR (255)
, category VARCHAR (255)
, user VARCHAR (255)
, groupname VARCHAR (255)
, comments MEDIUMTEXT
, user_notes MEDIUMTEXT
, patient_id INT
, success VARCHAR (0)
, checksum MEDIUMTEXT
, crt_user VARCHAR (255)
, log_from VARCHAR (20)
, menu_item_id INT
, ccda_doc_id INT
);
/* Id: 5008782 Name: log_comment_encrypt */
create table log_comment_encrypt (
id INT
, log_id INT
, encrypt VARCHAR (4)
, checksum MEDIUMTEXT
, checksum_api MEDIUMTEXT
, version INT
);
/* Id: 5008784 Name: login_mfa_registrations */
create table login_mfa_registrations (
user_id INT
, name VARCHAR (30)
, last_challenge TIMESTAMP
, method VARCHAR (31)
, var1 VARCHAR (4096)
, var2 VARCHAR (256)
);
/* Id: 5008786 Name: medex_icons */
create table medex_icons (
i_UID INT
, msg_type VARCHAR (50)
, msg_status VARCHAR (10)
, i_description VARCHAR (255)
, i_html MEDIUMTEXT
, i_blob MEDIUMTEXT
);
/* Id: 5008788 Name: medex_outgoing */
create table medex_outgoing (
msg_uid INT
, msg_pid INT
, msg_pc_eid VARCHAR (11)
, campaign_uid INT
, msg_date TIMESTAMP
, msg_type VARCHAR (50)
, msg_reply VARCHAR (50)
, msg_extra_text MEDIUMTEXT
, medex_uid INT
);
/* Id: 5008790 Name: medex_prefs */
create table medex_prefs (
MedEx_id INT
, ME_username VARCHAR (100)
, ME_api_key MEDIUMTEXT
, ME_facilities VARCHAR (50)
, ME_providers VARCHAR (100)
, ME_hipaa_default_override VARCHAR (3)
, PHONE_country_code INT
, MSGS_default_yes VARCHAR (3)
, POSTCARDS_local VARCHAR (3)
, POSTCARDS_remote VARCHAR (3)
, LABELS_local VARCHAR (3)
, LABELS_choice VARCHAR (50)
, combine_time INT
, postcard_top VARCHAR (255)
, status MEDIUMTEXT
, MedEx_lastupdated TIMESTAMP
);
/* Id: 5008792 Name: medex_recalls */
create table medex_recalls (
r_ID INT
, r_PRACTID INT
, r_pid INT
, r_eventDate TIMESTAMP
, r_facility INT
, r_provider INT
, r_reason VARCHAR (255)
, r_created TIMESTAMP
);
/* Id: 5008794 Name: misc_address_book */
create table misc_address_book (
id INT
, fname VARCHAR (255)
, mname VARCHAR (255)
, lname VARCHAR (255)
, street VARCHAR (60)
, city VARCHAR (30)
, state VARCHAR (30)
, zip VARCHAR (20)
, phone VARCHAR (30)
);
/* Id: 5008796 Name: module_acl_group_settings */
create table module_acl_group_settings (
module_id INT
, group_id INT
, section_id INT
, allowed VARCHAR (0)
);
/* Id: 5008798 Name: module_acl_sections */
create table module_acl_sections (
section_id INT
, section_name VARCHAR (255)
, parent_section INT
, section_identifier VARCHAR (50)
, module_id INT
);
/* Id: 5008800 Name: module_acl_user_settings */
create table module_acl_user_settings (
module_id INT
, user_id INT
, section_id INT
, allowed INT
);
/* Id: 5008802 Name: module_configuration */
create table module_configuration (
module_config_id INT
, module_id INT
, field_name VARCHAR (45)
, field_value VARCHAR (255)
, created_by INT
, date_added TIMESTAMP
, updated_by INT
, date_modified TIMESTAMP
, date_created TIMESTAMP
);
/* Id: 5008804 Name: modules */
create table modules (
mod_id INT
, mod_name VARCHAR (64)
, mod_directory VARCHAR (64)
, mod_parent VARCHAR (64)
, mod_type VARCHAR (64)
, mod_active INT
, mod_ui_name VARCHAR (64)
, mod_relative_link VARCHAR (64)
, mod_ui_order INT
, mod_ui_active INT
, mod_description VARCHAR (255)
, mod_nick_name VARCHAR (25)
, mod_enc_menu VARCHAR (10)
, permissions_item_table VARCHAR (100)
, directory VARCHAR (255)
, date TIMESTAMP
, sql_run INT
, type INT
, sql_version VARCHAR (150)
, acl_version VARCHAR (150)
);
/* Id: 5008806 Name: modules_hooks_settings */
create table modules_hooks_settings (
id INT
, mod_id INT
, enabled_hooks VARCHAR (255)
, attached_to VARCHAR (45)
);
/* Id: 5008808 Name: modules_settings */
create table modules_settings (
mod_id INT
, fld_type INT
, obj_name VARCHAR (255)
, menu_name VARCHAR (255)
, path VARCHAR (255)
);
/* Id: 5008810 Name: multiple_db */
create table multiple_db (
id INT
, namespace VARCHAR (255)
, username VARCHAR (255)
, password MEDIUMTEXT
, dbname VARCHAR (255)
, host VARCHAR (255)
, port INT
, date TIMESTAMP
);
/* Id: 5008812 Name: notes */
create table notes (
id INT
, foreign_id INT
, note VARCHAR (255)
, owner INT
, date TIMESTAMP
, revision TIMESTAMP
);
/* Id: 5008814 Name: notification_log */
create table notification_log (
iLogId INT
, pid INT
, pc_eid INT
, sms_gateway_type VARCHAR (50)
, smsgateway_info VARCHAR (255)
, message MEDIUMTEXT
, email_sender VARCHAR (255)
, email_subject VARCHAR (255)
, type VARCHAR (5)
, patient_info MEDIUMTEXT
, pc_eventDate TIMESTAMP
, pc_endDate TIMESTAMP
, pc_startTime TIMESTAMP
, pc_endTime TIMESTAMP
, dSentDateTime TIMESTAMP
);
/* Id: 5008816 Name: notification_settings */
create table notification_settings (
SettingsId INT
, Send_SMS_Before_Hours INT
, Send_Email_Before_Hours INT
, SMS_gateway_username VARCHAR (100)
, SMS_gateway_password VARCHAR (100)
, SMS_gateway_apikey VARCHAR (100)
, type VARCHAR (50)
);
/* Id: 5008818 Name: oauth_clients */
create table oauth_clients (
client_id VARCHAR (80)
, client_role VARCHAR (20)
, client_name VARCHAR (80)
, client_secret MEDIUMTEXT
, registration_token VARCHAR (80)
, registration_uri_path VARCHAR (40)
, register_date TIMESTAMP
, revoke_date TIMESTAMP
, contacts MEDIUMTEXT
, redirect_uri MEDIUMTEXT
, grant_types VARCHAR (80)
, scope MEDIUMTEXT
, user_id VARCHAR (40)
, site_id VARCHAR (64)
, is_confidential VARCHAR (0)
, logout_redirect_uris MEDIUMTEXT
, jwks_uri MEDIUMTEXT
, jwks MEDIUMTEXT
, initiate_login_uri MEDIUMTEXT
, endorsements MEDIUMTEXT
, policy_uri MEDIUMTEXT
, tos_uri MEDIUMTEXT
, is_enabled VARCHAR (0)
, skip_ehr_launch_authorization_fl VARCHAR (0)
, dsi_type INT
);
/* Id: 5008820 Name: oauth_trusted_user */
create table oauth_trusted_user (
id INT
, user_id VARCHAR (80)
, client_id VARCHAR (80)
, scope MEDIUMTEXT
, persist_login VARCHAR (0)
, time TIMESTAMP
, code MEDIUMTEXT
, session_cache MEDIUMTEXT
, grant_type VARCHAR (32)
);
/* Id: 5008822 Name: onetime_auth */
create table onetime_auth (
id INT
, pid INT
, create_user_id INT
, context VARCHAR (64)
, access_count INT
, remote_ip VARCHAR (32)
, onetime_pin VARCHAR (10)
, onetime_token MEDIUMTEXT
, redirect_url MEDIUMTEXT
, expires INT
, date_created TIMESTAMP
, last_accessed TIMESTAMP
, scope MEDIUMTEXT
, profile MEDIUMTEXT
, onetime_actions MEDIUMTEXT
);
/* Id: 5008824 Name: onotes */
create table onotes (
id INT
, date TIMESTAMP
, body MEDIUMTEXT
, user VARCHAR (255)
, groupname VARCHAR (255)
, activity INT
);
/* Id: 5008826 Name: onsite_documents */
create table onsite_documents (
id INT
, pid INT
, facility INT
, provider INT
, encounter INT
, create_date TIMESTAMP
, doc_type VARCHAR (255)
, patient_signed_status INT
, patient_signed_time TIMESTAMP
, authorize_signed_time TIMESTAMP
, accept_signed_status INT
, authorizing_signator VARCHAR (50)
, review_date TIMESTAMP
, denial_reason VARCHAR (255)
, authorized_signature MEDIUMTEXT
, patient_signature MEDIUMTEXT
, full_document MEDIUMBLOB
, file_name VARCHAR (255)
, file_path VARCHAR (255)
, template_data MEDIUMTEXT
);
/* Id: 5008828 Name: onsite_mail */
create table onsite_mail (
id INT
, date TIMESTAMP
, owner VARCHAR (128)
, user VARCHAR (255)
, groupname VARCHAR (255)
, activity INT
, authorized INT
, header VARCHAR (255)
, title VARCHAR (255)
, body MEDIUMTEXT
, recipient_id VARCHAR (128)
, recipient_name VARCHAR (255)
, sender_id VARCHAR (128)
, sender_name VARCHAR (255)
, assigned_to VARCHAR (255)
, deleted INT
, delete_date TIMESTAMP
, mtype VARCHAR (128)
, message_status VARCHAR (20)
, mail_chain INT
, reply_mail_chain INT
, is_msg_encrypted INT
);
/* Id: 5008830 Name: onsite_messages */
create table onsite_messages (
id INT
, username VARCHAR (64)
, message MEDIUMTEXT
, ip VARCHAR (15)
, date TIMESTAMP
, sender_id VARCHAR (64)
, recip_id VARCHAR (255)
);
/* Id: 5008832 Name: onsite_online */
create table onsite_online (
hash VARCHAR (32)
, ip VARCHAR (15)
, last_update TIMESTAMP
, username VARCHAR (64)
, userid INT
);
/* Id: 5008834 Name: onsite_portal_activity */
create table onsite_portal_activity (
id INT
, date TIMESTAMP
, patient_id INT
, activity VARCHAR (255)
, require_audit VARCHAR (0)
, pending_action VARCHAR (255)
, action_taken VARCHAR (255)
, status VARCHAR (255)
, narrative MEDIUMTEXT
, table_action MEDIUMTEXT
, table_args MEDIUMTEXT
, action_user INT
, action_taken_time TIMESTAMP
, checksum MEDIUMTEXT
);
/* Id: 5008836 Name: onsite_signatures */
create table onsite_signatures (
id INT
, status VARCHAR (128)
, type VARCHAR (128)
, created INT
, lastmod TIMESTAMP
, pid INT
, encounter INT
, user VARCHAR (255)
, activity INT
, authorized INT
, signator VARCHAR (255)
, sig_image MEDIUMTEXT
, signature MEDIUMTEXT
, sig_hash VARCHAR (255)
, ip VARCHAR (46)
);
/* Id: 5008838 Name: openemr_module_vars */
create table openemr_module_vars (
pn_id INT
, pn_modname VARCHAR (64)
, pn_name VARCHAR (64)
, pn_value MEDIUMTEXT
);
/* Id: 5008840 Name: openemr_modules */
create table openemr_modules (
pn_id INT
, pn_name VARCHAR (64)
, pn_type INT
, pn_displayname VARCHAR (64)
, pn_description VARCHAR (255)
, pn_regid INT
, pn_directory VARCHAR (64)
, pn_version VARCHAR (10)
, pn_admin_capable VARCHAR (0)
, pn_user_capable VARCHAR (0)
, pn_state VARCHAR (0)
);
/* Id: 5008842 Name: openemr_postcalendar_categories */
create table openemr_postcalendar_categories (
pc_catid INT
, pc_constant_id VARCHAR (255)
, pc_catname VARCHAR (100)
, pc_catcolor VARCHAR (50)
, pc_catdesc MEDIUMTEXT
, pc_recurrtype INT
, pc_enddate TIMESTAMP
, pc_recurrspec MEDIUMTEXT
, pc_recurrfreq INT
, pc_duration INT
, pc_end_date_flag VARCHAR (0)
, pc_end_date_type INT
, pc_end_date_freq INT
, pc_end_all_day VARCHAR (0)
, pc_dailylimit INT
, pc_cattype INT
, pc_active VARCHAR (0)
, pc_seq INT
, aco_spec VARCHAR (63)
, pc_last_updated TIMESTAMP
);
/* Id: 5008844 Name: openemr_postcalendar_events */
create table openemr_postcalendar_events (
pc_eid INT
, pc_catid INT
, pc_multiple INT
, pc_aid VARCHAR (30)
, pc_pid VARCHAR (11)
, pc_gid INT
, pc_title VARCHAR (150)
, pc_time TIMESTAMP
, pc_hometext MEDIUMTEXT
, pc_comments INT
, pc_counter INT
, pc_topic INT
, pc_informant VARCHAR (20)
, pc_eventDate TIMESTAMP
, pc_endDate TIMESTAMP
, pc_duration INT
, pc_recurrtype INT
, pc_recurrspec MEDIUMTEXT
, pc_recurrfreq INT
, pc_startTime TIMESTAMP
, pc_endTime TIMESTAMP
, pc_alldayevent INT
, pc_location MEDIUMTEXT
, pc_conttel VARCHAR (50)
, pc_contname VARCHAR (50)
, pc_contemail VARCHAR (255)
, pc_website VARCHAR (255)
, pc_fee VARCHAR (50)
, pc_eventstatus INT
, pc_sharing INT
, pc_language VARCHAR (30)
, pc_apptstatus VARCHAR (15)
, pc_prefcatid INT
, pc_facility INT
, pc_sendalertsms VARCHAR (3)
, pc_sendalertemail VARCHAR (3)
, pc_billing_location INT
, pc_room VARCHAR (20)
, uuid MEDIUMBLOB
);
/* Id: 5008846 Name: patient_access_onsite */
create table patient_access_onsite (
id INT
, pid INT
, portal_username VARCHAR (100)
, portal_pwd VARCHAR (255)
, portal_pwd_status INT
, portal_login_username VARCHAR (100)
, portal_onetime VARCHAR (255)
, date_created TIMESTAMP
);
/* Id: 5008848 Name: patient_birthday_alert */
create table patient_birthday_alert (
pid INT
, user_id INT
, turned_off_on TIMESTAMP
);
/* Id: 5008850 Name: patient_data */
create table patient_data (
id INT
, uuid MEDIUMBLOB
, title VARCHAR (255)
, language VARCHAR (255)
, financial VARCHAR (255)
, fname VARCHAR (255)
, lname VARCHAR (255)
, mname VARCHAR (255)
, DOB TIMESTAMP
, street VARCHAR (255)
, postal_code VARCHAR (255)
, city VARCHAR (255)
, state VARCHAR (255)
, country_code VARCHAR (255)
, drivers_license VARCHAR (255)
, ss VARCHAR (255)
, occupation MEDIUMTEXT
, phone_home VARCHAR (255)
, phone_biz VARCHAR (255)
, phone_contact VARCHAR (255)
, phone_cell VARCHAR (255)
, pharmacy_id INT
, status VARCHAR (255)
, contact_relationship VARCHAR (255)
, date TIMESTAMP
, sex VARCHAR (255)
, referrer VARCHAR (255)
, referrerID VARCHAR (255)
, providerID INT
, ref_providerID INT
, email VARCHAR (255)
, email_direct VARCHAR (255)
, ethnoracial VARCHAR (255)
, race VARCHAR (255)
, ethnicity VARCHAR (255)
, religion VARCHAR (40)
, interpretter VARCHAR (255)
, migrantseasonal VARCHAR (255)
, family_size VARCHAR (255)
, monthly_income VARCHAR (255)
);
/* Id: 5008852 Name: patient_history */
create table patient_history (
id INT
, uuid MEDIUMBLOB
, date TIMESTAMP
, care_team_provider MEDIUMTEXT
, care_team_facility MEDIUMTEXT
, pid INT
, history_type_key VARCHAR (36)
, previous_name_prefix MEDIUMTEXT
, previous_name_first MEDIUMTEXT
, previous_name_middle MEDIUMTEXT
, previous_name_last MEDIUMTEXT
, previous_name_suffix MEDIUMTEXT
, previous_name_enddate TIMESTAMP
, created_by INT
);
/* Id: 5008854 Name: patient_portal_menu */
create table patient_portal_menu (
patient_portal_menu_id INT
, patient_portal_menu_group_id INT
, menu_name VARCHAR (40)
, menu_order INT
, menu_status INT
);
/* Id: 5008856 Name: patient_reminders */
create table patient_reminders (
id INT
, active VARCHAR (0)
, date_inactivated TIMESTAMP
, reason_inactivated VARCHAR (31)
, due_status VARCHAR (31)
, pid INT
, category VARCHAR (31)
, item VARCHAR (31)
, date_created TIMESTAMP
, date_sent TIMESTAMP
, voice_status VARCHAR (0)
, sms_status VARCHAR (0)
, email_status VARCHAR (0)
, mail_status VARCHAR (0)
);
/* Id: 5008858 Name: patient_settings */
create table patient_settings (
setting_patient INT
, setting_label VARCHAR (100)
, setting_value VARCHAR (255)
);
/* Id: 5008860 Name: patient_tracker */
create table patient_tracker (
id INT
, date TIMESTAMP
, apptdate TIMESTAMP
, appttime TIMESTAMP
, eid INT
, pid INT
, original_user VARCHAR (255)
, encounter INT
, lastseq VARCHAR (4)
, random_drug_test VARCHAR (0)
, drug_screen_completed VARCHAR (0)
);
/* Id: 5008862 Name: patient_tracker_element */
create table patient_tracker_element (
pt_tracker_id INT
, start_datetime TIMESTAMP
, room VARCHAR (20)
, status VARCHAR (31)
, seq VARCHAR (4)
, user VARCHAR (255)
);
/* Id: 5008864 Name: payment_gateway_details */
create table payment_gateway_details (
id INT
, service_name VARCHAR (100)
, login_id VARCHAR (255)
, transaction_key VARCHAR (255)
, md5 VARCHAR (255)
);
/* Id: 5008866 Name: payment_processing_audit */
create table payment_processing_audit (
uuid MEDIUMBLOB
, service VARCHAR (50)
, pid INT
, success INT
, action_name VARCHAR (50)
, amount VARCHAR (20)
, ticket VARCHAR (100)
, transaction_id VARCHAR (100)
, audit_data MEDIUMTEXT
, date TIMESTAMP
, map_uuid MEDIUMBLOB
, map_transaction_id VARCHAR (100)
, reverted INT
, revert_action_name VARCHAR (50)
, revert_transaction_id VARCHAR (100)
, revert_audit_data MEDIUMTEXT
, revert_date TIMESTAMP
);
/* Id: 5008868 Name: payments */
create table payments (
id INT
, pid INT
, dtime TIMESTAMP
, encounter INT
, user VARCHAR (255)
, method VARCHAR (255)
, source VARCHAR (255)
, amount1 DECIMAL(38,6)
, amount2 DECIMAL(38,6)
, posted1 DECIMAL(38,6)
, posted2 DECIMAL(38,6)
);
/* Id: 5008870 Name: pharmacies */
create table pharmacies (
id INT
, name VARCHAR (255)
, transmit_method INT
, email VARCHAR (255)
, ncpdp INT
, npi INT
);
/* Id: 5008872 Name: phone_numbers */
create table phone_numbers (
id INT
, country_code VARCHAR (5)
, area_code VARCHAR (3)
, prefix VARCHAR (3)
, number VARCHAR (4)
, type INT
, foreign_id INT
);
/* Id: 5008874 Name: pnotes */
create table pnotes (
id INT
, date TIMESTAMP
, body MEDIUMTEXT
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, activity INT
, authorized INT
, title VARCHAR (255)
, assigned_to VARCHAR (255)
, deleted INT
, message_status VARCHAR (20)
, portal_relation VARCHAR (100)
, is_msg_encrypted INT
, update_by INT
, update_date TIMESTAMP
);
/* Id: 5008876 Name: prescriptions */
create table prescriptions (
id INT
, uuid MEDIUMBLOB
, patient_id INT
, filled_by_id INT
, pharmacy_id INT
, date_added TIMESTAMP
, date_modified TIMESTAMP
, provider_id INT
, encounter INT
, start_date TIMESTAMP
, drug VARCHAR (150)
, drug_id INT
, rxnorm_drugcode VARCHAR (25)
, form INT
, dosage VARCHAR (100)
, quantity VARCHAR (31)
, size VARCHAR (25)
, unit INT
, route VARCHAR (100)
, interval INT
, substitute INT
, refills INT
, per_refill INT
, filled_date TIMESTAMP
, medication INT
, note MEDIUMTEXT
, active INT
, datetime TIMESTAMP
, user VARCHAR (50)
, site VARCHAR (50)
, prescriptionguid VARCHAR (50)
, erx_source INT
, erx_uploaded INT
, drug_info_erx MEDIUMTEXT
, external_id VARCHAR (20)
, end_date TIMESTAMP
, indication MEDIUMTEXT
, prn VARCHAR (30)
, ntx INT
, rtx INT
);
/* Id: 5008878 Name: prices */
create table prices (
pr_id VARCHAR (11)
, pr_selector VARCHAR (255)
, pr_level VARCHAR (31)
, pr_price DECIMAL(38,6)
);
/* Id: 5008880 Name: pro_assessments */
create table pro_assessments (
id INT
, form_oid VARCHAR (255)
, form_name VARCHAR (255)
, user_id INT
, deadline TIMESTAMP
, patient_id INT
, assessment_oid VARCHAR (255)
, status VARCHAR (255)
, score DECIMAL(38,6)
, error DECIMAL(38,6)
, created_at TIMESTAMP
, updated_at TIMESTAMP
);
/* Id: 5008882 Name: procedure_answers */
create table procedure_answers (
procedure_order_id INT
, procedure_order_seq INT
, question_code VARCHAR (31)
, answer_seq INT
, answer VARCHAR (255)
, procedure_code VARCHAR (31)
);
/* Id: 5008884 Name: procedure_order */
create table procedure_order (
procedure_order_id INT
, uuid MEDIUMBLOB
, provider_id INT
, patient_id INT
, encounter_id INT
, date_collected TIMESTAMP
, date_ordered TIMESTAMP
, order_priority VARCHAR (31)
, order_status VARCHAR (31)
, patient_instructions MEDIUMTEXT
, activity VARCHAR (0)
, control_id VARCHAR (255)
, lab_id INT
, specimen_type VARCHAR (31)
, specimen_location VARCHAR (31)
, specimen_volume VARCHAR (30)
, date_transmitted TIMESTAMP
, clinical_hx VARCHAR (255)
, external_id VARCHAR (20)
, history_order VARCHAR (2)
, order_diagnosis VARCHAR (255)
, billing_type VARCHAR (4)
, specimen_fasting VARCHAR (31)
, order_psc INT
, order_abn VARCHAR (31)
, collector_id INT
, account VARCHAR (60)
, account_facility INT
, provider_number VARCHAR (30)
, procedure_order_type VARCHAR (32)
);
/* Id: 5008886 Name: procedure_order_code */
create table procedure_order_code (
procedure_order_id INT
, procedure_order_seq INT
, procedure_code VARCHAR (64)
, procedure_name VARCHAR (255)
, procedure_source VARCHAR (1)
, diagnoses MEDIUMTEXT
, do_not_send VARCHAR (0)
, procedure_order_title VARCHAR (255)
, procedure_type VARCHAR (31)
, transport VARCHAR (31)
, date_end TIMESTAMP
, reason_code VARCHAR (31)
, reason_description MEDIUMTEXT
, reason_date_low TIMESTAMP
, reason_date_high TIMESTAMP
, reason_status VARCHAR (31)
);
/* Id: 5008888 Name: procedure_providers */
create table procedure_providers (
ppid INT
, uuid MEDIUMBLOB
, name VARCHAR (255)
, npi VARCHAR (15)
, send_app_id VARCHAR (255)
, send_fac_id VARCHAR (255)
, recv_app_id VARCHAR (255)
, recv_fac_id VARCHAR (255)
, DorP VARCHAR (1)
, direction VARCHAR (1)
, protocol VARCHAR (15)
, remote_host VARCHAR (255)
, login VARCHAR (255)
, password VARCHAR (255)
, orders_path VARCHAR (255)
, results_path VARCHAR (255)
, notes MEDIUMTEXT
, lab_director INT
, active VARCHAR (0)
, type VARCHAR (31)
, date_created TIMESTAMP
, last_updated TIMESTAMP
);
/* Id: 5008890 Name: procedure_questions */
create table procedure_questions (
lab_id INT
, procedure_code VARCHAR (31)
, question_code VARCHAR (31)
, seq INT
, question_text VARCHAR (255)
, required VARCHAR (0)
, maxsize INT
, fldtype VARCHAR (1)
, options MEDIUMTEXT
, tips VARCHAR (255)
, activity VARCHAR (0)
);
/* Id: 5008892 Name: procedure_report */
create table procedure_report (
procedure_report_id INT
, uuid MEDIUMBLOB
, procedure_order_id INT
, procedure_order_seq INT
, date_collected TIMESTAMP
, date_collected_tz VARCHAR (5)
, date_report TIMESTAMP
, date_report_tz VARCHAR (5)
, source INT
, specimen_num VARCHAR (63)
, report_status VARCHAR (31)
, review_status VARCHAR (31)
, report_notes MEDIUMTEXT
);
/* Id: 5008894 Name: procedure_result */
create table procedure_result (
procedure_result_id INT
, uuid MEDIUMBLOB
, procedure_report_id INT
, result_data_type VARCHAR (1)
, result_code VARCHAR (31)
, result_text VARCHAR (255)
, date TIMESTAMP
, facility VARCHAR (255)
, units VARCHAR (31)
, result VARCHAR (255)
, range VARCHAR (255)
, abnormal VARCHAR (31)
, comments MEDIUMTEXT
, document_id INT
, result_status VARCHAR (31)
, date_end TIMESTAMP
);
/* Id: 5008896 Name: procedure_type */
create table procedure_type (
procedure_type_id INT
, parent INT
, name VARCHAR (63)
, lab_id INT
, procedure_code VARCHAR (64)
, procedure_type VARCHAR (31)
, body_site VARCHAR (31)
, specimen VARCHAR (31)
, route_admin VARCHAR (31)
, laterality VARCHAR (31)
, description VARCHAR (255)
, standard_code VARCHAR (255)
, related_code VARCHAR (255)
, units VARCHAR (31)
, range VARCHAR (255)
, seq INT
, activity VARCHAR (0)
, notes VARCHAR (255)
, transport VARCHAR (31)
, procedure_type_name VARCHAR (64)
);
/* Id: 5008898 Name: product_registration */
create table product_registration (
id INT
, email VARCHAR (255)
, opt_out VARCHAR (0)
);
/* Id: 5008900 Name: product_warehouse */
create table product_warehouse (
pw_drug_id INT
, pw_warehouse VARCHAR (31)
, pw_min_level DECIMAL(38,6)
, pw_max_level DECIMAL(38,6)
);
/* Id: 5008902 Name: questionnaire_repository */
create table questionnaire_repository (
id INT
, uuid MEDIUMBLOB
, questionnaire_id VARCHAR (255)
, provider INT
, version INT
, created_date TIMESTAMP
, modified_date TIMESTAMP
, name VARCHAR (255)
, type VARCHAR (63)
, profile VARCHAR (255)
, active INT
, status VARCHAR (31)
, source_url MEDIUMTEXT
, code VARCHAR (255)
, code_display MEDIUMTEXT
, questionnaire MEDIUMTEXT
, lform MEDIUMTEXT
);
/* Id: 5008904 Name: questionnaire_response */
create table questionnaire_response (
id INT
, uuid MEDIUMBLOB
, response_id VARCHAR (255)
, questionnaire_foreign_id INT
, questionnaire_id VARCHAR (255)
, questionnaire_name VARCHAR (255)
, patient_id INT
, encounter INT
, audit_user_id INT
, creator_user_id INT
, create_time TIMESTAMP
, last_updated TIMESTAMP
, version INT
, status VARCHAR (63)
, questionnaire MEDIUMTEXT
, questionnaire_response MEDIUMTEXT
, form_response MEDIUMTEXT
, form_score INT
, tscore DECIMAL(38,6)
, error DECIMAL(38,6)
);
/* Id: 5008906 Name: recent_patients */
create table recent_patients (
user_id VARCHAR (40)
, patients MEDIUMTEXT
);
/* Id: 5008908 Name: registry */
create table registry (
name VARCHAR (255)
, state INT
, directory VARCHAR (255)
, id INT
, sql_run INT
, unpackaged INT
, date TIMESTAMP
, priority INT
, category VARCHAR (255)
, nickname VARCHAR (255)
, patient_encounter INT
, therapy_group_encounter INT
, aco_spec VARCHAR (63)
, form_foreign_id INT
);
/* Id: 5008910 Name: report_itemized */
create table report_itemized (
report_id INT
, itemized_test_id INT
, numerator_label VARCHAR (25)
, pass VARCHAR (0)
, pid INT
, rule_id VARCHAR (31)
, item_details MEDIUMTEXT
);
/* Id: 5008912 Name: report_results */
create table report_results (
report_id INT
, field_id VARCHAR (31)
, field_value MEDIUMTEXT
);
/* Id: 5008914 Name: rule_action */
create table rule_action (
id VARCHAR (31)
, group_id INT
, category VARCHAR (31)
, item VARCHAR (31)
);
/* Id: 5008916 Name: rule_action_item */
create table rule_action_item (
category VARCHAR (31)
, item VARCHAR (31)
, clin_rem_link VARCHAR (255)
, reminder_message MEDIUMTEXT
, custom_flag VARCHAR (0)
);
/* Id: 5008918 Name: rule_filter */
create table rule_filter (
id VARCHAR (31)
, include_flag VARCHAR (0)
, required_flag VARCHAR (0)
, method VARCHAR (31)
, method_detail VARCHAR (31)
, value VARCHAR (255)
);
/* Id: 5008920 Name: rule_patient_data */
create table rule_patient_data (
id INT
, date TIMESTAMP
, pid INT
, category VARCHAR (31)
, item VARCHAR (31)
, complete VARCHAR (31)
, result VARCHAR (255)
);
/* Id: 5008922 Name: rule_reminder */
create table rule_reminder (
id VARCHAR (31)
, method VARCHAR (31)
, method_detail VARCHAR (31)
, value VARCHAR (255)
);
/* Id: 5008924 Name: rule_target */
create table rule_target (
id VARCHAR (31)
, group_id INT
, include_flag VARCHAR (0)
, required_flag VARCHAR (0)
, method VARCHAR (31)
, value VARCHAR (255)
, interval INT
);
/* Id: 5008926 Name: sequences */
create table sequences (
id INT
);
/* Id: 5008928 Name: session_tracker */
create table session_tracker (
uuid MEDIUMBLOB
, created TIMESTAMP
, last_updated TIMESTAMP
, number_scripts INT
);
/* Id: 5008930 Name: shared_attributes */
create table shared_attributes (
pid INT
, encounter INT
, field_id VARCHAR (31)
, last_update TIMESTAMP
, user_id INT
, field_value MEDIUMTEXT
);
/* Id: 5008932 Name: standardized_tables_track */
create table standardized_tables_track (
id INT
, imported_date TIMESTAMP
, name VARCHAR (255)
, revision_version VARCHAR (255)
, revision_date TIMESTAMP
, file_checksum VARCHAR (32)
);
/* Id: 5008934 Name: supported_external_dataloads */
create table supported_external_dataloads (
load_id INT
, load_type VARCHAR (24)
, load_source VARCHAR (24)
, load_release_date TIMESTAMP
, load_filename VARCHAR (256)
, load_checksum VARCHAR (32)
);
/* Id: 5008936 Name: syndromic_surveillance */
create table syndromic_surveillance (
id INT
, lists_id INT
, submission_date TIMESTAMP
, filename VARCHAR (255)
);
/* Id: 5008938 Name: template_users */
create table template_users (
tu_id INT
, tu_user_id INT
, tu_facility_id INT
, tu_template_id INT
, tu_template_order INT
);
/* Id: 5008940 Name: therapy_groups */
create table therapy_groups (
group_id INT
, group_name VARCHAR (255)
, group_start_date TIMESTAMP
, group_end_date TIMESTAMP
, group_type INT
, group_participation INT
, group_status INT
, group_notes MEDIUMTEXT
, group_guest_counselors VARCHAR (255)
);
/* Id: 5008942 Name: therapy_groups_counselors */
create table therapy_groups_counselors (
group_id INT
, user_id INT
);
/* Id: 5008944 Name: therapy_groups_participant_atten */
create table therapy_groups_participant_atten (
form_id INT
, pid INT
, meeting_patient_comment MEDIUMTEXT
, meeting_patient_status VARCHAR (15)
);
/* Id: 5008946 Name: therapy_groups_participants */
create table therapy_groups_participants (
group_id INT
, pid INT
, group_patient_status INT
, group_patient_start TIMESTAMP
, group_patient_end TIMESTAMP
, group_patient_comment MEDIUMTEXT
);
/* Id: 5008948 Name: transactions */
create table transactions (
id INT
, date TIMESTAMP
, title VARCHAR (255)
, pid INT
, user VARCHAR (255)
, groupname VARCHAR (255)
, authorized INT
);
/* Id: 5008950 Name: user_settings */
create table user_settings (
setting_user INT
, setting_label VARCHAR (100)
, setting_value VARCHAR (255)
);
/* Id: 5008952 Name: users */
create table users (
id INT
, uuid MEDIUMBLOB
, username VARCHAR (255)
, password MEDIUMTEXT
, authorized INT
, info MEDIUMTEXT
, source INT
, fname VARCHAR (255)
, mname VARCHAR (255)
, lname VARCHAR (255)
, suffix VARCHAR (255)
, federaltaxid VARCHAR (255)
, federaldrugid VARCHAR (255)
, upin VARCHAR (255)
, facility VARCHAR (255)
, facility_id INT
, see_auth INT
, active VARCHAR (0)
, npi VARCHAR (15)
, title VARCHAR (30)
, specialty VARCHAR (255)
, billname VARCHAR (255)
, email VARCHAR (255)
, email_direct VARCHAR (255)
, google_signin_email VARCHAR (255)
, url VARCHAR (255)
, assistant VARCHAR (255)
, organization VARCHAR (255)
, valedictory VARCHAR (255)
, street VARCHAR (60)
, streetb VARCHAR (60)
, city VARCHAR (30)
, state VARCHAR (30)
, zip VARCHAR (20)
, street2 VARCHAR (60)
, streetb2 VARCHAR (60)
, city2 VARCHAR (30)
, state2 VARCHAR (30)
, zip2 VARCHAR (20)
, phone VARCHAR (30)
);
/* Id: 5008954 Name: users_facility */
create table users_facility (
tablename VARCHAR (64)
, table_id INT
, facility_id INT
, warehouse_id VARCHAR (31)
);
/* Id: 5008956 Name: users_secure */
create table users_secure (
id INT
, username VARCHAR (255)
, password VARCHAR (255)
, last_update_password TIMESTAMP
, last_update TIMESTAMP
, password_history1 VARCHAR (255)
, password_history2 VARCHAR (255)
, password_history3 VARCHAR (255)
, password_history4 VARCHAR (255)
, last_challenge_response TIMESTAMP
, login_work_area MEDIUMTEXT
, total_login_fail_counter INT
, login_fail_counter INT
, last_login_fail TIMESTAMP
, auto_block_emailed INT
);
/* Id: 5008958 Name: uuid_mapping */
create table uuid_mapping (
id INT
, uuid MEDIUMBLOB
, resource VARCHAR (255)
, resource_path VARCHAR (255)
, table VARCHAR (255)
, target_uuid MEDIUMBLOB
, created TIMESTAMP
);
/* Id: 5008960 Name: uuid_registry */
create table uuid_registry (
uuid MEDIUMBLOB
, table_name VARCHAR (255)
, table_id VARCHAR (255)
, table_vertical VARCHAR (255)
, couchdb VARCHAR (255)
, document_drive INT
, mapped INT
, created TIMESTAMP
);
/* Id: 5008962 Name: valueset */
create table valueset (
nqf_code VARCHAR (255)
, code VARCHAR (255)
, code_system VARCHAR (255)
, code_type VARCHAR (255)
, valueset VARCHAR (255)
, description VARCHAR (255)
, valueset_name VARCHAR (500)
);
/* Id: 5008964 Name: valueset_oid */
create table valueset_oid (
nqf_code VARCHAR (255)
, code VARCHAR (255)
, code_system VARCHAR (255)
, code_type VARCHAR (255)
, valueset VARCHAR (255)
, description VARCHAR (255)
, valueset_name VARCHAR (500)
);
/* Id: 5008966 Name: verify_email */
create table verify_email (
id INT
, pid_holder INT
, email VARCHAR (255)
, language VARCHAR (100)
, fname VARCHAR (255)
, mname VARCHAR (255)
, lname VARCHAR (255)
, dob TIMESTAMP
, token_onetime VARCHAR (255)
, active INT
);
/* Id: 5008968 Name: version */
create table version (
v_major INT
, v_minor INT
, v_patch INT
, v_realpatch INT
, v_tag VARCHAR (31)
, v_database INT
, v_acl INT
);
/* Id: 5008970 Name: voids */
create table voids (
void_id INT
, patient_id INT
, encounter_id INT
, what_voided VARCHAR (31)
, date_original TIMESTAMP
, date_voided TIMESTAMP
, user_id INT
, amount1 DECIMAL(38,6)
, amount2 DECIMAL(38,6)
, other_info MEDIUMTEXT
, reason VARCHAR (31)
, notes VARCHAR (255)
);
/* Id: 5008972 Name: x12_partners */
create table x12_partners (
id INT
, name VARCHAR (255)
, id_number VARCHAR (255)
, x12_sender_id VARCHAR (255)
, x12_receiver_id VARCHAR (255)
, processing_format VARCHAR (20)
, x12_isa01 VARCHAR (2)
, x12_isa02 VARCHAR (10)
, x12_isa03 VARCHAR (2)
, x12_isa04 VARCHAR (10)
, x12_isa05 VARCHAR (2)
, x12_isa07 VARCHAR (2)
, x12_isa14 VARCHAR (1)
, x12_isa15 VARCHAR (1)
, x12_gs02 VARCHAR (15)
, x12_per06 VARCHAR (80)
, x12_dtp03 VARCHAR (1)
, x12_gs03 VARCHAR (15)
, x12_submitter_id INT
, x12_submitter_name VARCHAR (255)
, x12_sftp_login VARCHAR (255)
, x12_sftp_pass VARCHAR (255)
, x12_sftp_host VARCHAR (255)
, x12_sftp_port VARCHAR (255)
, x12_sftp_local_dir VARCHAR (255)
, x12_sftp_remote_dir VARCHAR (255)
, x12_token_endpoint MEDIUMTEXT
, x12_eligibility_endpoint MEDIUMTEXT
, x12_claim_status_endpoint MEDIUMTEXT
, x12_attachment_endpoint MEDIUMTEXT
, x12_client_id MEDIUMTEXT
, x12_client_secret MEDIUMTEXT
);
/* Id: 5008974 Name: x12_remote_tracker */
create table x12_remote_tracker (
id INT
, x12_partner_id INT
, x12_filename VARCHAR (255)
, status VARCHAR (255)
, claims MEDIUMTEXT
, messages MEDIUMTEXT
, created_at TIMESTAMP
, updated_at TIMESTAMP
);