Recent
`diabetes_system_fixed_20260625_231138`.`record_corrections`
`diabetes_system_fixed_20260625_231138`.`doctor_prescriptions`
`diabetes_system_fixed_20260625_231138`.`telegram_alert_state`
`diabetes_system_fixed_20260625_231138`.`meal_plan_templates`
`diabetes_system_fixed_20260625_231138`.`meal_plan_template_items`
`mysql`.`time_zone_leap_second`
`diabetes_system_fixed_20260625_231138`.`app_settings`
`diabetes_system_fixed_20260625_231138`.`sms_contacts`
`diabetes_system_fixed_20260625_231138`.`insulin_logs`
`mysql`.`columns_priv`
Favorites
There are no favorite tables.
New
diabetes_system_fixed_20260625_231138
information_schema
ipcrf_ms
mysql
performance_schema
phpmyadmin
test
Navigation panel
Navigation tree
Servers
Databases
Tables
Navigation panel
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
).
main
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.
Navigation tree
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
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
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
Tables display options.
Tables
Target for quick access icon
Structure
SQL
Search
Insert
Browse
Target for second quick access icon
Structure
SQL
Search
Insert
Browse
Table tree separator
String that separates tables into different tree levels.
Maximum table tree depth
Drop files here
SQL upload (
0
)
x
-
Show hidden navigation tree items.
Create view
Javascript must be enabled past this point!
Server: 127.0.0.1
Database: diabetes_system_fixed_20260625_231138
Structure
SQL
Search
Query
(current)
Export
Import
Operations
Privileges
Routines
Events
Triggers
Tracking
Designer
Central columns
Console
Clear
History
Options
Bookmarks
Debug SQL
Press Ctrl+Enter to execute query
Press 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
Label:
Target database:
Share this bookmark
OK
Options
Set default
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 :
Loading
ENUM/SET editor
Create view
Multi-table query
Query by example
Query window
*
id
alert_type
glucose_value
message
created_at
severity
status
acknowledged_at
acknowledged_by
parent_note
*
id
expected_cgm_interval_minutes
stale_after_minutes
offline_after_minutes
duplicate_insulin_minutes
telegram_escalation_minutes
backup_retention_count
updated_at
*
id
user_id
action
table_name
record_id
old_value
new_value
reason
ip_address
created_at
*
id
filename
encrypted
table_count
row_count
created_by
created_at
*
id
glucose_value
trend
device_source
recorded_at
reading_source
is_confirmed
confirmation_value
confirmation_time
sensor_id
*
date
avg_glucose
max_glucose
min_glucose
readings_count
*
id
prescription_date
doctor_name
specialization
clinic_name
diagnosis
medicines_instructions
notes
follow_up_date
created_by
created_at
updated_at
*
id
prescription_id
original_name
stored_name
mime_type
file_size
sha256
uploaded_at
*
id
display_name
category
description
document_date
expiry_date
original_name
stored_name
mime_type
file_extension
file_size
sha256
created_by
created_at
updated_at
*
id
contact_name
relationship
phone_number
telegram_chat_id
email
receive_critical
receive_school
receive_sick_day
is_primary
active
created_at
escalation_order
*
id
food_name
aliases
serving_amount
serving_unit
carbs_per_serving
category
source_note
active
created_at
*
id
table_name
record_id
old_values
new_values
edit_reason
edited_by
edited_at
*
id
event_type
event_time
title
details
created_at
*
id
insulin_log_id
review_type
due_at
telegram_sent
sent_at
created_at
*
id
rule_name
glucose_min
glucose_max
units
reason
active
sort_order
updated_at
*
id
insulin_type
units
injection_time
notes
linked_glucose
meal_carbs
reason
insulin_name
entry_status
correction_reason
*
date
total_units
*
id
glucose_value
ketone_result
action_taken
notes
logged_at
entry_status
*
id
email
ip_address
attempted_at
success
successful
*
id
meal_type
carbs
description
meal_time
computed_kcal
display_unit
meal_plan_key
meal_plan_name
meal_suggestion
entry_status
correction_reason
*
id
slot_key
db_meal_type
label
suggested_time
window_start
window_end
rice_exchange
meat_exchange
fruit_exchange
veg_cups
active
updated_at
*
id
plan_key
plan_name
description
no_added_sugar
is_default
active
sort_order
updated_at
*
id
plan_key
slot_key
suggestion_text
alternative_text
sugar_note
updated_at
*
id
profile_key
label
description
active
updated_at
*
id
profile_key
slot_key
db_meal_type
label
suggested_time
window_start
window_end
rice_exchange
meat_exchange
fruit_exchange
veg_cups
active
updated_at
*
id
event_key
event_type
meal_slot
scheduled_time
due_time
severity
message
status
acknowledged_at
acknowledged_by
created_at
*
id
user_id
patient_name
age_years
weight_kg
target_low
target_high
insulin_carb_ratio
correction_factor
created_at
*
id
low_no_bolus_threshold
severe_low_threshold
target_low
target_high
ketone_threshold
urgent_high_threshold
active_insulin_hours
rapid_insulin_name
basal_insulin_name
rapid_onset_minutes
rapid_peak_minutes
basal_scheduled_time
basal_half_life_hours
basal_duration_hours
basal_steady_state_days
basal_review_days
basal_late_tolerance_minutes
overnight_start
overnight_end
overnight_review_days
kg_per_unit
max_single_bolus
novorapid_before_meal_minutes
rice_exchange_carbs
fruit_exchange_carbs
meat_exchange_carbs
veg_cup_carbs
display_unit
current_schedule_profile
current_meal_plan_key
rice_exchange_kcal
fruit_exchange_kcal
meat_exchange_kcal
veg_cup_kcal
correction_1800_enabled
correction_tdd_units
correction_target_mgdl
correction_min_glucose
correction_rounding_increment
correction_rounding_mode
correction_min_interval_minutes
correction_max_units
updated_at
*
id
source_table
source_id
field_name
old_value
new_value
reason
corrected_by
created_at
*
id
sensor_model
sensor_serial
reader_name
body_location
started_at
expected_expires_at
removed_at
status
skin_reaction
failure_notes
replacement_sensor
created_at
*
id
target_low
target_high
correction_factor
carb_ratio
updated_at
*
id
alert_key
severity
glucose_value
trend
message
recipients
provider
provider_response
sent_status
created_at
*
id
contact_name
phone_number
relationship
receive_critical
receive_routine
active
created_at
*
id
alert_key
severity
glucose_value
trend
message
recipients
provider
http_code
provider_response
sent_status
created_at
*
id
sms_enabled
provider
sender_name
critical_cooldown_minutes
warning_cooldown_minutes
school_check_start
school_check_end
no_cgm_minutes_school
created_at
updated_at
*
id
school_mode
sick_day_mode
notify_teacher_in_school
sms_critical_enabled
telegram_critical_enabled
updated_at
*
state_key
state_value
updated_at
*
state_key
state_value
updated_at
*
id
alert_key
severity
glucose_value
trend
message
recipients
http_code
provider_response
sent_status
created_at
*
id
event_key
event_type
message
sent_at
*
id
chat_id
chat_type
username
first_name
last_name
active
created_at
updated_at
*
id
version_name
effective_date
target_low
target_high
rapid_insulin_name
basal_insulin_name
meal_scale_text
correction_text
basal_schedule_text
low_treatment_text
ketone_sick_day_text
clinic_name
notes
active
created_at
total_daily_dose
correction_target_mgdl
correction_isf
correction_min_interval_minutes
*
id
name
email
password
role
created_at
*
id
user_id
weight_kg
measured_at
notes
source
created_at
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column
Show
criteria
Sort
Ascending
Descending
Add as
AND
OR
Op
=
>
>=
<
<=
!=
LIKE
LIKE %...%
NOT LIKE
NOT LIKE %...%
IN (...)
NOT IN (...)
BETWEEN
NOT BETWEEN
IS NULL
IS NOT NULL
REGEXP
REGEXP ^...$
NOT REGEXP
Text
Another column
select table
alerts
app_settings
audit_logs
backup_history
cgm_readings
daily_summary
doctor_prescriptions
doctor_prescription_files
document_repository
emergency_contacts
gia_custom_foods
gia_log_edit_audit
health_events
insulin_action_reviews
insulin_dose_rules
insulin_logs
insulin_summary
ketone_logs
login_attempts
meal_logs
meal_plan_slots
meal_plan_templates
meal_plan_template_items
meal_schedule_profiles
meal_schedule_profile_slots
missed_event_logs
patient_profile
pediatric_safety_settings
record_corrections
sensors
settings
sms_alert_logs
sms_contacts
sms_delivery_logs
sms_settings
system_modes
telegram_alert_state
telegram_bot_state
telegram_delivery_logs
telegram_event_log
telegram_subscribers
treatment_plans
users
weight_history
.
select column