将文件拖动至此

SQL upload ( 0 ) x-

服务器: localhost »数据库: hmis
页面相关设置点击以滚动到页面顶部
按 Ctrl+Enter 键执行查询按 Enter 执行查询
递增排序
递减排序
命令:
调试 SQL
数量
运行顺序
用时
排序条件:
联合查询
不使用联合查询
崩溃 扩展 显示跟踪 隐藏跟踪 记录数: 用时:
书签
刷新
添加
没有书签
添加书签
选项
恢复默认





崩溃 扩展 重新查询 编辑 解析 性能分析 书签 查询失败 数据库: 查询时间:

数据库结构

设置在数据库结构(表列表)中显示哪些细节。

文档 显示或隐藏所有表的备注列。
文档 显示或隐藏所有表的创建时间列。
文档 显示或隐藏所有表的最近更新时间列。
文档 显示或隐藏所有表的最近检查时间列。
页码:
> >>
递增递减 操作 行数 May be approximate. Click on the number to get the exact count. See FAQ 3.11. 类型 排序规则 大小 多余
abg_settings 0 MyISAM latin1_swedish_ci 1 KB -
acceptissues 0 InnoDB latin1_swedish_ci 16 KB -
acceptissue_details 0 InnoDB latin1_swedish_ci 16 KB -
account_groups 0 MyISAM latin1_swedish_ci 1 KB -
addictions 0 InnoDB latin1_swedish_ci 16 KB -
addresses 257,218 InnoDB latin1_swedish_ci 23.6 MB -
adiagnosis 0 InnoDB latin1_swedish_ci 16 KB -
adjustmenttypes 0 InnoDB latin1_swedish_ci 16 KB -
adjust_stocks 0 InnoDB latin1_swedish_ci 16 KB -
adjust_stock_batches 0 InnoDB latin1_swedish_ci 16 KB -
adjust_stock_items 0 InnoDB latin1_swedish_ci 16 KB -
allergies 0 InnoDB latin1_swedish_ci 16 KB -
alternatitemdetails 0 InnoDB latin1_swedish_ci 16 KB -
alternatitems 0 InnoDB latin1_swedish_ci 16 KB -
anesthesias 6 InnoDB latin1_swedish_ci 16 KB -
anesthesia_details 0 InnoDB latin1_swedish_ci 16 KB -
anesthesia_records 0 InnoDB latin1_swedish_ci 16 KB -
anesthesia_record_grids 0 InnoDB latin1_swedish_ci 16 KB -
anesthesia_timings 0 InnoDB latin1_swedish_ci 16 KB -
antenatal_cares 0 InnoDB latin1_swedish_ci 16 KB -
antenatal_care_clinicals 0 InnoDB latin1_swedish_ci 16 KB -
antenatal_care_instructions 0 InnoDB latin1_swedish_ci 16 KB -
anticoagulants 0 InnoDB latin1_swedish_ci 16 KB -
asset_issue 0 InnoDB latin1_swedish_ci 16 KB -
asset_issue_details 0 InnoDB latin1_swedish_ci 16 KB -
asset_return 0 InnoDB latin1_swedish_ci 16 KB -
asset_return_details 0 InnoDB latin1_swedish_ci 16 KB -
assigncounters 67 InnoDB latin1_swedish_ci 16 KB -
assign_checkup_counters 394,189 MyISAM latin1_swedish_ci 34.9 MB -
assign_roles 0 InnoDB latin1_swedish_ci 16 KB -
authorizationglobalremarks 0 InnoDB latin1_swedish_ci 16 KB -
authorizationremarks 0 InnoDB latin1_swedish_ci 16 KB -
authorizations 0 InnoDB latin1_swedish_ci 16 KB -
authorizationtests 0 InnoDB latin1_swedish_ci 16 KB -
baby_notes 1 MyISAM latin1_swedish_ci 2.1 KB -
baseunits 21 InnoDB latin1_swedish_ci 16 KB -
batchdetails 13,963 InnoDB latin1_swedish_ci 3.7 MB -
batchissues 0 InnoDB latin1_swedish_ci 16 KB -
batch_issue_accepts 0 InnoDB latin1_swedish_ci 16 KB -
bd_totalquantities 1 InnoDB latin1_swedish_ci 16 KB -
bedallocations 0 InnoDB latin1_swedish_ci 16 KB -
bedcharges 41 InnoDB latin1_swedish_ci 16 KB -
bedcharge_details 549 InnoDB latin1_swedish_ci 80 KB -
beds 493 InnoDB latin1_swedish_ci 128 KB -
bedtransfers 0 InnoDB latin1_swedish_ci 64 KB -
bedtypes 1 InnoDB latin1_swedish_ci 32 KB -
bills 2 InnoDB latin1_swedish_ci 16 KB -
bill_classes 1 InnoDB latin1_swedish_ci 16 KB -
birthdetails 0 InnoDB latin1_swedish_ci 16 KB -
block_masters 0 InnoDB latin1_swedish_ci 16 KB -
bloodbanks 0 InnoDB latin1_swedish_ci 16 KB -
bloodcancellations 0 InnoDB latin1_swedish_ci 16 KB -
bloodcomponents 0 InnoDB latin1_swedish_ci 16 KB -
blooddonors 0 InnoDB latin1_swedish_ci 16 KB -
bloodgroups 0 InnoDB latin1_swedish_ci 16 KB -
bloodprofiles 0 InnoDB latin1_swedish_ci 16 KB -
bloodreceives 0 InnoDB latin1_swedish_ci 16 KB -
bloodrejects 0 InnoDB latin1_swedish_ci 16 KB -
bloodsdetails 0 InnoDB latin1_swedish_ci 16 KB -
bloodsecurities 0 InnoDB latin1_swedish_ci 16 KB -
bloodsugars 0 MyISAM latin1_swedish_ci 1 KB -
bloodsugar_details 0 MyISAM latin1_swedish_ci 1 KB -
booking_status 0 InnoDB latin1_swedish_ci 16 KB -
branditems 7,435 InnoDB latin1_swedish_ci 1.5 MB -
brandnames 123 InnoDB latin1_swedish_ci 16 KB -
breasons 0 InnoDB latin1_swedish_ci 16 KB -
buckets 0 InnoDB latin1_swedish_ci 16 KB -
businessparameters 0 InnoDB latin1_swedish_ci 16 KB -
camp_contacts 1,740 MyISAM latin1_swedish_ci 114 KB -
camp_masters 1,549 MyISAM latin1_swedish_ci 281 KB -
camp_types 2 MyISAM latin1_swedish_ci 2.1 KB -
cancelappointments 0 InnoDB latin1_swedish_ci 16 KB -
categories 608 InnoDB latin1_swedish_ci 128 KB -
categoryrates 505 InnoDB latin1_swedish_ci 224 KB -
category_masters 3 InnoDB latin1_swedish_ci 32 KB -
category_types 3 InnoDB latin1_swedish_ci 16 KB -
cervicalthorasics 0 InnoDB latin1_swedish_ci 16 KB -
cfpreferances 0 InnoDB latin1_swedish_ci 16 KB -
checklists 0 InnoDB latin1_swedish_ci 16 KB -
checkup_counters 26 MyISAM latin1_swedish_ci 4.9 KB -
chemistries 0 InnoDB latin1_swedish_ci 16 KB -
cities 0 InnoDB latin1_swedish_ci 16 KB -
clientvisitdetails 0 InnoDB latin1_swedish_ci 16 KB -
clinicalfindings 394 InnoDB latin1_swedish_ci 80 KB -
closecntreports 0 InnoDB latin1_swedish_ci 16 KB -
closecounters 7,538 InnoDB latin1_swedish_ci 2.5 MB -
cnssidetails 0 InnoDB latin1_swedish_ci 16 KB -
comparatives 0 MyISAM latin1_swedish_ci 1 KB -
comparative_details 0 MyISAM latin1_swedish_ci 1 KB -
complications 4 MyISAM latin1_swedish_ci 2.2 KB -
componentdetails 0 InnoDB latin1_swedish_ci 16 KB -
consentdetails 4 InnoDB latin1_swedish_ci 16 KB -
consultations 2 InnoDB latin1_swedish_ci 16 KB -
consumables 0 InnoDB latin1_swedish_ci 16 KB -
consumable_batch_details 0 MyISAM latin1_swedish_ci 1 KB -
consumable_batch_entries 0 InnoDB latin1_swedish_ci 16 KB -
consumable_entries 0 InnoDB latin1_swedish_ci 32 KB -
consumable_item_entries 0 InnoDB latin1_swedish_ci 16 KB -
counsellings 65,064 MyISAM latin1_swedish_ci 6.4 MB -
counter_masters 28 InnoDB latin1_swedish_ci 32 KB -
countries 2 InnoDB latin1_swedish_ci 16 KB -
country_masters 0 InnoDB utf8_general_ci 16 KB -
create_vendor_quotations 0 InnoDB latin1_swedish_ci 16 KB -
create_vendor_quotation_details 0 InnoDB latin1_swedish_ci 16 KB -
creditnotes 0 InnoDB latin1_swedish_ci 16 KB -
creditnote_details 0 InnoDB latin1_swedish_ci 16 KB -
cssd_issues 0 InnoDB latin1_swedish_ci 16 KB -
cssd_issue_items 0 InnoDB latin1_swedish_ci 16 KB -
cssd_issue_processes 0 InnoDB latin1_swedish_ci 16 KB -
cssd_issue_process_items 0 InnoDB latin1_swedish_ci 16 KB -
cssd_item_storages 0 InnoDB latin1_swedish_ci 16 KB -
cssd_process_maps 0 InnoDB latin1_swedish_ci 16 KB -
cssd_process_masters 0 InnoDB latin1_swedish_ci 16 KB -
cssd_requests 0 InnoDB latin1_swedish_ci 16 KB -
cssd_request_items 0 InnoDB latin1_swedish_ci 16 KB -
cssd_schedules 0 InnoDB latin1_swedish_ci 32 KB -
cssd_schedule_details 0 InnoDB latin1_swedish_ci 16 KB -
cssd_schedule_transactions 0 InnoDB latin1_swedish_ci 16 KB -
cssd_schedule_transaction_items 0 InnoDB latin1_swedish_ci 16 KB -
cssd_sets 0 InnoDB latin1_swedish_ci 16 KB -
cssd_set_items 0 InnoDB latin1_swedish_ci 16 KB -
cssd_status_masters 0 InnoDB latin1_swedish_ci 16 KB -
cssd_sterile_methods 0 InnoDB latin1_swedish_ci 16 KB -
cssd_tech_masters 0 InnoDB latin1_swedish_ci 16 KB -
cssd_type_masters 0 InnoDB latin1_swedish_ci 16 KB -
cssd_user_process_maps 0 InnoDB latin1_swedish_ci 16 KB -
currentmedications 1 InnoDB latin1_swedish_ci 16 KB -
current_medications 0 InnoDB latin1_swedish_ci 16 KB -
dailyappointments 0 InnoDB latin1_swedish_ci 16 KB -
dailybedcensus 0 InnoDB latin1_swedish_ci 16 KB -
dailyregistrations 0 InnoDB latin1_swedish_ci 16 KB -
dailyserviceorders 0 InnoDB latin1_swedish_ci 16 KB -
dappointments 0 InnoDB latin1_swedish_ci 16 KB -
day_care_pre_beds 0 MyISAM latin1_swedish_ci 1 KB -
day_care_pre_bed_slots 0 MyISAM latin1_swedish_ci 1 KB -
dcupdates 0 InnoDB latin1_swedish_ci 16 KB -
deathpostings 0 InnoDB latin1_swedish_ci 16 KB -
deaths 0 InnoDB latin1_swedish_ci 16 KB -
death_permanent_adds 0 InnoDB latin1_swedish_ci 16 KB -
death_police_cases 0 InnoDB latin1_swedish_ci 16 KB -
death_present_adds 0 InnoDB latin1_swedish_ci 16 KB -
death_responsible_adds 0 InnoDB latin1_swedish_ci 16 KB -
debitnotes 0 InnoDB latin1_swedish_ci 16 KB -
debitnote_details 0 InnoDB latin1_swedish_ci 16 KB -
department_masters 20 InnoDB latin1_swedish_ci 32 KB -
designations 21 InnoDB latin1_swedish_ci 16 KB -
designation_details 54 InnoDB latin1_swedish_ci 16 KB -
devtests 0 InnoDB latin1_swedish_ci 16 KB -
diagnoses 190 InnoDB latin1_swedish_ci 64 KB -
diagnsspreferances 0 InnoDB latin1_swedish_ci 16 KB -
diet_assessments 0 InnoDB latin1_swedish_ci 16 KB -
diet_assessment_details 0 InnoDB latin1_swedish_ci 16 KB -
diet_assessment_lab_details 0 InnoDB latin1_swedish_ci 16 KB -
diet_schedulers 0 InnoDB latin1_swedish_ci 16 KB -
diet_tickets 0 InnoDB latin1_swedish_ci 16 KB -
diet_ticket_details 0 InnoDB latin1_swedish_ci 16 KB -
dischargesummaries 56,367 InnoDB latin1_swedish_ci 32.6 MB -
discharge_medicines 150,990 InnoDB latin1_swedish_ci 17 MB -
disposable_items 0 InnoDB latin1_swedish_ci 16 KB -
districts 114 MyISAM latin1_swedish_ci 8.9 KB -
doctorcommisions 0 InnoDB latin1_swedish_ci 16 KB -
doctorcommision_details 0 InnoDB latin1_swedish_ci 16 KB -
doctorconsdetails 122 InnoDB latin1_swedish_ci 16 KB -
doctorconsultations 84 InnoDB latin1_swedish_ci 16 KB -
doctortypeforms 7 InnoDB latin1_swedish_ci 16 KB -
doctor_masters 294 InnoDB utf8_general_ci 112 KB -
doctor_progress_forms 0 InnoDB latin1_swedish_ci 16 KB -
documents 0 InnoDB latin1_swedish_ci 16 KB -
document_masters 0 InnoDB latin1_swedish_ci 16 KB -
donors 0 InnoDB latin1_swedish_ci 16 KB -
drgroups 0 InnoDB latin1_swedish_ci 16 KB -
drugissuebalanceitems 0 InnoDB latin1_swedish_ci 16 KB -
drugissueitems 0 InnoDB latin1_swedish_ci 16 KB -
drugissueothers 0 InnoDB latin1_swedish_ci 16 KB -
drugissues 456,049 InnoDB latin1_swedish_ci 85.2 MB -
drugissue_amounts 455,660 InnoDB latin1_swedish_ci 61.1 MB -
drugissue_batch_issues ~1,003,795 InnoDB latin1_swedish_ci 146.3 MB -
drugissue_details ~906,169 InnoDB latin1_swedish_ci 275.3 MB -
drugorders 0 InnoDB latin1_swedish_ci 32 KB -
drugorder_details 0 InnoDB latin1_swedish_ci 16 KB -
drugs 0 InnoDB latin1_swedish_ci 16 KB -
drug_administrations 0 InnoDB latin1_swedish_ci 16 KB -
drug_administration_details 0 InnoDB latin1_swedish_ci 16 KB -
dvoucherdetails 0 InnoDB latin1_swedish_ci 16 KB -
employees 1 InnoDB latin1_swedish_ci 16 KB -
employee_masters 302 InnoDB latin1_swedish_ci 144 KB -
emrnotes 0 InnoDB latin1_swedish_ci 16 KB -
emrs 0 InnoDB latin1_swedish_ci 16 KB -
emr_allergynotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_anticoagulantnotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_dietplans 0 InnoDB latin1_swedish_ci 16 KB -
emr_extranotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_fhnotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_generalnotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_ivdailynotes 0 InnoDB latin1_swedish_ci 16 KB -
emr_problems 0 InnoDB latin1_swedish_ci 16 KB -
emr_ptatgnotes 0 InnoDB latin1_swedish_ci 16 KB -
ERwe ~0 此视图的行数最少有这么多。请参阅档案 视图 --- - -
evaluation_masters 0 InnoDB latin1_swedish_ci 32 KB -
eye_operations 55,808 MyISAM latin1_swedish_ci 11.8 MB -
familyhistories 0 InnoDB latin1_swedish_ci 16 KB -
fbills 0 InnoDB latin1_swedish_ci 16 KB -
finalbills 61,203 InnoDB latin1_swedish_ci 12 MB -
finalbill_bed_details 29,361 InnoDB latin1_swedish_ci 3.5 MB -
finalbill_details 100,031 InnoDB latin1_swedish_ci 7.5 MB -
finalbill_doc_details 0 InnoDB latin1_swedish_ci 16 KB -
finalbill_rev_details 425 InnoDB latin1_swedish_ci 80 KB -
finalbill_voucher_details 36,395 InnoDB latin1_swedish_ci 4.5 MB -
fixedvalues 0 InnoDB latin1_swedish_ci 16 KB -
follicle_masters 0 InnoDB latin1_swedish_ci 16 KB -
followupreports 0 InnoDB latin1_swedish_ci 16 KB -
food_groups 0 InnoDB latin1_swedish_ci 16 KB -
food_item_masters 0 InnoDB latin1_swedish_ci 16 KB -
foreigners 269,777 InnoDB latin1_swedish_ci 12.5 MB -
forms 633 InnoDB latin1_swedish_ci 128 KB -
generalnotes 0 InnoDB latin1_swedish_ci 16 KB -
generalnoticeboards 41 InnoDB latin1_swedish_ci 16 KB -
general_payment_receipts 0 InnoDB latin1_swedish_ci 16 KB -
generics 0 InnoDB latin1_swedish_ci 16 KB -
grade_details 0 InnoDB latin1_swedish_ci 32 KB -
grade_masters 0 InnoDB latin1_swedish_ci 16 KB -
grouporganismlinks 0 InnoDB latin1_swedish_ci 16 KB -
grouporganismlink_details 0 InnoDB latin1_swedish_ci 16 KB -
group_masters 0 InnoDB latin1_swedish_ci 16 KB -
gynaecologies 0 InnoDB latin1_swedish_ci 16 KB -
gynaecology_instructions 0 InnoDB latin1_swedish_ci 16 KB -
homes 0 InnoDB latin1_swedish_ci 16 KB -
hourlyservices 0 InnoDB latin1_swedish_ci 16 KB -
ifirsts 0 InnoDB latin1_swedish_ci 16 KB -
indents 0 InnoDB latin1_swedish_ci 32 KB -
indent_details 0 InnoDB latin1_swedish_ci 16 KB -
input_output_tax_masters 0 MyISAM latin1_swedish_ci 1 KB -
insurances 0 InnoDB latin1_swedish_ci 16 KB -
insurance_details 0 InnoDB latin1_swedish_ci 16 KB -
insurance_masters 0 InnoDB latin1_swedish_ci 32 KB -
intakes 0 MyISAM latin1_swedish_ci 1 KB -
intake_details 0 MyISAM latin1_swedish_ci 1 KB -
intake_iv_masters 0 InnoDB latin1_swedish_ci 16 KB -
intake_masters 0 InnoDB latin1_swedish_ci 16 KB -
intrimbills 0 InnoDB latin1_swedish_ci 16 KB -
intubations 0 InnoDB latin1_swedish_ci 16 KB -
ipadmissionlists 0 InnoDB latin1_swedish_ci 16 KB -
ipadmissions 61,306 InnoDB latin1_swedish_ci 40.7 MB -
ipadmission_beds 61,535 InnoDB latin1_swedish_ci 3.5 MB -
ipadmission_numbers 61,534 MyISAM latin1_swedish_ci 3.7 MB -
ipbillheaders 0 InnoDB latin1_swedish_ci 16 KB -
ipdtreatments 0 InnoDB latin1_swedish_ci 16 KB -
ipd_bedcharges 0 InnoDB latin1_swedish_ci 32 KB -
ipd_house_keeping_remarks 0 InnoDB latin1_swedish_ci 16 KB -
ipd_nurse_notes 0 InnoDB latin1_swedish_ci 16 KB -
250 张表 总计 ~4,519,872 InnoDB latin1_swedish_ci 794.8 MB 0 字节
页码:
> >>

  新建数据表
名字:
字段数: