ea-bpmu.tail0b8d6c.ts.net / 127.0.0.1 / ncd_reporting

There are no favorite tables.

Customize appearance of the navigation panel.

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 panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

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
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

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

Tables display options.

Tables

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 -

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 :

Untitled *

v		ncd_reporting ncd_reports
id : int(10) unsigned
hwc_name : varchar(100)
status : enum('PBS','Non-PBS')
report_date : date
saved_at : datetime
cbac_m : smallint(5) unsigned
cbac_f : smallint(5) unsigned
cbac_t : smallint(5) unsigned
part_i_tb_m : smallint(5) unsigned
part_i_tb_f : smallint(5) unsigned
part_i_tb_t : smallint(5) unsigned
lep_m : smallint(5) unsigned
lep_f : smallint(5) unsigned
lep_t : smallint(5) unsigned
mental_m : smallint(5) unsigned
mental_f : smallint(5) unsigned
mental_t : smallint(5) unsigned
elderly_m : smallint(5) unsigned
elderly_f : smallint(5) unsigned
elderly_t : smallint(5) unsigned
pall_m : smallint(5) unsigned
pall_f : smallint(5) unsigned
pall_t : smallint(5) unsigned
eye_m : smallint(5) unsigned
eye_f : smallint(5) unsigned
eye_t : smallint(5) unsigned
ear_m : smallint(5) unsigned
ear_f : smallint(5) unsigned
ear_t : smallint(5) unsigned
dm_screened_m : smallint(5) unsigned
dm_screened_f : smallint(5) unsigned
dm_screened_t : smallint(5) unsigned
htn_screened_m : smallint(5) unsigned
htn_screened_f : smallint(5) unsigned
htn_screened_t : smallint(5) unsigned
dm_suspected_m : smallint(5) unsigned
dm_suspected_f : smallint(5) unsigned
dm_suspected_t : smallint(5) unsigned
htn_suspected_m : smallint(5) unsigned
htn_suspected_f : smallint(5) unsigned
htn_suspected_t : smallint(5) unsigned
both_suspected_m : smallint(5) unsigned
both_suspected_f : smallint(5) unsigned
both_suspected_t : smallint(5) unsigned
dm_diag_tele_m : smallint(5) unsigned
dm_diag_tele_f : smallint(5) unsigned
dm_diag_tele_t : smallint(5) unsigned
htn_diag_tele_m : smallint(5) unsigned
htn_diag_tele_f : smallint(5) unsigned
htn_diag_tele_t : smallint(5) unsigned
both_diag_tele_m : smallint(5) unsigned
both_diag_tele_f : smallint(5) unsigned
both_diag_tele_t : smallint(5) unsigned
dm_treat_tele_m : smallint(5) unsigned
dm_treat_tele_f : smallint(5) unsigned
dm_treat_tele_t : smallint(5) unsigned
htn_treat_tele_m : smallint(5) unsigned
htn_treat_tele_f : smallint(5) unsigned
htn_treat_tele_t : smallint(5) unsigned
both_treat_tele_m : smallint(5) unsigned
both_treat_tele_f : smallint(5) unsigned
both_treat_tele_t : smallint(5) unsigned
dm_followup_m : smallint(5) unsigned
dm_followup_f : smallint(5) unsigned
dm_followup_t : smallint(5) unsigned
htn_followup_m : smallint(5) unsigned
htn_followup_f : smallint(5) unsigned
htn_followup_t : smallint(5) unsigned
both_followup_m : smallint(5) unsigned
both_followup_f : smallint(5) unsigned
both_followup_t : smallint(5) unsigned
oral_m : smallint(5) unsigned
oral_f : smallint(5) unsigned
oral_t : smallint(5) unsigned
breast_f : smallint(5) unsigned
breast_t : smallint(5) unsigned
cervical_f : smallint(5) unsigned
cervical_t : smallint(5) unsigned
oral_sus_m : smallint(5) unsigned
oral_sus_f : smallint(5) unsigned
oral_sus_t : smallint(5) unsigned
breast_sus_f : smallint(5) unsigned
breast_sus_t : smallint(5) unsigned
cervical_sus_f : smallint(5) unsigned
cervical_sus_t : smallint(5) unsigned
other_sus_m : smallint(5) unsigned
other_sus_f : smallint(5) unsigned
other_sus_t : smallint(5) unsigned
oral_fol_m : smallint(5) unsigned
oral_fol_f : smallint(5) unsigned
oral_fol_t : smallint(5) unsigned
breast_fol_f : smallint(5) unsigned
breast_fol_t : smallint(5) unsigned
cervical_fol_f : smallint(5) unsigned
cervical_fol_t : smallint(5) unsigned
stroke_m : smallint(5) unsigned
stroke_f : smallint(5) unsigned
stroke_t : smallint(5) unsigned
cvd_m : smallint(5) unsigned
cvd_f : smallint(5) unsigned
cvd_t : smallint(5) unsigned
copd_m : smallint(5) unsigned
copd_f : smallint(5) unsigned
copd_t : smallint(5) unsigned
ckd_m : smallint(5) unsigned
ckd_f : smallint(5) unsigned
ckd_t : smallint(5) unsigned
nafld_m : smallint(5) unsigned
nafld_f : smallint(5) unsigned
nafld_t : smallint(5) unsigned
tb_asked_m : smallint(5) unsigned
tb_asked_f : smallint(5) unsigned
tb_asked_t : smallint(5) unsigned
tb_referred_m : smallint(5) unsigned
tb_referred_f : smallint(5) unsigned
tb_referred_t : smallint(5) unsigned

Create relationship
FOREIGN KEY
on delete
on update