Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query
x
 
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count: Time taken:
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
xxxxxxxxxx
 
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:
Some errors have been detected on the server!
Please look at the bottom of this window.

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Page number:
> >>
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
abg_settings 0 MyISAM latin1_swedish_ci 1 KiB -
acceptissues 0 InnoDB latin1_swedish_ci 16 KiB -
acceptissue_details 0 InnoDB latin1_swedish_ci 16 KiB -
account_groups 0 MyISAM latin1_swedish_ci 1 KiB -
addictions 0 InnoDB latin1_swedish_ci 16 KiB -
addresses 257,218 InnoDB latin1_swedish_ci 23.6 MiB -
adiagnosis 0 InnoDB latin1_swedish_ci 16 KiB -
adjustmenttypes 0 InnoDB latin1_swedish_ci 16 KiB -
adjust_stocks 0 InnoDB latin1_swedish_ci 16 KiB -
adjust_stock_batches 0 InnoDB latin1_swedish_ci 16 KiB -
adjust_stock_items 0 InnoDB latin1_swedish_ci 16 KiB -
allergies 0 InnoDB latin1_swedish_ci 16 KiB -
alternatitemdetails 0 InnoDB latin1_swedish_ci 16 KiB -
alternatitems 0 InnoDB latin1_swedish_ci 16 KiB -
anesthesias 6 InnoDB latin1_swedish_ci 16 KiB -
anesthesia_details 0 InnoDB latin1_swedish_ci 16 KiB -
anesthesia_records 0 InnoDB latin1_swedish_ci 16 KiB -
anesthesia_record_grids 0 InnoDB latin1_swedish_ci 16 KiB -
anesthesia_timings 0 InnoDB latin1_swedish_ci 16 KiB -
antenatal_cares 0 InnoDB latin1_swedish_ci 16 KiB -
antenatal_care_clinicals 0 InnoDB latin1_swedish_ci 16 KiB -
antenatal_care_instructions 0 InnoDB latin1_swedish_ci 16 KiB -
anticoagulants 0 InnoDB latin1_swedish_ci 16 KiB -
asset_issue 0 InnoDB latin1_swedish_ci 16 KiB -
asset_issue_details 0 InnoDB latin1_swedish_ci 16 KiB -
asset_return 0 InnoDB latin1_swedish_ci 16 KiB -
asset_return_details 0 InnoDB latin1_swedish_ci 16 KiB -
assigncounters 67 InnoDB latin1_swedish_ci 16 KiB -
assign_checkup_counters 394,189 MyISAM latin1_swedish_ci 34.9 MiB -
assign_roles 0 InnoDB latin1_swedish_ci 16 KiB -
authorizationglobalremarks 0 InnoDB latin1_swedish_ci 16 KiB -
authorizationremarks 0 InnoDB latin1_swedish_ci 16 KiB -
authorizations 0 InnoDB latin1_swedish_ci 16 KiB -
authorizationtests 0 InnoDB latin1_swedish_ci 16 KiB -
baby_notes 1 MyISAM latin1_swedish_ci 2.1 KiB -
baseunits 21 InnoDB latin1_swedish_ci 16 KiB -
batchdetails 13,962 InnoDB latin1_swedish_ci 3.7 MiB -
batchissues 0 InnoDB latin1_swedish_ci 16 KiB -
batch_issue_accepts 0 InnoDB latin1_swedish_ci 16 KiB -
bd_totalquantities 1 InnoDB latin1_swedish_ci 16 KiB -
bedallocations 0 InnoDB latin1_swedish_ci 16 KiB -
bedcharges 41 InnoDB latin1_swedish_ci 16 KiB -
bedcharge_details 549 InnoDB latin1_swedish_ci 80 KiB -
beds 493 InnoDB latin1_swedish_ci 128 KiB -
bedtypes 1 InnoDB latin1_swedish_ci 32 KiB -
bills 2 InnoDB latin1_swedish_ci 16 KiB -
bill_classes 1 InnoDB latin1_swedish_ci 16 KiB -
birthdetails 0 InnoDB latin1_swedish_ci 16 KiB -
block_masters 0 InnoDB latin1_swedish_ci 16 KiB -
bloodbanks 0 InnoDB latin1_swedish_ci 16 KiB -
bloodcancellations 0 InnoDB latin1_swedish_ci 16 KiB -
bloodcomponents 0 InnoDB latin1_swedish_ci 16 KiB -
blooddonors 0 InnoDB latin1_swedish_ci 16 KiB -
bloodgroups 0 InnoDB latin1_swedish_ci 16 KiB -
bloodprofiles 0 InnoDB latin1_swedish_ci 16 KiB -
bloodreceives 0 InnoDB latin1_swedish_ci 16 KiB -
bloodrejects 0 InnoDB latin1_swedish_ci 16 KiB -
bloodsdetails 0 InnoDB latin1_swedish_ci 16 KiB -
bloodsecurities 0 InnoDB latin1_swedish_ci 16 KiB -
bloodsugars 0 MyISAM latin1_swedish_ci 1 KiB -
bloodsugar_details 0 MyISAM latin1_swedish_ci 1 KiB -
booking_status 0 InnoDB latin1_swedish_ci 16 KiB -
branditems 7,435 InnoDB latin1_swedish_ci 1.5 MiB -
brandnames 123 InnoDB latin1_swedish_ci 16 KiB -
breasons 0 InnoDB latin1_swedish_ci 16 KiB -
buckets 0 InnoDB latin1_swedish_ci 16 KiB -
businessparameters 0 InnoDB latin1_swedish_ci 16 KiB -
camp_contacts 1,740 MyISAM latin1_swedish_ci 114 KiB -
camp_masters 1,549 MyISAM latin1_swedish_ci 281 KiB -
camp_types 2 MyISAM latin1_swedish_ci 2.1 KiB -
cancelappointments 0 InnoDB latin1_swedish_ci 16 KiB -
categories 608 InnoDB latin1_swedish_ci 128 KiB -
categoryrates 505 InnoDB latin1_swedish_ci 224 KiB -
category_masters 3 InnoDB latin1_swedish_ci 32 KiB -
category_types 3 InnoDB latin1_swedish_ci 16 KiB -
cervicalthorasics 0 InnoDB latin1_swedish_ci 16 KiB -
cfpreferances 0 InnoDB latin1_swedish_ci 16 KiB -
checklists 0 InnoDB latin1_swedish_ci 16 KiB -
checkup_counters 26 MyISAM latin1_swedish_ci 4.9 KiB -
chemistries 0 InnoDB latin1_swedish_ci 16 KiB -
cities 0 InnoDB latin1_swedish_ci 16 KiB -
clientvisitdetails 0 InnoDB latin1_swedish_ci 16 KiB -
clinicalfindings 394 InnoDB latin1_swedish_ci 80 KiB -
closecntreports 0 InnoDB latin1_swedish_ci 16 KiB -
closecounters 7,538 InnoDB latin1_swedish_ci 2.5 MiB -
cnssidetails 0 InnoDB latin1_swedish_ci 16 KiB -
comparatives 0 MyISAM latin1_swedish_ci 1 KiB -
comparative_details 0 MyISAM latin1_swedish_ci 1 KiB -
complications 4 MyISAM latin1_swedish_ci 2.2 KiB -
componentdetails 0 InnoDB latin1_swedish_ci 16 KiB -
consentdetails 4 InnoDB latin1_swedish_ci 16 KiB -
consultations 0 InnoDB latin1_swedish_ci 16 KiB -
consumables 0 InnoDB latin1_swedish_ci 16 KiB -
consumable_batch_details 0 MyISAM latin1_swedish_ci 1 KiB -
consumable_batch_entries 0 InnoDB latin1_swedish_ci 16 KiB -
consumable_entries 0 InnoDB latin1_swedish_ci 32 KiB -
consumable_item_entries 0 InnoDB latin1_swedish_ci 16 KiB -
counsellings 65,064 MyISAM latin1_swedish_ci 6.4 MiB -
counter_masters 28 InnoDB latin1_swedish_ci 32 KiB -
countries 2 InnoDB latin1_swedish_ci 16 KiB -
country_masters 0 InnoDB utf8_general_ci 16 KiB -
create_vendor_quotations 0 InnoDB latin1_swedish_ci 16 KiB -
create_vendor_quotation_details 0 InnoDB latin1_swedish_ci 16 KiB -
creditnotes 0 InnoDB latin1_swedish_ci 16 KiB -
creditnote_details 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_issues 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_issue_items 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_issue_processes 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_issue_process_items 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_item_storages 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_process_maps 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_process_masters 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_requests 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_request_items 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_schedules 0 InnoDB latin1_swedish_ci 32 KiB -
cssd_schedule_details 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_schedule_transactions 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_schedule_transaction_items 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_sets 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_set_items 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_status_masters 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_sterile_methods 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_tech_masters 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_type_masters 0 InnoDB latin1_swedish_ci 16 KiB -
cssd_user_process_maps 0 InnoDB latin1_swedish_ci 16 KiB -
currentmedications 1 InnoDB latin1_swedish_ci 16 KiB -
current_medications 0 InnoDB latin1_swedish_ci 16 KiB -
dailyappointments 0 InnoDB latin1_swedish_ci 16 KiB -
dailybedcensus 0 InnoDB latin1_swedish_ci 16 KiB -
dailyregistrations 0 InnoDB latin1_swedish_ci 16 KiB -
dailyserviceorders 0 InnoDB latin1_swedish_ci 16 KiB -
dappointments 0 InnoDB latin1_swedish_ci 16 KiB -
day_care_pre_beds 0 MyISAM latin1_swedish_ci 1 KiB -
day_care_pre_bed_slots 0 MyISAM latin1_swedish_ci 1 KiB -
dcupdates 0 InnoDB latin1_swedish_ci 16 KiB -
deathpostings 0 InnoDB latin1_swedish_ci 16 KiB -
deaths 0 InnoDB latin1_swedish_ci 16 KiB -
death_permanent_adds 0 InnoDB latin1_swedish_ci 16 KiB -
death_police_cases 0 InnoDB latin1_swedish_ci 16 KiB -
death_present_adds 0 InnoDB latin1_swedish_ci 16 KiB -
death_responsible_adds 0 InnoDB latin1_swedish_ci 16 KiB -
debitnotes 0 InnoDB latin1_swedish_ci 16 KiB -
debitnote_details 0 InnoDB latin1_swedish_ci 16 KiB -
department_masters 20 InnoDB latin1_swedish_ci 32 KiB -
designations 21 InnoDB latin1_swedish_ci 16 KiB -
designation_details 54 InnoDB latin1_swedish_ci 16 KiB -
devtests 0 InnoDB latin1_swedish_ci 16 KiB -
diagnoses 190 InnoDB latin1_swedish_ci 64 KiB -
diagnsspreferances 0 InnoDB latin1_swedish_ci 16 KiB -
diet_assessments 0 InnoDB latin1_swedish_ci 16 KiB -
diet_assessment_details 0 InnoDB latin1_swedish_ci 16 KiB -
diet_assessment_lab_details 0 InnoDB latin1_swedish_ci 16 KiB -
diet_schedulers 0 InnoDB latin1_swedish_ci 16 KiB -
diet_tickets 0 InnoDB latin1_swedish_ci 16 KiB -
diet_ticket_details 0 InnoDB latin1_swedish_ci 16 KiB -
dischargesummaries 56,367 InnoDB latin1_swedish_ci 32.6 MiB -
discharge_medicines 150,990 InnoDB latin1_swedish_ci 17 MiB -
disposable_items 0 InnoDB latin1_swedish_ci 16 KiB -
districts 114 MyISAM latin1_swedish_ci 8.9 KiB -
doctorcommisions 0 InnoDB latin1_swedish_ci 16 KiB -
doctorcommision_details 0 InnoDB latin1_swedish_ci 16 KiB -
doctorconsdetails 122 InnoDB latin1_swedish_ci 16 KiB -
doctorconsultations 84 InnoDB latin1_swedish_ci 16 KiB -
doctortypeforms 7 InnoDB latin1_swedish_ci 16 KiB -
doctor_masters 294 InnoDB utf8_general_ci 112 KiB -
doctor_progress_forms 0 InnoDB latin1_swedish_ci 16 KiB -
documents 0 InnoDB latin1_swedish_ci 16 KiB -
document_masters 0 InnoDB latin1_swedish_ci 16 KiB -
donors 0 InnoDB latin1_swedish_ci 16 KiB -
drgroups 0 InnoDB latin1_swedish_ci 16 KiB -
drugissuebalanceitems 0 InnoDB latin1_swedish_ci 16 KiB -
drugissueitems 0 InnoDB latin1_swedish_ci 16 KiB -
drugissueothers 0 InnoDB latin1_swedish_ci 16 KiB -
drugissues 456,049 InnoDB latin1_swedish_ci 85.2 MiB -
drugissue_amounts 455,660 InnoDB latin1_swedish_ci 61.1 MiB -
drugissue_batch_issues ~1,003,795 InnoDB latin1_swedish_ci 146.3 MiB -
drugissue_details ~906,169 InnoDB latin1_swedish_ci 275.3 MiB -
drugorders 0 InnoDB latin1_swedish_ci 32 KiB -
drugorder_details 0 InnoDB latin1_swedish_ci 16 KiB -
drugs 0 InnoDB latin1_swedish_ci 16 KiB -
drug_administrations 0 InnoDB latin1_swedish_ci 16 KiB -
drug_administration_details 0 InnoDB latin1_swedish_ci 16 KiB -
dvoucherdetails 0 InnoDB latin1_swedish_ci 16 KiB -
employees 1 InnoDB latin1_swedish_ci 16 KiB -
employee_masters 302 InnoDB latin1_swedish_ci 144 KiB -
emrnotes 0 InnoDB latin1_swedish_ci 16 KiB -
emrs 0 InnoDB latin1_swedish_ci 16 KiB -
emr_allergynotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_anticoagulantnotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_dietplans 0 InnoDB latin1_swedish_ci 16 KiB -
emr_extranotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_fhnotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_generalnotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_ivdailynotes 0 InnoDB latin1_swedish_ci 16 KiB -
emr_problems 0 InnoDB latin1_swedish_ci 16 KiB -
emr_ptatgnotes 0 InnoDB latin1_swedish_ci 16 KiB -
ERwe ~0 This view has at least this number of rows. Please refer to documentation. View --- - -
evaluation_masters 0 InnoDB latin1_swedish_ci 32 KiB -
eye_operations 55,808 MyISAM latin1_swedish_ci 11.8 MiB -
familyhistories 0 InnoDB latin1_swedish_ci 16 KiB -
fbills 0 InnoDB latin1_swedish_ci 16 KiB -
finalbills 61,203 InnoDB latin1_swedish_ci 12 MiB -
finalbill_bed_details 29,361 InnoDB latin1_swedish_ci 3.5 MiB -
finalbill_details 100,031 InnoDB latin1_swedish_ci 7.5 MiB -
finalbill_doc_details 0 InnoDB latin1_swedish_ci 16 KiB -
finalbill_rev_details 425 InnoDB latin1_swedish_ci 80 KiB -
finalbill_voucher_details 36,395 InnoDB latin1_swedish_ci 4.5 MiB -
fixedvalues 0 InnoDB latin1_swedish_ci 16 KiB -
follicle_masters 0 InnoDB latin1_swedish_ci 16 KiB -
followupreports 0 InnoDB latin1_swedish_ci 16 KiB -
food_groups 0 InnoDB latin1_swedish_ci 16 KiB -
food_item_masters 0 InnoDB latin1_swedish_ci 16 KiB -
foreigners 269,777 InnoDB latin1_swedish_ci 12.5 MiB -
forms 633 InnoDB latin1_swedish_ci 128 KiB -
generalnotes 0 InnoDB latin1_swedish_ci 16 KiB -
generalnoticeboards 41 InnoDB latin1_swedish_ci 16 KiB -
general_payment_receipts 0 InnoDB latin1_swedish_ci 16 KiB -
generics 0 InnoDB latin1_swedish_ci 16 KiB -
grade_details 0 InnoDB latin1_swedish_ci 32 KiB -
grade_masters 0 InnoDB latin1_swedish_ci 16 KiB -
grouporganismlinks 0 InnoDB latin1_swedish_ci 16 KiB -
grouporganismlink_details 0 InnoDB latin1_swedish_ci 16 KiB -
group_masters 0 InnoDB latin1_swedish_ci 16 KiB -
gynaecologies 0 InnoDB latin1_swedish_ci 16 KiB -
gynaecology_instructions 0 InnoDB latin1_swedish_ci 16 KiB -
homes 0 InnoDB latin1_swedish_ci 16 KiB -
hourlyservices 0 InnoDB latin1_swedish_ci 16 KiB -
ifirsts 0 InnoDB latin1_swedish_ci 16 KiB -
indents 0 InnoDB latin1_swedish_ci 32 KiB -
indent_details 0 InnoDB latin1_swedish_ci 16 KiB -
input_output_tax_masters 0 MyISAM latin1_swedish_ci 1 KiB -
insurances 0 InnoDB latin1_swedish_ci 16 KiB -
insurance_details 0 InnoDB latin1_swedish_ci 16 KiB -
insurance_masters 0 InnoDB latin1_swedish_ci 32 KiB -
intakes 0 MyISAM latin1_swedish_ci 1 KiB -
intake_details 0 MyISAM latin1_swedish_ci 1 KiB -
intake_iv_masters 0 InnoDB latin1_swedish_ci 16 KiB -
intake_masters 0 InnoDB latin1_swedish_ci 16 KiB -
intrimbills 0 InnoDB latin1_swedish_ci 16 KiB -
intubations 0 InnoDB latin1_swedish_ci 16 KiB -
ipadmissionlists 0 InnoDB latin1_swedish_ci 16 KiB -
ipadmissions 61,306 InnoDB latin1_swedish_ci 40.7 MiB -
ipadmission_beds 61,535 InnoDB latin1_swedish_ci 3.5 MiB -
ipadmission_numbers 61,534 MyISAM latin1_swedish_ci 3.7 MiB -
ipbillheaders 0 InnoDB latin1_swedish_ci 16 KiB -
ipdtreatments 0 InnoDB latin1_swedish_ci 16 KiB -
ipd_bedcharges 0 InnoDB latin1_swedish_ci 32 KiB -
ipd_house_keeping_remarks 0 InnoDB latin1_swedish_ci 16 KiB -
ipd_nurse_notes 0 InnoDB latin1_swedish_ci 16 KiB -
ipd_nurse_note_diagnoses 0 InnoDB latin1_swedish_ci 16 KiB -
250 tables Sum ~4,519,869 InnoDB latin1_swedish_ci 794.7 MiB 0 B
Page number:
> >>

  Create table
Name:
Number of columns:
Notice in ./templates/database/designer/js_fields.phtml#5
Undefined index: token

Backtrace

./libraries/Template.class.php#80: include(./templates/database/designer/js_fields.phtml)
./libraries/db_designer.lib.php#152: PMA\Template->render(array)
./db_designer.php#148: PMA_getHtmlForJSFields(
array,
array,
array,
integer -1,
)