tsvas wrote on Sunday, September 25, 2011:
Brady, here is the database structure dump.
- phpMyAdmin SQL Dump
- version 2.11.10
- http://www.phpmyadmin.net
-
- Host: localhost:3306
- Generation Time: Sep 24, 2011 at 10:20 PM
- Server version: 5.1.41
- PHP Version: 5.3.1
SET SQL_MODE=“NO_AUTO_VALUE_ON_ZERO”;
-
- Table structure for table ‘addresses’
-
CREATE TABLE addresses (
id int(11) NOT NULL DEFAULT ‘0’,
line1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
line2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state varchar(35) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
zip varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
plus_four varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
country varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
foreign_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY foreign_id (foreign_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘amc_misc_data’
-
CREATE TABLE amc_misc_data (
amc_id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Unique and maps to list_options list clinical_rules’,
pid bigint(20) DEFAULT NULL,
map_category varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to an object category (such as prescriptions etc.)’,
map_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘Maps to an object id (such as prescription id etc.)’,
date_created datetime DEFAULT NULL,
date_completed datetime DEFAULT NULL,
KEY amc_id (amc_id,pid,map_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘array’
-
CREATE TABLE array (
array_key varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
array_value longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘ar_activity’
-
CREATE TABLE ar_activity (
pid int(11) NOT NULL,
encounter int(11) NOT NULL,
sequence_no int(10) unsigned NOT NULL AUTO_INCREMENT,
`code` varchar(9) CHARACTER SET latin1 NOT NULL COMMENT ‘empty means claim level’,
modifier varchar(5) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
payer_type int(11) NOT NULL COMMENT ‘0=pt, 1=ins1, 2=ins2, etc’,
post_time datetime NOT NULL,
post_user int(11) NOT NULL COMMENT ‘references users.id’,
session_id int(10) unsigned NOT NULL COMMENT ‘references ar_session.session_id’,
memo varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘adjustment reasons go here’,
pay_amount decimal(12,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘either pay or adj will always be 0’,
adj_amount decimal(12,2) NOT NULL DEFAULT ‘0.00’,
modified_time datetime NOT NULL,
follow_up char(1) CHARACTER SET latin1 NOT NULL,
follow_up_note text CHARACTER SET latin1 NOT NULL,
account_code varchar(15) CHARACTER SET latin1 NOT NULL,
reason_code varchar(255) CHARACTER SET latin1 DEFAULT NULL COMMENT ‘Use as needed to show the primary payer adjustment reason code’,
PRIMARY KEY (pid,encounter,sequence_no),
KEY session_id (session_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘ar_session’
-
CREATE TABLE ar_session (
session_id int(10) unsigned NOT NULL AUTO_INCREMENT,
payer_id int(11) NOT NULL COMMENT ‘0=pt else references insurance_companies.id’,
user_id int(11) NOT NULL COMMENT ‘references users.id for session owner’,
closed tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0=no, 1=yes’,
reference varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘check or EOB number’,
check_date date DEFAULT NULL,
deposit_date date DEFAULT NULL,
pay_total decimal(12,2) NOT NULL DEFAULT ‘0.00’,
created_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
modified_time datetime NOT NULL,
global_amount decimal(12,2) NOT NULL,
payment_type varchar(50) CHARACTER SET latin1 NOT NULL,
description text CHARACTER SET latin1 NOT NULL,
adjustment_code varchar(50) CHARACTER SET latin1 NOT NULL,
post_to_date date NOT NULL,
patient_id int(11) NOT NULL,
payment_method varchar(25) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (session_id),
KEY user_closed (user_id,closed),
KEY deposit_date (deposit_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘audit_details’
-
CREATE TABLE audit_details (
id bigint(20) NOT NULL AUTO_INCREMENT,
table_name varchar(100) CHARACTER SET latin1 NOT NULL COMMENT ‘openemr table name’,
field_name varchar(100) CHARACTER SET latin1 NOT NULL COMMENT ‘openemr table’‘s field name’,
field_value text CHARACTER SET latin1 NOT NULL COMMENT ‘openemr table’‘s field value’,
audit_master_id bigint(20) NOT NULL COMMENT ‘Id of the audit_master table’,
entry_identification varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘1’ COMMENT ‘Used when multiple entry occurs from the same table.1 means no multiple entry’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘audit_master’
-
CREATE TABLE audit_master (
id bigint(20) NOT NULL AUTO_INCREMENT,
pid bigint(20) NOT NULL,
user_id bigint(20) NOT NULL COMMENT ‘The Id of the user who approves or denies’,
approval_status tinyint(4) NOT NULL COMMENT ‘1-Pending,2-Approved,3-Denied,4-Appointment directly updated to calendar table,5-Cancelled appointment’,
comments text CHARACTER SET latin1 NOT NULL,
created_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
modified_time datetime NOT NULL,
ip_address varchar(100) CHARACTER SET latin1 NOT NULL,
`type` tinyint(4) NOT NULL COMMENT ‘1-new patient,2-existing patient,3-change is only in the document,5-random key,10-Appointment’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘automatic_notification’
-
CREATE TABLE automatic_notification (
notification_id int(5) NOT NULL AUTO_INCREMENT,
sms_gateway_type varchar(255) CHARACTER SET latin1 NOT NULL,
next_app_date date NOT NULL,
next_app_time varchar(10) CHARACTER SET latin1 NOT NULL,
provider_name varchar(100) CHARACTER SET latin1 NOT NULL,
message text CHARACTER SET latin1 NOT NULL,
email_sender varchar(100) CHARACTER SET latin1 NOT NULL,
email_subject varchar(100) CHARACTER SET latin1 NOT NULL,
`type` enum(‘SMS’,‘Email’) CHARACTER SET latin1 NOT NULL DEFAULT ‘SMS’,
notification_sent_date datetime NOT NULL,
PRIMARY KEY (notification_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘batchcom’
-
CREATE TABLE batchcom (
id bigint(20) NOT NULL AUTO_INCREMENT,
patient_id int(11) NOT NULL DEFAULT ‘0’,
sent_by bigint(20) NOT NULL DEFAULT ‘0’,
msg_type varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
msg_subject varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
msg_text mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
msg_date_sent datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘billing’
-
CREATE TABLE billing (
id int(11) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
code_type varchar(7) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`code` varchar(9) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pid int(11) DEFAULT NULL,
provider_id int(11) DEFAULT NULL,
`user` int(11) DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(1) DEFAULT NULL,
encounter int(11) DEFAULT NULL,
code_text longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
billed tinyint(1) DEFAULT NULL,
activity tinyint(1) DEFAULT NULL,
payer_id int(11) DEFAULT NULL,
bill_process tinyint(2) NOT NULL DEFAULT ‘0’,
bill_date datetime DEFAULT NULL,
process_date datetime DEFAULT NULL,
process_file varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
modifier varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
units tinyint(3) DEFAULT NULL,
fee decimal(12,2) DEFAULT NULL,
justify varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
target varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_partner_id int(11) DEFAULT NULL,
ndc_info varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id),
KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘categories’
-
CREATE TABLE categories (
id int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
parent int(11) NOT NULL DEFAULT ‘0’,
lft int(11) NOT NULL DEFAULT ‘0’,
rght int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
KEY parent (parent),
KEY lft (lft,rght)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘categories_seq’
-
CREATE TABLE categories_seq (
id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘categories_to_documents’
-
CREATE TABLE categories_to_documents (
category_id int(11) NOT NULL DEFAULT ‘0’,
document_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (category_id,document_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘chart_tracker’
-
CREATE TABLE chart_tracker (
ct_pid int(11) NOT NULL,
ct_when datetime NOT NULL,
ct_userid bigint(20) NOT NULL DEFAULT ‘0’,
ct_location varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (ct_pid,ct_when)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘claims’
-
CREATE TABLE claims (
patient_id int(11) NOT NULL,
encounter_id int(11) NOT NULL,
version int(10) unsigned NOT NULL AUTO_INCREMENT,
payer_id int(11) NOT NULL DEFAULT ‘0’,
`status` tinyint(2) NOT NULL DEFAULT ‘0’,
payer_type tinyint(4) NOT NULL DEFAULT ‘0’,
bill_process tinyint(2) NOT NULL DEFAULT ‘0’,
bill_time datetime DEFAULT NULL,
process_time datetime DEFAULT NULL,
process_file varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
target varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_partner_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (patient_id,encounter_id,version)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘clinical_plans’
-
CREATE TABLE clinical_plans (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Unique and maps to list_options list clinical_plans’,
pid bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is default for all patients, while > 0 is id from patient_data table’,
normal_flag tinyint(1) DEFAULT NULL COMMENT ‘Normal Activation Flag’,
cqm_flag tinyint(1) DEFAULT NULL COMMENT ‘Clinical Quality Measure flag (unable to customize per patient)’,
cqm_measure_group varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Clinical Quality Measure Group Identifier’,
PRIMARY KEY (id,pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘clinical_plans_rules’
-
CREATE TABLE clinical_plans_rules (
plan_id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Unique and maps to list_options list clinical_plans’,
rule_id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Unique and maps to list_options list clinical_rules’,
PRIMARY KEY (plan_id,rule_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘clinical_rules’
-
CREATE TABLE clinical_rules (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Unique and maps to list_options list clinical_rules’,
pid bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is default for all patients, while > 0 is id from patient_data table’,
active_alert_flag tinyint(1) DEFAULT NULL COMMENT ‘Active Alert Widget Module flag - note not yet utilized’,
passive_alert_flag tinyint(1) DEFAULT NULL COMMENT ‘Passive Alert Widget Module flag’,
cqm_flag tinyint(1) DEFAULT NULL COMMENT ‘Clinical Quality Measure flag (unable to customize per patient)’,
cqm_nqf_code varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Clinical Quality Measure NQF identifier’,
cqm_pqri_code varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Clinical Quality Measure PQRI identifier’,
amc_flag tinyint(1) DEFAULT NULL COMMENT ‘Automated Measure Calculation flag (unable to customize per patient)’,
amc_code varchar(10) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Automated Measure Calculation indentifier (MU rule)’,
patient_reminder_flag tinyint(1) DEFAULT NULL COMMENT ‘Clinical Reminder Module flag’,
PRIMARY KEY (id,pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘codes’
-
CREATE TABLE codes (
id int(11) NOT NULL AUTO_INCREMENT,
code_text varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
code_text_short varchar(24) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
`code` varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
code_type tinyint(2) DEFAULT NULL,
modifier varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
units tinyint(3) DEFAULT NULL,
fee decimal(12,2) DEFAULT NULL,
superbill varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
related_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
taxrates varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
cyp_factor float NOT NULL DEFAULT ‘0’ COMMENT ‘quantity representing a years supply’,
active tinyint(1) DEFAULT ‘1’ COMMENT ‘0 = inactive, 1 = active’,
reportable tinyint(1) DEFAULT ‘0’ COMMENT ‘0 = non-reportable, 1 = reportable’,
PRIMARY KEY (id),
KEY `code` (`code`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘code_types’
-
CREATE TABLE code_types (
ct_key varchar(15) CHARACTER SET latin1 NOT NULL COMMENT ‘short alphanumeric name’,
ct_id int(11) NOT NULL COMMENT ‘numeric identifier’,
ct_seq int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘sort order’,
ct_mod int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘length of modifier field’,
ct_just varchar(15) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘ct_key of justify type, if any’,
ct_mask varchar(9) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘formatting mask for code values’,
ct_fee tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if fees are used’,
ct_rel tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if can relate to other code types’,
ct_nofs tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if to be hidden in the fee sheet’,
ct_diag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 if this is a diagnosis type’,
PRIMARY KEY (ct_key),
UNIQUE KEY ct_id (ct_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘config’
-
CREATE TABLE config (
id int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`value` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
parent int(11) NOT NULL DEFAULT ‘0’,
lft int(11) NOT NULL DEFAULT ‘0’,
rght int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
KEY parent (parent),
KEY lft (lft,rght)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘config_seq’
-
CREATE TABLE config_seq (
id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘customlists’
-
CREATE TABLE customlists (
cl_list_slno int(10) unsigned NOT NULL AUTO_INCREMENT,
cl_list_id int(10) unsigned NOT NULL COMMENT ‘ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_id)+1’,
cl_list_item_id int(10) unsigned DEFAULT NULL COMMENT ‘ID OF THE lIST FOR NEW TAKE SELECT MAX(cl_list_item_id)+1’,
cl_list_type int(10) unsigned NOT NULL COMMENT ‘0=>List Name 1=>list items 2=>Context 3=>Template 4=>Sentence 5=> SavedTemplate 6=>CustomButton’,
cl_list_item_short varchar(10) CHARACTER SET latin1 DEFAULT NULL,
cl_list_item_long text CHARACTER SET latin1 NOT NULL,
cl_list_item_level int(11) DEFAULT NULL COMMENT ‘Flow level for List Designation’,
cl_order int(11) DEFAULT NULL,
cl_deleted tinyint(1) DEFAULT ‘0’,
cl_creator int(11) DEFAULT NULL,
PRIMARY KEY (cl_list_slno)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘documents’
-
CREATE TABLE documents (
id int(11) NOT NULL DEFAULT ‘0’,
`type` enum(‘file_url’,‘blob’,‘web_url’) CHARACTER SET latin1 DEFAULT NULL,
size int(11) DEFAULT NULL,
`date` datetime DEFAULT NULL,
url varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
mimetype varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pages int(11) DEFAULT NULL,
`owner` int(11) DEFAULT NULL,
revision timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
foreign_id int(11) DEFAULT NULL,
docdate date DEFAULT NULL,
list_id bigint(20) NOT NULL DEFAULT ‘0’,
`hash` varchar(40) COLLATE utf8_bin DEFAULT NULL COMMENT ‘40-character SHA-1 hash of document’,
PRIMARY KEY (id),
KEY revision (revision),
KEY foreign_id (foreign_id),
KEY `owner` (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘documents_legal_categories’
-
CREATE TABLE documents_legal_categories (
dlc_id int(10) unsigned NOT NULL AUTO_INCREMENT,
dlc_category_type int(10) unsigned NOT NULL COMMENT ‘1 category 2 subcategory’,
dlc_category_name varchar(45) CHARACTER SET latin1 NOT NULL,
dlc_category_parent int(10) unsigned DEFAULT NULL,
PRIMARY KEY (dlc_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘documents_legal_detail’
-
CREATE TABLE documents_legal_detail (
dld_id int(10) unsigned NOT NULL AUTO_INCREMENT,
dld_pid int(10) unsigned DEFAULT NULL,
dld_facility int(10) unsigned DEFAULT NULL,
dld_provider int(10) unsigned DEFAULT NULL,
dld_encounter int(10) unsigned DEFAULT NULL,
dld_master_docid int(10) unsigned NOT NULL,
dld_signed smallint(5) unsigned NOT NULL COMMENT ‘0-Not Signed or Cannot Sign(Layout),1-Signed,2-Ready to sign,3-Denied(Pat Regi),10-Save(Layout)’,
dld_signed_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
dld_filepath varchar(75) CHARACTER SET latin1 DEFAULT NULL,
dld_filename varchar(45) CHARACTER SET latin1 NOT NULL,
dld_signing_person varchar(50) CHARACTER SET latin1 NOT NULL,
dld_sign_level int(11) NOT NULL COMMENT ‘Sign flow level’,
dld_content varchar(50) CHARACTER SET latin1 NOT NULL COMMENT ‘Layout sign position’,
dld_file_for_pdf_generation blob NOT NULL COMMENT ‘The filled details in the fdf file is stored here.Patient Registration Screen’,
dld_denial_reason longtext CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (dld_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘documents_legal_master’
-
CREATE TABLE documents_legal_master (
dlm_category int(10) unsigned DEFAULT NULL,
dlm_subcategory int(10) unsigned DEFAULT NULL,
dlm_document_id int(10) unsigned NOT NULL AUTO_INCREMENT,
dlm_document_name varchar(75) CHARACTER SET latin1 NOT NULL,
dlm_filepath varchar(75) CHARACTER SET latin1 NOT NULL,
dlm_facility int(10) unsigned DEFAULT NULL,
dlm_provider int(10) unsigned DEFAULT NULL,
dlm_sign_height double NOT NULL,
dlm_sign_width double NOT NULL,
dlm_filename varchar(45) CHARACTER SET latin1 NOT NULL,
dlm_effective_date datetime NOT NULL,
dlm_version int(10) unsigned NOT NULL,
content varchar(255) CHARACTER SET latin1 NOT NULL,
dlm_savedsign varchar(255) CHARACTER SET latin1 DEFAULT NULL COMMENT ‘0-Yes 1-No’,
dlm_review varchar(255) CHARACTER SET latin1 DEFAULT NULL COMMENT ‘0-Yes 1-No’,
PRIMARY KEY (dlm_document_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘List of Master Docs to be signed’;
-
- Table structure for table ‘drugs’
-
CREATE TABLE drugs (
drug_id int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
ndc_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
on_order int(11) NOT NULL DEFAULT ‘0’,
reorder_point int(11) NOT NULL DEFAULT ‘0’,
last_notify date NOT NULL DEFAULT ‘0000-00-00’,
reactions text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
form int(3) NOT NULL DEFAULT ‘0’,
size float unsigned NOT NULL DEFAULT ‘0’,
unit int(11) NOT NULL DEFAULT ‘0’,
route int(11) NOT NULL DEFAULT ‘0’,
substitute int(11) NOT NULL DEFAULT ‘0’,
related_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’ COMMENT ‘may reference a related codes.code’,
cyp_factor float NOT NULL DEFAULT ‘0’ COMMENT ‘quantity representing a years supply’,
active tinyint(1) DEFAULT ‘1’ COMMENT ‘0 = inactive, 1 = active’,
allow_combining tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 = allow filling an order from multiple lots’,
allow_multiple tinyint(1) NOT NULL DEFAULT ‘1’ COMMENT ‘1 = allow multiple lots at one warehouse’,
PRIMARY KEY (drug_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘drug_inventory’
-
CREATE TABLE drug_inventory (
inventory_id int(11) NOT NULL AUTO_INCREMENT,
drug_id int(11) NOT NULL,
lot_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
expiration date DEFAULT NULL,
manufacturer varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
on_hand int(11) NOT NULL DEFAULT ‘0’,
last_notify date NOT NULL DEFAULT ‘0000-00-00’,
destroy_date date DEFAULT NULL,
destroy_method varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
destroy_witness varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
destroy_notes varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
warehouse_id varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
vendor_id bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (inventory_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘drug_sales’
-
CREATE TABLE drug_sales (
sale_id int(11) NOT NULL AUTO_INCREMENT,
drug_id int(11) NOT NULL,
inventory_id int(11) NOT NULL,
prescription_id int(11) NOT NULL DEFAULT ‘0’,
pid int(11) NOT NULL DEFAULT ‘0’,
encounter int(11) NOT NULL DEFAULT ‘0’,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
sale_date date NOT NULL,
quantity int(11) NOT NULL DEFAULT ‘0’,
fee decimal(12,2) NOT NULL DEFAULT ‘0.00’,
billed tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘indicates if the sale is posted to accounting’,
xfer_inventory_id int(11) NOT NULL DEFAULT ‘0’,
notes varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
distributor_id bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (sale_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘drug_templates’
-
CREATE TABLE drug_templates (
drug_id int(11) NOT NULL,
selector varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
dosage varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
period int(11) NOT NULL DEFAULT ‘0’,
quantity int(11) NOT NULL DEFAULT ‘0’,
refills int(11) NOT NULL DEFAULT ‘0’,
taxrates varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (drug_id,selector)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘eligibility_response’
-
CREATE TABLE eligibility_response (
response_id bigint(20) NOT NULL AUTO_INCREMENT,
response_description varchar(255) CHARACTER SET latin1 DEFAULT NULL,
response_status enum(‘A’,‘D’) CHARACTER SET latin1 NOT NULL DEFAULT ‘A’,
response_vendor_id bigint(20) DEFAULT NULL,
response_create_date date DEFAULT NULL,
response_modify_date date DEFAULT NULL,
PRIMARY KEY (response_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘eligibility_verification’
-
CREATE TABLE eligibility_verification (
verification_id bigint(20) NOT NULL AUTO_INCREMENT,
response_id bigint(20) DEFAULT NULL,
insurance_id bigint(20) DEFAULT NULL,
eligibility_check_date datetime DEFAULT NULL,
copay int(11) DEFAULT NULL,
deductible int(11) DEFAULT NULL,
deductiblemet enum(‘Y’,‘N’) CHARACTER SET latin1 DEFAULT ‘Y’,
create_date date DEFAULT NULL,
PRIMARY KEY (verification_id),
KEY insurance_id (insurance_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘employer_data’
-
CREATE TABLE employer_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
street varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
postal_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
country varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`date` datetime DEFAULT NULL,
pid bigint(20) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘enc_category_map’
-
CREATE TABLE enc_category_map (
rule_enc_id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘encounter id from rule_enc_types list in list_options’,
main_cat_id int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘category id from event category in openemr_postcalendar_categories’,
KEY rule_enc_id (rule_enc_id,main_cat_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘extended_log’
-
CREATE TABLE extended_log (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`event` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
`user` varchar(255) CHARACTER SET latin1 DEFAULT NULL,
recipient varchar(255) CHARACTER SET latin1 DEFAULT NULL,
description longtext CHARACTER SET latin1,
patient_id bigint(20) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘facility’
-
CREATE TABLE facility (
id int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
phone varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fax varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
street varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
postal_code varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
country_code varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
federal_ein varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
service_location tinyint(1) NOT NULL DEFAULT ‘1’,
billing_location tinyint(1) NOT NULL DEFAULT ‘0’,
accepts_assignment tinyint(1) NOT NULL DEFAULT ‘0’,
pos_code tinyint(4) DEFAULT NULL,
x12_sender_id varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
attn varchar(65) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
domain_identifier varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
facility_npi varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
tax_id_type varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
color varchar(7) COLLATE utf8_bin DEFAULT NULL,
primary_business_entity int(10) NOT NULL DEFAULT ‘0’ COMMENT ‘0-Not Set as business entity 1-Set as business entity’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘fee_sheet_options’
-
CREATE TABLE fee_sheet_options (
fs_category varchar(63) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fs_option varchar(63) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fs_codes varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘forms’
-
CREATE TABLE forms (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
encounter bigint(20) DEFAULT NULL,
form_name longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
form_id bigint(20) DEFAULT NULL,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT NULL,
formdir longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
deleted tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘flag indicates form has been deleted’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_dictation’
-
CREATE TABLE form_dictation (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
dictation longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
additional_notes longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_encounter’
-
CREATE TABLE form_encounter (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
reason longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
facility longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
facility_id int(11) NOT NULL DEFAULT ‘0’,
pid bigint(20) DEFAULT NULL,
encounter bigint(20) DEFAULT NULL,
onset_date datetime DEFAULT NULL,
sensitivity varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
billing_note text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_catid int(11) NOT NULL DEFAULT ‘5’ COMMENT ‘event category from openemr_postcalendar_categories’,
last_level_billed int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘0=none, 1=ins1, 2=ins2, etc’,
last_level_closed int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘0=none, 1=ins1, 2=ins2, etc’,
last_stmt_date date DEFAULT NULL,
stmt_count int(11) NOT NULL DEFAULT ‘0’,
provider_id int(11) DEFAULT ‘0’ COMMENT ‘default and main provider for this visit’,
supervisor_id int(11) DEFAULT ‘0’ COMMENT ‘supervising provider, if any, for this visit’,
invoice_refno varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
referral_source varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
billing_facility int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_misc_billing_options’
-
CREATE TABLE form_misc_billing_options (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
employment_related tinyint(1) DEFAULT NULL,
auto_accident tinyint(1) DEFAULT NULL,
accident_state varchar(2) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
other_accident tinyint(1) DEFAULT NULL,
outside_lab tinyint(1) DEFAULT NULL,
lab_amount decimal(5,2) DEFAULT NULL,
is_unable_to_work tinyint(1) DEFAULT NULL,
off_work_from date DEFAULT NULL,
off_work_to date DEFAULT NULL,
is_hospitalized tinyint(1) DEFAULT NULL,
hospitalization_date_from date DEFAULT NULL,
hospitalization_date_to date DEFAULT NULL,
medicaid_resubmission_code varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
medicaid_original_reference varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
prior_auth_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
comments varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
replacement_claim tinyint(1) DEFAULT ‘0’,
date_initial_treatment date DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_reviewofs’
-
CREATE TABLE form_reviewofs (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
fever varchar(5) COLLATE utf8_bin DEFAULT NULL,
chills varchar(5) COLLATE utf8_bin DEFAULT NULL,
night_sweats varchar(5) COLLATE utf8_bin DEFAULT NULL,
weight_loss varchar(5) COLLATE utf8_bin DEFAULT NULL,
poor_appetite varchar(5) COLLATE utf8_bin DEFAULT NULL,
insomnia varchar(5) COLLATE utf8_bin DEFAULT NULL,
fatigued varchar(5) COLLATE utf8_bin DEFAULT NULL,
depressed varchar(5) COLLATE utf8_bin DEFAULT NULL,
hyperactive varchar(5) COLLATE utf8_bin DEFAULT NULL,
exposure_to_foreign_countries varchar(5) COLLATE utf8_bin DEFAULT NULL,
cataracts varchar(5) COLLATE utf8_bin DEFAULT NULL,
cataract_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
glaucoma varchar(5) COLLATE utf8_bin DEFAULT NULL,
double_vision varchar(5) COLLATE utf8_bin DEFAULT NULL,
blurred_vision varchar(5) COLLATE utf8_bin DEFAULT NULL,
poor_hearing varchar(5) COLLATE utf8_bin DEFAULT NULL,
headaches varchar(5) COLLATE utf8_bin DEFAULT NULL,
ringing_in_ears varchar(5) COLLATE utf8_bin DEFAULT NULL,
bloody_nose varchar(5) COLLATE utf8_bin DEFAULT NULL,
sinusitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
sinus_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
dry_mouth varchar(5) COLLATE utf8_bin DEFAULT NULL,
strep_throat varchar(5) COLLATE utf8_bin DEFAULT NULL,
tonsillectomy varchar(5) COLLATE utf8_bin DEFAULT NULL,
swollen_lymph_nodes varchar(5) COLLATE utf8_bin DEFAULT NULL,
throat_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
throat_cancer_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
heart_attack varchar(5) COLLATE utf8_bin DEFAULT NULL,
irregular_heart_beat varchar(5) COLLATE utf8_bin DEFAULT NULL,
chest_pains varchar(5) COLLATE utf8_bin DEFAULT NULL,
shortness_of_breath varchar(5) COLLATE utf8_bin DEFAULT NULL,
high_blood_pressure varchar(5) COLLATE utf8_bin DEFAULT NULL,
heart_failure varchar(5) COLLATE utf8_bin DEFAULT NULL,
poor_circulation varchar(5) COLLATE utf8_bin DEFAULT NULL,
vascular_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
cardiac_catheterization varchar(5) COLLATE utf8_bin DEFAULT NULL,
coronary_artery_bypass varchar(5) COLLATE utf8_bin DEFAULT NULL,
heart_transplant varchar(5) COLLATE utf8_bin DEFAULT NULL,
stress_test varchar(5) COLLATE utf8_bin DEFAULT NULL,
emphysema varchar(5) COLLATE utf8_bin DEFAULT NULL,
chronic_bronchitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
interstitial_lung_disease varchar(5) COLLATE utf8_bin DEFAULT NULL,
shortness_of_breath_2 varchar(5) COLLATE utf8_bin DEFAULT NULL,
lung_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
lung_cancer_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
pheumothorax varchar(5) COLLATE utf8_bin DEFAULT NULL,
stomach_pains varchar(5) COLLATE utf8_bin DEFAULT NULL,
peptic_ulcer_disease varchar(5) COLLATE utf8_bin DEFAULT NULL,
gastritis varchar(5) COLLATE utf8_bin DEFAULT NULL,
endoscopy varchar(5) COLLATE utf8_bin DEFAULT NULL,
polyps varchar(5) COLLATE utf8_bin DEFAULT NULL,
colonoscopy varchar(5) COLLATE utf8_bin DEFAULT NULL,
colon_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
colon_cancer_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
ulcerative_colitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
crohns_disease varchar(5) COLLATE utf8_bin DEFAULT NULL,
appendectomy varchar(5) COLLATE utf8_bin DEFAULT NULL,
divirticulitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
divirticulitis_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
gall_stones varchar(5) COLLATE utf8_bin DEFAULT NULL,
cholecystectomy varchar(5) COLLATE utf8_bin DEFAULT NULL,
hepatitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
cirrhosis_of_the_liver varchar(5) COLLATE utf8_bin DEFAULT NULL,
splenectomy varchar(5) COLLATE utf8_bin DEFAULT NULL,
kidney_failure varchar(5) COLLATE utf8_bin DEFAULT NULL,
kidney_stones varchar(5) COLLATE utf8_bin DEFAULT NULL,
kidney_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
kidney_infections varchar(5) COLLATE utf8_bin DEFAULT NULL,
bladder_infections varchar(5) COLLATE utf8_bin DEFAULT NULL,
bladder_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
prostate_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
prostate_cancer varchar(5) COLLATE utf8_bin DEFAULT NULL,
kidney_transplant varchar(5) COLLATE utf8_bin DEFAULT NULL,
sexually_transmitted_disease varchar(5) COLLATE utf8_bin DEFAULT NULL,
burning_with_urination varchar(5) COLLATE utf8_bin DEFAULT NULL,
discharge_from_urethra varchar(5) COLLATE utf8_bin DEFAULT NULL,
rashes varchar(5) COLLATE utf8_bin DEFAULT NULL,
infections varchar(5) COLLATE utf8_bin DEFAULT NULL,
ulcerations varchar(5) COLLATE utf8_bin DEFAULT NULL,
pemphigus varchar(5) COLLATE utf8_bin DEFAULT NULL,
herpes varchar(5) COLLATE utf8_bin DEFAULT NULL,
osetoarthritis varchar(5) COLLATE utf8_bin DEFAULT NULL,
rheumotoid_arthritis varchar(5) COLLATE utf8_bin DEFAULT NULL,
lupus varchar(5) COLLATE utf8_bin DEFAULT NULL,
ankylosing_sondlilitis varchar(5) COLLATE utf8_bin DEFAULT NULL,
swollen_joints varchar(5) COLLATE utf8_bin DEFAULT NULL,
stiff_joints varchar(5) COLLATE utf8_bin DEFAULT NULL,
broken_bones varchar(5) COLLATE utf8_bin DEFAULT NULL,
neck_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
back_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
back_surgery varchar(5) COLLATE utf8_bin DEFAULT NULL,
scoliosis varchar(5) COLLATE utf8_bin DEFAULT NULL,
herniated_disc varchar(5) COLLATE utf8_bin DEFAULT NULL,
shoulder_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
elbow_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
wrist_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
hand_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
hip_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
knee_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
ankle_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
foot_problems varchar(5) COLLATE utf8_bin DEFAULT NULL,
insulin_dependent_diabetes varchar(5) COLLATE utf8_bin DEFAULT NULL,
noninsulin_dependent_diabetes varchar(5) COLLATE utf8_bin DEFAULT NULL,
hypothyroidism varchar(5) COLLATE utf8_bin DEFAULT NULL,
hyperthyroidism varchar(5) COLLATE utf8_bin DEFAULT NULL,
cushing_syndrom varchar(5) COLLATE utf8_bin DEFAULT NULL,
addison_syndrom varchar(5) COLLATE utf8_bin DEFAULT NULL,
additional_notes longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_ros’
-
CREATE TABLE form_ros (
id int(11) NOT NULL AUTO_INCREMENT,
pid int(11) NOT NULL,
activity int(11) NOT NULL DEFAULT ‘1’,
`date` datetime DEFAULT NULL,
weight_change varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
weakness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fatigue varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
anorexia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fever varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
chills varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
night_sweats varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
insomnia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
irritability varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
heat_or_cold varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
intolerance varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
change_in_vision varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
glaucoma_history varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
eye_pain varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
irritation varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
redness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
excessive_tearing varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
double_vision varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
blind_spots varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
photophobia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hearing_loss varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
discharge varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pain varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
vertigo varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
tinnitus varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
frequent_colds varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
sore_throat varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
sinus_problems varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
post_nasal_drip varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
nosebleed varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
snoring varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
apnea varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
breast_mass varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
breast_discharge varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
biopsy varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
abnormal_mammogram varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
cough varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
sputum varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
shortness_of_breath varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
wheezing varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hemoptsyis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
asthma varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
copd varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
chest_pain varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
palpitation varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
syncope varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pnd varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
doe varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
orthopnea varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
peripheal varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
edema varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
legpain_cramping varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
history_murmur varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
arrythmia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
heart_problem varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
dysphagia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
heartburn varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
bloating varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
belching varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
flatulence varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
nausea varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
vomiting varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hematemesis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
gastro_pain varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
food_intolerance varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hepatitis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
jaundice varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hematochezia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
changed_bowel varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
diarrhea varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
constipation varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
polyuria varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
polydypsia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
dysuria varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hematuria varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
frequency varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
urgency varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
incontinence varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
renal_stones varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
utis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hesitancy varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
dribbling varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
stream varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
nocturia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
erections varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
ejaculations varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
g varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
p varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
ap varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
lc varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
mearche varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
menopause varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
lmp varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_frequency varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_flow varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_symptoms varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
abnormal_hair_growth varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
f_hirsutism varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
joint_pain varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
swelling varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
m_redness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
m_warm varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
m_stiffness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
muscle varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
m_aches varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fms varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
arthritis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
loc varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
seizures varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
stroke varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
tia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
n_numbness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
n_weakness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
paralysis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
intellectual_decline varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
memory_problems varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
dementia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
n_headache varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
s_cancer varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
psoriasis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
s_acne varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
s_other varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
s_disease varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
p_diagnosis varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
p_medication varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
depression varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
anxiety varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
social_difficulties varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
thyroid_problems varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
diabetes varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
abnormal_blood varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
anemia varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fh_blood_problems varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
bleeding_problems varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
allergies varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
frequent_illness varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hiv varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
hai_status varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_soap’
-
CREATE TABLE form_soap (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) DEFAULT ‘0’,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT ‘0’,
activity tinyint(4) DEFAULT ‘0’,
subjective text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
objective text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
assessment text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
plan text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘form_vitals’
-
CREATE TABLE form_vitals (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) DEFAULT ‘0’,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
authorized tinyint(4) DEFAULT ‘0’,
activity tinyint(4) DEFAULT ‘0’,
bps varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
bpd varchar(40) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
weight float(5,2) DEFAULT ‘0.00’,
height float(5,2) DEFAULT ‘0.00’,
temperature float(5,2) DEFAULT ‘0.00’,
temp_method varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pulse float(5,2) DEFAULT ‘0.00’,
respiration float(5,2) DEFAULT ‘0.00’,
note varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
BMI float(4,1) DEFAULT ‘0.0’,
BMI_status varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
waist_circ float(5,2) DEFAULT ‘0.00’,
head_circ float(4,2) DEFAULT ‘0.00’,
oxygen_saturation float(5,2) DEFAULT ‘0.00’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_acl’
-
CREATE TABLE gacl_acl (
id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘system’,
allow int(11) NOT NULL DEFAULT ‘0’,
enabled int(11) NOT NULL DEFAULT ‘0’,
return_value text CHARACTER SET latin1,
note text CHARACTER SET latin1,
updated_date int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
KEY enabled_acl (enabled),
KEY section_value_acl (section_value),
KEY updated_date_acl (updated_date)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_acl_sections’
-
CREATE TABLE gacl_acl_sections (
id int(11) NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(230) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY value_acl_sections (`value`),
KEY hidden_acl_sections (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_acl_seq’
-
CREATE TABLE gacl_acl_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aco’
-
CREATE TABLE gacl_aco (
id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY section_value_value_aco (section_value,`value`),
KEY hidden_aco (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aco_map’
-
CREATE TABLE gacl_aco_map (
acl_id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (acl_id,section_value,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aco_sections’
-
CREATE TABLE gacl_aco_sections (
id int(11) NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(230) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY value_aco_sections (`value`),
KEY hidden_aco_sections (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aco_sections_seq’
-
CREATE TABLE gacl_aco_sections_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aco_seq’
-
CREATE TABLE gacl_aco_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro’
-
CREATE TABLE gacl_aro (
id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY section_value_value_aro (section_value,`value`),
KEY hidden_aro (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_groups’
-
CREATE TABLE gacl_aro_groups (
id int(11) NOT NULL DEFAULT ‘0’,
parent_id int(11) NOT NULL DEFAULT ‘0’,
lft int(11) NOT NULL DEFAULT ‘0’,
rgt int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET latin1 NOT NULL,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (id,`value`),
UNIQUE KEY value_aro_groups (`value`),
KEY parent_id_aro_groups (parent_id),
KEY lft_rgt_aro_groups (lft,rgt)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_groups_id_seq’
-
CREATE TABLE gacl_aro_groups_id_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_groups_map’
-
CREATE TABLE gacl_aro_groups_map (
acl_id int(11) NOT NULL DEFAULT ‘0’,
group_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (acl_id,group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_map’
-
CREATE TABLE gacl_aro_map (
acl_id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (acl_id,section_value,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_sections’
-
CREATE TABLE gacl_aro_sections (
id int(11) NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(230) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY value_aro_sections (`value`),
KEY hidden_aro_sections (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_sections_seq’
-
CREATE TABLE gacl_aro_sections_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_aro_seq’
-
CREATE TABLE gacl_aro_seq (
id int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_axo’
-
CREATE TABLE gacl_axo (
id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY section_value_value_axo (section_value,`value`),
KEY hidden_axo (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_axo_groups’
-
CREATE TABLE gacl_axo_groups (
id int(11) NOT NULL DEFAULT ‘0’,
parent_id int(11) NOT NULL DEFAULT ‘0’,
lft int(11) NOT NULL DEFAULT ‘0’,
rgt int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET latin1 NOT NULL,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (id,`value`),
UNIQUE KEY value_axo_groups (`value`),
KEY parent_id_axo_groups (parent_id),
KEY lft_rgt_axo_groups (lft,rgt)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_axo_groups_map’
-
CREATE TABLE gacl_axo_groups_map (
acl_id int(11) NOT NULL DEFAULT ‘0’,
group_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (acl_id,group_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_axo_map’
-
CREATE TABLE gacl_axo_map (
acl_id int(11) NOT NULL DEFAULT ‘0’,
section_value varchar(150) CHARACTER SET latin1 NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (acl_id,section_value,`value`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_axo_sections’
-
CREATE TABLE gacl_axo_sections (
id int(11) NOT NULL DEFAULT ‘0’,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
order_value int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(230) CHARACTER SET latin1 NOT NULL,
hidden int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (id),
UNIQUE KEY value_axo_sections (`value`),
KEY hidden_axo_sections (hidden)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_groups_aro_map’
-
CREATE TABLE gacl_groups_aro_map (
group_id int(11) NOT NULL DEFAULT ‘0’,
aro_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (group_id,aro_id),
KEY aro_id (aro_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_groups_axo_map’
-
CREATE TABLE gacl_groups_axo_map (
group_id int(11) NOT NULL DEFAULT ‘0’,
axo_id int(11) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (group_id,axo_id),
KEY axo_id (axo_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gacl_phpgacl’
-
CREATE TABLE gacl_phpgacl (
`name` varchar(230) CHARACTER SET latin1 NOT NULL,
`value` varchar(150) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘geo_country_reference’
-
CREATE TABLE geo_country_reference (
countries_id int(5) NOT NULL AUTO_INCREMENT,
countries_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
countries_iso_code_2 char(2) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
countries_iso_code_3 char(3) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (countries_id),
KEY IDX_COUNTRIES_NAME (countries_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘geo_zone_reference’
-
CREATE TABLE geo_zone_reference (
zone_id int(5) NOT NULL AUTO_INCREMENT,
zone_country_id int(5) NOT NULL DEFAULT ‘0’,
zone_code varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
zone_name varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (zone_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘globals’
-
CREATE TABLE globals (
gl_name varchar(63) CHARACTER SET latin1 NOT NULL,
gl_index int(11) NOT NULL DEFAULT ‘0’,
gl_value varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (gl_name,gl_index)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘gprelations’
-
CREATE TABLE gprelations (
type1 int(2) NOT NULL,
id1 bigint(20) NOT NULL,
type2 int(2) NOT NULL,
id2 bigint(20) NOT NULL,
PRIMARY KEY (type1,id1,type2,id2),
KEY key2 (type2,id2)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘general purpose relations’;
-
- Table structure for table ‘groups’
-
CREATE TABLE groups (
id bigint(20) NOT NULL AUTO_INCREMENT,
`name` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`user` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘history_data’
-
CREATE TABLE history_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
coffee longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
tobacco longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
alcohol longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
sleep_patterns longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
exercise_patterns longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
seatbelt_use longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
counseling longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
hazardous_activities longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
last_breast_exam varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_mammogram varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_gynocological_exam varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_rectal_exam varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_prostate_exam varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_physical_exam varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_sigmoidoscopy_colonoscopy varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_ecg varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_cardiac_echo varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_retinal varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_fluvax varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_pneuvax varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_ldl varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_hemoglobin varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_psa varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
last_exam_results varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
history_mother longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
history_father longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
history_siblings longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
history_offspring longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
history_spouse longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_cancer longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_tuberculosis longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_diabetes longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_high_blood_pressure longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_heart_problems longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_stroke longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_epilepsy longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_mental_illness longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
relatives_suicide longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
cataract_surgery datetime DEFAULT NULL,
tonsillectomy datetime DEFAULT NULL,
cholecystestomy datetime DEFAULT NULL,
heart_surgery datetime DEFAULT NULL,
hysterectomy datetime DEFAULT NULL,
hernia_repair datetime DEFAULT NULL,
hip_replacement datetime DEFAULT NULL,
knee_replacement datetime DEFAULT NULL,
appendectomy datetime DEFAULT NULL,
`date` datetime DEFAULT NULL,
pid bigint(20) NOT NULL DEFAULT ‘0’,
name_1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
value_1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
name_2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
value_2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
additional_history text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
exams text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
usertext11 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext12 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext13 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext14 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext15 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext16 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext17 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext18 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext19 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext20 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext21 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext22 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext23 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext24 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext25 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext26 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext27 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext28 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext29 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext30 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userdate11 date DEFAULT NULL,
userdate12 date DEFAULT NULL,
userdate13 date DEFAULT NULL,
userdate14 date DEFAULT NULL,
userdate15 date DEFAULT NULL,
userarea11 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
userarea12 text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
recreational_drugs longtext COLLATE utf8_bin,
PRIMARY KEY (id),
KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘immunizations’
-
CREATE TABLE immunizations (
id bigint(20) NOT NULL AUTO_INCREMENT,
patient_id int(11) DEFAULT NULL,
administered_date date DEFAULT NULL,
immunization_id int(11) DEFAULT NULL,
manufacturer varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
lot_number varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
administered_by_id bigint(20) DEFAULT NULL,
education_date date DEFAULT NULL,
note text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
create_date datetime DEFAULT NULL,
update_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
created_by bigint(20) DEFAULT NULL,
updated_by bigint(20) DEFAULT NULL,
vis_date date DEFAULT NULL COMMENT ‘Date of VIS Statement’,
administered_by varchar(255) COLLATE utf8_bin DEFAULT NULL COMMENT ‘Alternative to administered_by_id’,
cvx_code int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘insurance_companies’
-
CREATE TABLE insurance_companies (
id int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
attn varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
cms_id varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
freeb_type tinyint(2) DEFAULT NULL,
x12_receiver_id varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_default_partner_id int(11) DEFAULT NULL,
alt_cms_id varchar(15) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘insurance_data’
-
CREATE TABLE insurance_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
`type` enum(‘primary’,‘secondary’,‘tertiary’) CHARACTER SET latin1 DEFAULT NULL,
provider varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
plan_name varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
policy_number varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
group_number varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_lname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_mname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_fname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_relationship varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_ss varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_DOB date DEFAULT NULL,
subscriber_street varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_postal_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_state varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_country varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_phone varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer_street varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer_postal_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer_state varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer_country varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
subscriber_employer_city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
copay varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`date` date NOT NULL DEFAULT ‘0000-00-00’,
pid bigint(20) NOT NULL DEFAULT ‘0’,
subscriber_sex varchar(25) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
accept_assignment varchar(5) COLLATE utf8_bin NOT NULL DEFAULT ‘TRUE’,
PRIMARY KEY (id),
UNIQUE KEY pid_type_date (pid,`type`,`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘insurance_numbers’
-
CREATE TABLE insurance_numbers (
id int(11) NOT NULL DEFAULT ‘0’,
provider_id int(11) NOT NULL DEFAULT ‘0’,
insurance_company_id int(11) DEFAULT NULL,
provider_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
rendering_provider_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
group_number varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
provider_number_type varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
rendering_provider_number_type varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘integration_mapping’
-
CREATE TABLE integration_mapping (
id int(11) NOT NULL DEFAULT ‘0’,
foreign_id int(11) NOT NULL DEFAULT ‘0’,
foreign_table varchar(125) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
local_id int(11) NOT NULL DEFAULT ‘0’,
local_table varchar(125) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY foreign_id (foreign_id,foreign_table,local_id,local_table)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘issue_encounter’
-
CREATE TABLE issue_encounter (
pid int(11) NOT NULL,
list_id int(11) NOT NULL,
encounter int(11) NOT NULL,
resolved tinyint(1) NOT NULL,
PRIMARY KEY (pid,list_id,encounter)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lang_constants’
-
CREATE TABLE lang_constants (
cons_id int(11) NOT NULL AUTO_INCREMENT,
constant_name varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY cons_id (cons_id),
KEY cons_name (constant_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lang_custom’
-
CREATE TABLE lang_custom (
lang_description varchar(100) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
lang_code char(2) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
constant_name varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
definition mediumtext CHARACTER SET latin1 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lang_definitions’
-
CREATE TABLE lang_definitions (
def_id int(11) NOT NULL AUTO_INCREMENT,
cons_id int(11) NOT NULL DEFAULT ‘0’,
lang_id int(11) NOT NULL DEFAULT ‘0’,
definition mediumtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
UNIQUE KEY def_id (def_id),
KEY definition (definition(100))
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lang_languages’
-
CREATE TABLE lang_languages (
lang_id int(11) NOT NULL AUTO_INCREMENT,
lang_code char(2) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
lang_description varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
UNIQUE KEY lang_id (lang_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘layout_options’
-
CREATE TABLE layout_options (
form_id varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
field_id varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
group_name varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
title varchar(63) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
seq int(11) NOT NULL DEFAULT ‘0’,
data_type tinyint(3) NOT NULL DEFAULT ‘0’,
uor tinyint(1) NOT NULL DEFAULT ‘1’,
fld_length int(11) NOT NULL DEFAULT ‘15’,
max_length int(11) NOT NULL DEFAULT ‘0’,
list_id varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
titlecols tinyint(3) NOT NULL DEFAULT ‘1’,
datacols tinyint(3) NOT NULL DEFAULT ‘1’,
default_value varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
edit_options varchar(36) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
description text COLLATE utf8_bin,
PRIMARY KEY (form_id,field_id,seq)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lbf_data’
-
CREATE TABLE lbf_data (
form_id int(11) NOT NULL AUTO_INCREMENT COMMENT ‘references forms.form_id’,
field_id varchar(31) CHARACTER SET latin1 NOT NULL COMMENT ‘references layout_options.field_id’,
field_value text CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (form_id,field_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘contains all data from layout-based forms’;
-
- Table structure for table ‘lists’
-
CREATE TABLE lists (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`type` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
begdate date DEFAULT NULL,
enddate date DEFAULT NULL,
returndate date DEFAULT NULL,
occurrence int(11) DEFAULT ‘0’,
classification int(11) DEFAULT ‘0’,
referredby varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
extrainfo varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
diagnosis varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
comments longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
outcome int(11) NOT NULL DEFAULT ‘0’,
destination varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
reinjury_id bigint(20) NOT NULL DEFAULT ‘0’,
injury_part varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
injury_type varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
injury_grade varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
reaction varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
external_allergyid int(11) DEFAULT NULL,
erx_source enum(‘0’,‘1’) COLLATE utf8_bin NOT NULL DEFAULT ‘0’ COMMENT ‘0-OpenEMR 1-External’,
erx_uploaded enum(‘0’,‘1’) COLLATE utf8_bin NOT NULL DEFAULT ‘0’ COMMENT ‘0-Pending NewCrop upload 1-Uploaded TO NewCrop’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘lists_touch’
-
CREATE TABLE lists_touch (
pid bigint(20) NOT NULL DEFAULT ‘0’,
`type` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
`date` datetime DEFAULT NULL,
PRIMARY KEY (pid,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘list_options’
-
CREATE TABLE list_options (
list_id varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
option_id varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
seq int(11) NOT NULL DEFAULT ‘0’,
is_default tinyint(1) NOT NULL DEFAULT ‘0’,
option_value float NOT NULL DEFAULT ‘0’,
mapping varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
notes varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
PRIMARY KEY (list_id,option_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘log’
-
CREATE TABLE log (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`event` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
comments longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
user_notes longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
patient_id bigint(20) DEFAULT NULL,
success tinyint(1) DEFAULT ‘1’,
`checksum` longtext COLLATE utf8_bin,
crt_user varchar(255) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘notes’
-
CREATE TABLE notes (
id int(11) NOT NULL DEFAULT ‘0’,
foreign_id int(11) NOT NULL DEFAULT ‘0’,
note varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`owner` int(11) DEFAULT NULL,
`date` datetime DEFAULT NULL,
revision timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id),
KEY foreign_id (`owner`),
KEY foreign_id_2 (foreign_id),
KEY `date` (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘notification_log’
-
CREATE TABLE notification_log (
iLogId int(11) NOT NULL AUTO_INCREMENT,
pid int(7) NOT NULL,
pc_eid int(11) unsigned DEFAULT NULL,
sms_gateway_type varchar(50) CHARACTER SET latin1 NOT NULL,
smsgateway_info varchar(255) CHARACTER SET latin1 NOT NULL,
message text CHARACTER SET latin1 NOT NULL,
email_sender varchar(255) CHARACTER SET latin1 NOT NULL,
email_subject varchar(255) CHARACTER SET latin1 NOT NULL,
`type` enum(‘SMS’,‘Email’) CHARACTER SET latin1 NOT NULL,
patient_info text CHARACTER SET latin1 NOT NULL,
pc_eventDate date NOT NULL,
pc_endDate date NOT NULL,
pc_startTime time NOT NULL,
pc_endTime time NOT NULL,
dSentDateTime datetime NOT NULL,
PRIMARY KEY (iLogId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘notification_settings’
-
CREATE TABLE notification_settings (
SettingsId int(3) NOT NULL AUTO_INCREMENT,
Send_SMS_Before_Hours int(3) NOT NULL,
Send_Email_Before_Hours int(3) NOT NULL,
SMS_gateway_username varchar(100) CHARACTER SET latin1 NOT NULL,
SMS_gateway_password varchar(100) CHARACTER SET latin1 NOT NULL,
SMS_gateway_apikey varchar(100) CHARACTER SET latin1 NOT NULL,
`type` varchar(50) CHARACTER SET latin1 NOT NULL,
PRIMARY KEY (SettingsId)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘onotes’
-
CREATE TABLE onotes (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
body longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_modules’
-
CREATE TABLE openemr_modules (
pn_id int(11) unsigned NOT NULL AUTO_INCREMENT,
pn_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_type int(6) NOT NULL DEFAULT ‘0’,
pn_displayname varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_description varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_regid int(11) unsigned NOT NULL DEFAULT ‘0’,
pn_directory varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_version varchar(10) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_admin_capable tinyint(1) NOT NULL DEFAULT ‘0’,
pn_user_capable tinyint(1) NOT NULL DEFAULT ‘0’,
pn_state tinyint(1) NOT NULL DEFAULT ‘0’,
PRIMARY KEY (pn_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_module_vars’
-
CREATE TABLE openemr_module_vars (
pn_id int(11) unsigned NOT NULL AUTO_INCREMENT,
pn_modname varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_value longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (pn_id),
KEY pn_modname (pn_modname),
KEY pn_name (pn_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_postcalendar_categories’
-
CREATE TABLE openemr_postcalendar_categories (
pc_catid int(11) unsigned NOT NULL AUTO_INCREMENT,
pc_catname varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_catcolor varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_catdesc text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_recurrtype int(1) NOT NULL DEFAULT ‘0’,
pc_enddate date DEFAULT NULL,
pc_recurrspec text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_recurrfreq int(3) NOT NULL DEFAULT ‘0’,
pc_duration bigint(20) NOT NULL DEFAULT ‘0’,
pc_end_date_flag tinyint(1) NOT NULL DEFAULT ‘0’,
pc_end_date_type int(2) DEFAULT NULL,
pc_end_date_freq int(11) NOT NULL DEFAULT ‘0’,
pc_end_all_day tinyint(1) NOT NULL DEFAULT ‘0’,
pc_dailylimit int(2) NOT NULL DEFAULT ‘0’,
pc_cattype int(11) NOT NULL COMMENT ‘Used in grouping categories’,
PRIMARY KEY (pc_catid),
KEY basic_cat (pc_catname,pc_catcolor)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_postcalendar_events’
-
CREATE TABLE openemr_postcalendar_events (
pc_eid int(11) unsigned NOT NULL AUTO_INCREMENT,
pc_catid int(11) NOT NULL DEFAULT ‘0’,
pc_multiple int(10) unsigned NOT NULL,
pc_aid varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_pid varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_title varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_time datetime DEFAULT NULL,
pc_hometext text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_comments int(11) DEFAULT ‘0’,
pc_counter mediumint(8) unsigned DEFAULT ‘0’,
pc_topic int(3) NOT NULL DEFAULT ‘1’,
pc_informant varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_eventDate date NOT NULL DEFAULT ‘0000-00-00’,
pc_endDate date NOT NULL DEFAULT ‘0000-00-00’,
pc_duration bigint(20) NOT NULL DEFAULT ‘0’,
pc_recurrtype int(1) NOT NULL DEFAULT ‘0’,
pc_recurrspec text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_recurrfreq int(3) NOT NULL DEFAULT ‘0’,
pc_startTime time DEFAULT NULL,
pc_endTime time DEFAULT NULL,
pc_alldayevent int(1) NOT NULL DEFAULT ‘0’,
pc_location text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pc_conttel varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_contname varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_contemail varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_website varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_fee varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_eventstatus int(11) NOT NULL DEFAULT ‘0’,
pc_sharing int(11) NOT NULL DEFAULT ‘0’,
pc_language varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_apptstatus varchar(15) COLLATE utf8_bin NOT NULL DEFAULT ‘-’,
pc_prefcatid int(11) NOT NULL DEFAULT ‘0’,
pc_facility smallint(6) NOT NULL DEFAULT ‘0’ COMMENT ‘facility id for this event’,
pc_sendalertsms varchar(3) COLLATE utf8_bin NOT NULL DEFAULT ‘NO’,
pc_sendalertemail varchar(3) COLLATE utf8_bin NOT NULL DEFAULT ‘NO’,
pc_billing_location smallint(6) DEFAULT NULL,
PRIMARY KEY (pc_eid),
KEY basic_event (pc_catid,pc_aid,pc_eventDate,pc_endDate,pc_eventstatus,pc_sharing,pc_topic)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_postcalendar_limits’
-
CREATE TABLE openemr_postcalendar_limits (
pc_limitid int(11) NOT NULL AUTO_INCREMENT,
pc_catid int(11) NOT NULL DEFAULT ‘0’,
pc_starttime time NOT NULL DEFAULT ‘00:00:00’,
pc_endtime time NOT NULL DEFAULT ‘00:00:00’,
pc_limit int(11) NOT NULL DEFAULT ‘1’,
PRIMARY KEY (pc_limitid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_postcalendar_topics’
-
CREATE TABLE openemr_postcalendar_topics (
pc_catid int(11) unsigned NOT NULL AUTO_INCREMENT,
pc_catname varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_catcolor varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pc_catdesc text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (pc_catid),
KEY basic_cat (pc_catname,pc_catcolor)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘openemr_session_info’
-
CREATE TABLE openemr_session_info (
pn_sessid varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pn_ipaddr varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
pn_firstused int(11) NOT NULL DEFAULT ‘0’,
pn_lastused int(11) NOT NULL DEFAULT ‘0’,
pn_uid int(11) NOT NULL DEFAULT ‘0’,
pn_vars blob,
PRIMARY KEY (pn_sessid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘patient_access_offsite’
-
CREATE TABLE patient_access_offsite (
id int(11) NOT NULL AUTO_INCREMENT,
pid int(11) NOT NULL,
portal_username varchar(100) CHARACTER SET latin1 NOT NULL,
portal_pwd varchar(100) CHARACTER SET latin1 NOT NULL,
portal_pwd_status tinyint(4) DEFAULT ‘1’ COMMENT ‘0=>Password Created Through Demographics by The provider or staff. Patient Should Change it at first time it.1=>Pwd updated or created by patient itself’,
PRIMARY KEY (id),
UNIQUE KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘patient_access_onsite’
-
CREATE TABLE patient_access_onsite (
id int(11) NOT NULL AUTO_INCREMENT,
pid int(11) DEFAULT NULL,
portal_username varchar(100) CHARACTER SET latin1 DEFAULT NULL,
portal_pwd varchar(100) CHARACTER SET latin1 DEFAULT NULL,
portal_pwd_status tinyint(4) DEFAULT ‘1’ COMMENT ‘0=>Password Created Through Demographics by The provider or staff. Patient Should Change it at first time it.1=>Pwd updated or created by patient itself’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘patient_data’
-
CREATE TABLE patient_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
financial varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
fname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
lname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
mname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
DOB date DEFAULT NULL,
street varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
postal_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
city varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
state varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
country_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
drivers_license varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
ss varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
occupation longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
phone_home varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
phone_biz varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
phone_contact varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
phone_cell varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pharmacy_id int(11) NOT NULL DEFAULT ‘0’,
`status` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
contact_relationship varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
`date` datetime DEFAULT NULL,
sex varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
referrer varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
referrerID varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
providerID int(11) DEFAULT NULL,
email varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pubpid varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pid bigint(20) NOT NULL DEFAULT ‘0’,
genericname1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
genericval1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
genericname2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
genericval2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
hipaa_mail varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
hipaa_voice varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
hipaa_notice varchar(3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
hipaa_message varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
hipaa_allowsms varchar(3) COLLATE utf8_bin NOT NULL DEFAULT ‘NO’,
hipaa_allowemail varchar(3) COLLATE utf8_bin NOT NULL DEFAULT ‘NO’,
squad varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
fitness int(11) NOT NULL DEFAULT ‘0’,
referral_source varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext3 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext4 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext5 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext6 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext7 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
usertext8 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist1 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist2 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist3 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist4 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist5 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist6 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
userlist7 varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pricelevel varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘standard’,
regdate date DEFAULT NULL COMMENT ‘Registration Date’,
vfc varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
mothersname varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
guardiansname varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
allow_imm_reg_use varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
allow_imm_info_share varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
allow_health_info_ex varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
completed_ad varchar(3) COLLATE utf8_bin NOT NULL DEFAULT ‘NO’,
ad_reviewed date DEFAULT NULL,
race varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
ethnicity varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
ethnoracial varchar(255) COLLATE utf8_bin DEFAULT NULL,
deceased_date datetime DEFAULT NULL,
deceased_reason varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
allow_patient_portal varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
soap_import_status tinyint(4) DEFAULT NULL COMMENT ‘1-Prescription Press 2-Prescription Import 3-Allergy Press 4-Allergy Import’,
UNIQUE KEY pid (pid),
KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘patient_reminders’
-
CREATE TABLE patient_reminders (
id bigint(20) NOT NULL AUTO_INCREMENT,
active tinyint(1) NOT NULL DEFAULT ‘1’ COMMENT ‘1 if active and 0 if not active’,
date_inactivated datetime DEFAULT NULL,
reason_inactivated varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_reminder_inactive_opt’,
due_status varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_reminder_due_opt’,
pid bigint(20) NOT NULL COMMENT ‘id from patient_data table’,
category varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the category item in the rule_action_item table’,
item varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the item column in the rule_action_item table’,
date_created datetime DEFAULT NULL,
date_sent datetime DEFAULT NULL,
voice_status tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 if not sent and 1 if sent’,
sms_status tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 if not sent and 1 if sent’,
email_status tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 if not sent and 1 if sent’,
mail_status tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 if not sent and 1 if sent’,
PRIMARY KEY (id),
KEY pid (pid),
KEY category (category,item)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘payments’
-
CREATE TABLE payments (
id bigint(20) NOT NULL AUTO_INCREMENT,
pid bigint(20) NOT NULL DEFAULT ‘0’,
dtime datetime NOT NULL,
encounter bigint(20) NOT NULL DEFAULT ‘0’,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
method varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`source` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
amount1 decimal(12,2) NOT NULL DEFAULT ‘0.00’,
amount2 decimal(12,2) NOT NULL DEFAULT ‘0.00’,
posted1 decimal(12,2) NOT NULL DEFAULT ‘0.00’,
posted2 decimal(12,2) NOT NULL DEFAULT ‘0.00’,
PRIMARY KEY (id),
KEY pid (pid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘pharmacies’
-
CREATE TABLE pharmacies (
id int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
transmit_method int(11) NOT NULL DEFAULT ‘1’,
email varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘phone_numbers’
-
CREATE TABLE phone_numbers (
id int(11) NOT NULL DEFAULT ‘0’,
country_code varchar(5) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
area_code char(3) CHARACTER SET latin1 DEFAULT NULL,
prefix char(3) CHARACTER SET latin1 DEFAULT NULL,
number varchar(4) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`type` int(11) DEFAULT NULL,
foreign_id int(11) DEFAULT NULL,
PRIMARY KEY (id),
KEY foreign_id (foreign_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘pma_bookmark’
-
CREATE TABLE pma_bookmark (
id int(11) NOT NULL AUTO_INCREMENT,
dbase varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
label varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`query` text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘Bookmarks’;
-
- Table structure for table ‘pma_column_info’
-
CREATE TABLE pma_column_info (
id int(5) unsigned NOT NULL AUTO_INCREMENT,
db_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
table_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
column_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`comment` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
mimetype varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
transformation varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
transformation_options varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id),
UNIQUE KEY db_name (db_name,table_name,column_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘Column Information for phpMyAdmin’;
-
- Table structure for table ‘pma_history’
-
CREATE TABLE pma_history (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
username varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
db varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`table` varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
timevalue timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
sqlquery text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
PRIMARY KEY (id),
KEY username (username,db,`table`,timevalue)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘SQL history’;
-
- Table structure for table ‘pma_pdf_pages’
-
CREATE TABLE pma_pdf_pages (
db_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
page_nr int(10) unsigned NOT NULL AUTO_INCREMENT,
page_descr varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (page_nr),
KEY db_name (db_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘PDF Relationpages for PMA’;
-
- Table structure for table ‘pma_relation’
-
CREATE TABLE pma_relation (
master_db varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
master_table varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
master_field varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
foreign_db varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
foreign_table varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
foreign_field varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (master_db,master_table,master_field),
KEY foreign_field (foreign_db,foreign_table)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘Relation table’;
-
- Table structure for table ‘pma_table_coords’
-
CREATE TABLE pma_table_coords (
db_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
table_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pdf_page_number int(11) NOT NULL DEFAULT ‘0’,
x float unsigned NOT NULL DEFAULT ‘0’,
y float unsigned NOT NULL DEFAULT ‘0’,
PRIMARY KEY (db_name,table_name,pdf_page_number)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘Table coordinates for phpMyAdmin PDF output’;
-
- Table structure for table ‘pma_table_info’
-
CREATE TABLE pma_table_info (
db_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
table_name varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
display_field varchar(64) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (db_name,table_name)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘Table information for phpMyAdmin’;
-
- Table structure for table ‘pnotes’
-
CREATE TABLE pnotes (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
body longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
activity tinyint(4) DEFAULT NULL,
authorized tinyint(4) DEFAULT NULL,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
assigned_to varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
deleted tinyint(4) DEFAULT ‘0’ COMMENT ‘flag indicates note is deleted’,
message_status varchar(20) COLLATE utf8_bin NOT NULL DEFAULT ‘New’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘prescriptions’
-
CREATE TABLE prescriptions (
id int(11) NOT NULL AUTO_INCREMENT,
patient_id int(11) DEFAULT NULL,
filled_by_id int(11) DEFAULT NULL,
pharmacy_id int(11) DEFAULT NULL,
date_added date DEFAULT NULL,
date_modified date DEFAULT NULL,
provider_id int(11) DEFAULT NULL,
start_date date DEFAULT NULL,
drug varchar(150) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
drug_id int(11) NOT NULL DEFAULT ‘0’,
form int(3) DEFAULT NULL,
dosage varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
quantity varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
size float unsigned DEFAULT NULL,
unit int(11) DEFAULT NULL,
route int(11) DEFAULT NULL,
`interval` int(11) DEFAULT NULL,
substitute int(11) DEFAULT NULL,
refills int(11) DEFAULT NULL,
per_refill int(11) DEFAULT NULL,
filled_date date DEFAULT NULL,
medication int(11) DEFAULT NULL,
note text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
active int(11) NOT NULL DEFAULT ‘1’,
site varchar(50) COLLATE utf8_bin DEFAULT NULL,
prescriptionguid varchar(50) COLLATE utf8_bin DEFAULT NULL,
erx_source tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0-OpenEMR 1-External’,
rxnorm_drugcode int(11) DEFAULT NULL,
`datetime` datetime DEFAULT NULL,
`user` varchar(50) COLLATE utf8_bin DEFAULT NULL,
erx_uploaded tinyint(4) NOT NULL DEFAULT ‘0’ COMMENT ‘0-Pending NewCrop upload 1-Uploaded to NewCrop’,
encounter int(11) DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘prices’
-
CREATE TABLE prices (
pr_id varchar(11) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pr_selector varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’ COMMENT ‘template selector for drugs, empty for codes’,
pr_level varchar(31) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
pr_price decimal(12,2) NOT NULL DEFAULT ‘0.00’ COMMENT ‘price in local currency’,
PRIMARY KEY (pr_id,pr_selector,pr_level)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘procedure_order’
-
CREATE TABLE procedure_order (
procedure_order_id bigint(20) NOT NULL AUTO_INCREMENT,
procedure_type_id bigint(20) NOT NULL COMMENT ‘references procedure_type.procedure_type_id’,
provider_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references users.id’,
patient_id bigint(20) NOT NULL COMMENT ‘references patient_data.pid’,
encounter_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references form_encounter.encounter’,
date_collected datetime DEFAULT NULL COMMENT ‘time specimen collected’,
date_ordered date DEFAULT NULL,
order_priority varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
order_status varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘pending,routed,complete,canceled’,
patient_instructions text CHARACTER SET latin1 NOT NULL,
activity tinyint(1) NOT NULL DEFAULT ‘1’ COMMENT ‘0 if deleted’,
control_id bigint(20) NOT NULL COMMENT ‘This is the CONTROL ID that is sent back from lab’,
PRIMARY KEY (procedure_order_id),
KEY datepid (date_ordered,patient_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘procedure_report’
-
CREATE TABLE procedure_report (
procedure_report_id bigint(20) NOT NULL AUTO_INCREMENT,
procedure_order_id bigint(20) DEFAULT NULL COMMENT ‘references procedure_order.procedure_order_id’,
date_collected datetime DEFAULT NULL,
date_report date DEFAULT NULL,
`source` bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references users.id, who entered this data’,
specimen_num varchar(63) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
report_status varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘received,complete,error’,
review_status varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘received’ COMMENT ‘panding reivew status: received,reviewed’,
PRIMARY KEY (procedure_report_id),
KEY procedure_order_id (procedure_order_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘procedure_result’
-
CREATE TABLE procedure_result (
procedure_result_id bigint(20) NOT NULL AUTO_INCREMENT,
procedure_report_id bigint(20) NOT NULL COMMENT ‘references procedure_report.procedure_report_id’,
procedure_type_id bigint(20) NOT NULL COMMENT ‘references procedure_type.procedure_type_id’,
`date` datetime DEFAULT NULL COMMENT ‘lab-provided date specific to this result’,
facility varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘lab-provided testing facility ID’,
units varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
result varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
`range` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
abnormal varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘no,yes,high,low’,
comments text CHARACTER SET latin1 NOT NULL COMMENT ‘comments from the lab’,
document_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references documents.id if this result is a document’,
result_status varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘preliminary, cannot be done, final, corrected, incompete…etc.’,
PRIMARY KEY (procedure_result_id),
KEY procedure_report_id (procedure_report_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘procedure_type’
-
CREATE TABLE procedure_type (
procedure_type_id bigint(20) NOT NULL AUTO_INCREMENT,
parent bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references procedure_type.procedure_type_id’,
`name` varchar(63) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘name for this category, procedure or result type’,
lab_id bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘references users.id, 0 means default to parent’,
procedure_code varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘code identifying this procedure’,
procedure_type varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘see list proc_type’,
body_site varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘where to do injection, e.g. arm, buttok’,
specimen varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘blood, urine, saliva, etc.’,
route_admin varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘oral, injection’,
laterality varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘left, right, …’,
description varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘descriptive text for procedure_code’,
standard_code varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘industry standard code type and code (e.g. CPT4:12345)’,
related_code varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘suggested code(s) for followup services if result is abnormal’,
units varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘default for procedure_result.units’,
`range` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘default for procedure_result.range’,
seq int(11) NOT NULL DEFAULT ‘0’ COMMENT ‘sequence number for ordering’,
PRIMARY KEY (procedure_type_id),
KEY parent (parent)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘registry’
-
CREATE TABLE registry (
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state tinyint(4) DEFAULT NULL,
`directory` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
id bigint(20) NOT NULL AUTO_INCREMENT,
sql_run tinyint(4) DEFAULT NULL,
unpackaged tinyint(4) DEFAULT NULL,
`date` datetime DEFAULT NULL,
priority int(11) DEFAULT ‘0’,
category varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
nickname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_action’
-
CREATE TABLE rule_action (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the id column in the clinical_rules table’,
group_id bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘Contains group id to identify collection of targets in a rule’,
category varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the category item in the rule_action_item table’,
item varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the item column in the rule_action_item table’,
KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_action_item’
-
CREATE TABLE rule_action_item (
category varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_action_category’,
item varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_action’,
clin_rem_link varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Custom html link in clinical reminder widget’,
reminder_message text CHARACTER SET latin1 NOT NULL COMMENT ‘Custom message in patient reminder’,
custom_flag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 indexed to rule_patient_data, 0 indexed within main schema’,
PRIMARY KEY (category,item)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_filter’
-
CREATE TABLE rule_filter (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the id column in the clinical_rules table’,
include_flag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is exclude and 1 is include’,
required_flag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is required and 1 is optional’,
method varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_filters’,
method_detail varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options lists rule__intervals’,
`value` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_patient_data’
-
CREATE TABLE rule_patient_data (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
pid bigint(20) NOT NULL,
category varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the category item in the rule_action_item table’,
item varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the item column in the rule_action_item table’,
complete varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list yesno’,
result varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (id),
KEY pid (pid),
KEY category (category,item)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_reminder’
-
CREATE TABLE rule_reminder (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the id column in the clinical_rules table’,
method varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_reminder_methods’,
method_detail varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_reminder_intervals’,
`value` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘rule_target’
-
CREATE TABLE rule_target (
id varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to the id column in the clinical_rules table’,
group_id bigint(20) NOT NULL DEFAULT ‘1’ COMMENT ‘Contains group id to identify collection of targets in a rule’,
include_flag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is exclude and 1 is include’,
required_flag tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘0 is required and 1 is optional’,
method varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Maps to list_options list rule_targets’,
`value` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘Data is dependent on the method’,
`interval` bigint(20) NOT NULL DEFAULT ‘0’ COMMENT ‘Only used in interval entries’,
KEY id (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘sequences’
-
CREATE TABLE sequences (
id int(11) unsigned NOT NULL DEFAULT ‘0’
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘standardized_tables_track’
-
CREATE TABLE standardized_tables_track (
id int(11) NOT NULL AUTO_INCREMENT,
imported_date datetime DEFAULT NULL,
`name` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘name of standardized tables such as RXNORM’,
revision_version varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’ COMMENT ‘revision of standardized tables that were imported’,
revision_date datetime DEFAULT NULL COMMENT ‘revision of standardized tables that were imported’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘syndromic_surveillance’
-
CREATE TABLE syndromic_surveillance (
id bigint(20) NOT NULL AUTO_INCREMENT,
lists_id bigint(20) NOT NULL,
submission_date datetime NOT NULL,
filename varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (id),
KEY lists_id (lists_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘template_users’
-
CREATE TABLE template_users (
tu_id int(11) NOT NULL AUTO_INCREMENT,
tu_user_id int(11) DEFAULT NULL,
tu_facility_id int(11) DEFAULT NULL,
tu_template_id int(11) DEFAULT NULL,
tu_template_order int(11) DEFAULT NULL,
PRIMARY KEY (tu_id),
UNIQUE KEY templateuser (tu_user_id,tu_template_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘transactions’
-
CREATE TABLE transactions (
id bigint(20) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
title varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
body longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
pid bigint(20) DEFAULT NULL,
`user` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
groupname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
authorized tinyint(4) DEFAULT NULL,
refer_date date DEFAULT NULL,
refer_from int(11) NOT NULL DEFAULT ‘0’,
refer_to int(11) NOT NULL DEFAULT ‘0’,
refer_diag varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
refer_risk_level varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
refer_vitals tinyint(1) NOT NULL DEFAULT ‘0’,
refer_external tinyint(1) NOT NULL DEFAULT ‘0’,
refer_related_code varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
reply_date date DEFAULT NULL,
reply_from varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
reply_init_diag varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
reply_final_diag varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
reply_documents varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘’,
reply_findings text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
reply_services text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
reply_recommend text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
reply_rx_refer text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
refer_reply_date date DEFAULT NULL,
reply_related_code varchar(255) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_accountgroups’
-
CREATE TABLE t_accountgroups (
F_Number tinyint(3) unsigned NOT NULL AUTO_INCREMENT,
F_GroupName varchar(50) CHARACTER SET latin1 DEFAULT NULL,
PRIMARY KEY (F_Number)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_accounts’
-
CREATE TABLE t_accounts (
F_Number int(11) NOT NULL,
F_Name varchar(100) CHARACTER SET latin1 DEFAULT NULL,
F_DefaultGroupNumber tinyint(3) DEFAULT NULL,
F_Deleted tinyint(1) DEFAULT NULL,
PRIMARY KEY (F_Number)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_balances’
-
CREATE TABLE t_balances (
F_AccountNumber int(11) NOT NULL,
F_Balance decimal(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_eobs’
-
CREATE TABLE t_eobs (
F_AutoNumber int(10) unsigned NOT NULL AUTO_INCREMENT,
F_LedgerNumber int(11) DEFAULT NULL,
F_FileName varchar(200) CHARACTER SET latin1 DEFAULT NULL,
F_CreatedBy smallint(6) DEFAULT NULL,
F_CreatedDate datetime DEFAULT NULL,
F_Deleted tinyint(1) DEFAULT NULL,
F_DeletedBy smallint(6) DEFAULT NULL,
F_DeletedDateTime datetime DEFAULT NULL,
PRIMARY KEY (F_AutoNumber)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_insuranceverification’
-
CREATE TABLE t_insuranceverification (
F_AutoNumber int(11) NOT NULL AUTO_INCREMENT,
F_ApptDate date DEFAULT NULL,
F_ApptTime time DEFAULT NULL,
F_PatientNumber bigint(20) DEFAULT NULL,
F_PatientName varchar(255) CHARACTER SET latin1 DEFAULT NULL,
F_SickCopay decimal(7,2) DEFAULT NULL,
F_SickCoins tinyint(3) DEFAULT NULL,
F_SickResponsibility decimal(7,2) DEFAULT NULL,
F_WellCopay decimal(7,2) DEFAULT NULL,
F_WellCoins tinyint(3) DEFAULT NULL,
F_WellResponsibility decimal(7,2) DEFAULT NULL,
F_DeductibleRemaining decimal(7,2) DEFAULT NULL,
F_Insurance int(11) DEFAULT NULL,
F_Email tinyint(1) DEFAULT NULL,
F_Notes varchar(255) CHARACTER SET latin1 DEFAULT NULL,
F_Issue tinyint(1) DEFAULT NULL,
F_LastUpdatedBy smallint(6) DEFAULT NULL,
F_LastUpdate datetime DEFAULT NULL,
PRIMARY KEY (F_AutoNumber)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_invoices’
-
CREATE TABLE t_invoices (
F_AutoNumber int(10) unsigned NOT NULL AUTO_INCREMENT,
F_AccountNumber int(11) DEFAULT NULL,
F_VisitDate date DEFAULT NULL,
F_FileName varchar(200) CHARACTER SET latin1 DEFAULT NULL,
F_CreatedBy smallint(6) DEFAULT NULL,
F_CreatedDate datetime DEFAULT NULL,
F_Deleted tinyint(1) DEFAULT NULL,
F_DeletedBy smallint(6) DEFAULT NULL,
F_DeletedDateTime datetime DEFAULT NULL,
PRIMARY KEY (F_AutoNumber)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_ledger’
-
CREATE TABLE t_ledger (
F_AutoNumber int(11) NOT NULL AUTO_INCREMENT,
F_AccountNumber int(11) DEFAULT NULL,
F_VisitDate date DEFAULT NULL,
F_PaymentDate date DEFAULT NULL,
F_PaidBy int(11) DEFAULT NULL,
F_GroupNumber tinyint(3) DEFAULT NULL,
F_IsInternalTransfer tinyint(1) DEFAULT NULL,
F_PaidAmount decimal(8,2) DEFAULT NULL,
F_CrDr tinyint(1) DEFAULT NULL,
F_SubmittedAmount decimal(8,2) DEFAULT NULL,
F_WriteOff decimal(8,2) DEFAULT NULL,
F_Balance decimal(8,2) DEFAULT NULL,
F_DailyBalance decimal(8,2) DEFAULT NULL,
F_IsCopayCoins tinyint(1) DEFAULT NULL,
F_PaymentMethod tinyint(2) DEFAULT NULL,
F_CheckNumber varchar(100) CHARACTER SET latin1 DEFAULT NULL,
F_CheckDate date DEFAULT NULL,
F_CheckClearedDate date DEFAULT NULL,
F_Notes varchar(200) CHARACTER SET latin1 DEFAULT NULL,
F_CreatedBy smallint(6) DEFAULT NULL,
F_CreatedDate datetime DEFAULT NULL,
F_UpdatedBy smallint(6) DEFAULT NULL,
F_UpdatedDate datetime DEFAULT NULL,
F_Deleted tinyint(1) DEFAULT NULL,
PRIMARY KEY (F_AutoNumber),
KEY F_AccountNumber (F_AccountNumber)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘t_users’
-
CREATE TABLE t_users (
F_AutoNumber smallint(6) NOT NULL AUTO_INCREMENT,
F_UserId varchar(10) CHARACTER SET latin1 DEFAULT NULL,
F_UserName varchar(50) CHARACTER SET latin1 DEFAULT NULL,
F_Password varchar(100) CHARACTER SET latin1 DEFAULT NULL,
F_Email varchar(50) CHARACTER SET latin1 DEFAULT NULL,
F_Admin tinyint(1) DEFAULT NULL,
F_Deleted tinyint(1) DEFAULT NULL,
F_LoggedOn tinyint(1) DEFAULT NULL,
F_SessionId varchar(100) CHARACTER SET latin1 DEFAULT NULL,
F_Accounts tinyint(1) DEFAULT NULL,
PRIMARY KEY (F_AutoNumber)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘users’
-
CREATE TABLE users (
id bigint(20) NOT NULL AUTO_INCREMENT,
username varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`password` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
authorized tinyint(4) DEFAULT NULL,
info longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci,
`source` tinyint(4) DEFAULT NULL,
fname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
mname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
lname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
federaltaxid varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
federaldrugid varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
upin varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
facility varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
facility_id int(11) NOT NULL DEFAULT ‘0’,
see_auth int(11) NOT NULL DEFAULT ‘1’,
active tinyint(1) NOT NULL DEFAULT ‘1’,
npi varchar(15) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
title varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
specialty varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
billname varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
email varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
url varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
assistant varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
organization varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
valedictory varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
street varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
streetb varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
city varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
zip varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
street2 varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
streetb2 varchar(60) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
city2 varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
state2 varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
zip2 varchar(20) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
phone varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
fax varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
phonew1 varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
phonew2 varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
phonecell varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
notes text CHARACTER SET utf8 COLLATE utf8_unicode_ci,
cal_ui tinyint(4) NOT NULL DEFAULT ‘1’,
taxonomy varchar(30) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT ‘207Q00000X’,
ssi_relayhealth varchar(64) COLLATE utf8_bin DEFAULT NULL,
calendar tinyint(1) NOT NULL DEFAULT ‘0’ COMMENT ‘1 = appears in calendar’,
abook_type varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
pwd_expiration_date date DEFAULT NULL,
pwd_history1 longtext COLLATE utf8_bin,
pwd_history2 longtext COLLATE utf8_bin,
default_warehouse varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
irnpool varchar(31) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
state_license_number varchar(25) COLLATE utf8_bin DEFAULT NULL,
newcrop_user_role varchar(30) COLLATE utf8_bin DEFAULT NULL,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘users_facility’
-
CREATE TABLE users_facility (
tablename varchar(64) CHARACTER SET latin1 NOT NULL,
table_id int(11) NOT NULL,
facility_id int(11) NOT NULL,
PRIMARY KEY (tablename,table_id,facility_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT=‘joins users or patient_data to facility table’;
-
- Table structure for table ‘user_settings’
-
CREATE TABLE user_settings (
setting_user bigint(20) NOT NULL DEFAULT ‘0’,
setting_label varchar(63) CHARACTER SET latin1 NOT NULL,
setting_value varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
PRIMARY KEY (setting_user,setting_label)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘version’
-
CREATE TABLE version (
v_major int(11) NOT NULL DEFAULT ‘0’,
v_minor int(11) NOT NULL DEFAULT ‘0’,
v_patch int(11) NOT NULL DEFAULT ‘0’,
v_tag varchar(31) CHARACTER SET latin1 NOT NULL DEFAULT ‘’,
v_database int(11) NOT NULL DEFAULT ‘0’
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
-
- Table structure for table ‘x12_partners’
-
CREATE TABLE x12_partners (
id int(11) NOT NULL DEFAULT ‘0’,
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
id_number varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_sender_id varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_receiver_id varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
x12_version varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
processing_format enum(‘standard’,‘medi-cal’,‘cms’,‘proxymed’) CHARACTER SET latin1 DEFAULT NULL,
x12_isa05 char(2) COLLATE utf8_bin NOT NULL DEFAULT ‘ZZ’,
x12_isa07 char(2) COLLATE utf8_bin NOT NULL DEFAULT ‘ZZ’,
x12_isa14 char(1) COLLATE utf8_bin NOT NULL DEFAULT ‘0’,
x12_isa15 char(1) COLLATE utf8_bin NOT NULL DEFAULT ‘P’,
x12_gs02 varchar(15) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
x12_per06 varchar(80) COLLATE utf8_bin NOT NULL DEFAULT ‘’,
PRIMARY KEY (id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;