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

Print view Print view Data dictionary Data dictionary

  Create table
Name:
Number of columns: