competence-rs.com / localhost / hmis

Navigation panel
Navigation tree
Databases
Tables

Navigation panel

Customize appearance of the navigation panel.

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.

Navigation tree

Customize the navigation tree.

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree

Databases

Databases display options.

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables

Tables display options.

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x-

Server: localhost »

Database: hmis

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken:

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift + Enter. To make this permanent, view settings.
Switch to dark theme

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

Database structure

Database structure

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

Show table comments Show or hide a column displaying the comments for all tables.
Show creation timestamp Show or hide a column displaying the Creation timestamp for all tables.
Show last update timestamp Show or hide a column displaying the Last update timestamp for all tables.
Show last check timestamp Show or hide a column displaying the Last check timestamp for all tables.

Page number: > >>

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

Check all

Page number: > >>

Print view Data dictionary

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