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 queryPress Enter to execute query
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database: Queried time:

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,
)
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,
)