servergta.tailaf5a08.ts.net / 127.0.0.1 / greentech

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		greentech wp_actionscheduler_actions
action_id : bigint(20) unsigned
hook : varchar(191)
status : varchar(20)
scheduled_date_gmt : datetime
scheduled_date_local : datetime
priority : tinyint(3) unsigned
args : varchar(191)
schedule : longtext
group_id : bigint(20) unsigned
attempts : int(11)
last_attempt_gmt : datetime
last_attempt_local : datetime
claim_id : bigint(20) unsigned
extended_args : varchar(8000)

v		greentech wp_actionscheduler_claims
claim_id : bigint(20) unsigned
date_created_gmt : datetime

v		greentech wp_actionscheduler_groups
group_id : bigint(20) unsigned
slug : varchar(255)

v		greentech wp_actionscheduler_logs
log_id : bigint(20) unsigned
action_id : bigint(20) unsigned
message : text
log_date_gmt : datetime
log_date_local : datetime

v		greentech wp_commentmeta
meta_id : bigint(20) unsigned
comment_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		greentech wp_comments
comment_ID : bigint(20) unsigned
comment_post_ID : bigint(20) unsigned
comment_author : tinytext
comment_author_email : varchar(100)
comment_author_url : varchar(200)
comment_author_IP : varchar(100)
comment_date : datetime
comment_date_gmt : datetime
comment_content : text
comment_karma : int(11)
comment_approved : varchar(20)
comment_agent : varchar(255)
comment_type : varchar(20)
comment_parent : bigint(20) unsigned
user_id : bigint(20) unsigned

v		greentech wp_gta_drivers
id : bigint(20) unsigned
driver_name : varchar(150)
phone : varchar(50)
status : varchar(30)
notes : text
created_at : datetime
line_user_id : varchar(100)
line_link_code : varchar(100)

v		greentech wp_gta_ele_employees
id : bigint(20) unsigned
employee_code : varchar(80)
full_name : varchar(255)
department : varchar(150)
active : tinyint(1)
created_at : datetime

v		greentech wp_gta_ele_results
id : bigint(20) unsigned
employee_id : bigint(20) unsigned
course_id : bigint(20) unsigned
score : decimal(5,2)
passed : tinyint(1)
attempt : int(11)
completed_at : datetime

v		greentech wp_gta_employees
id : bigint(20) unsigned
employee_code : varchar(50)
nationality : varchar(80)
employment_type : varchar(80)
thai_prefix : varchar(30)
thai_first_name : varchar(120)
thai_last_name : varchar(120)
thai_nickname : varchar(80)
en_prefix : varchar(30)
en_first_name : varchar(120)
en_last_name : varchar(120)
en_nickname : varchar(80)
birth_date : date
start_date : date
position : varchar(180)
department : varchar(180)
company : varchar(220)
phone : varchar(80)
raw_json : longtext
updated_at : datetime
created_at : datetime
national_id : varchar(50)
day_119 : varchar(120)
age : varchar(100)
bank_name : varchar(160)
bank_account_name : varchar(220)
bank_account_number : varchar(100)
address : text
postal_code : varchar(20)
termination_date : date
termination_reason : text

v		greentech wp_gta_employee_training
id : bigint(20) unsigned
employee_code : varchar(50)
course_name : varchar(255)
training_date : varchar(30)
provider : varchar(190)
training_type : varchar(100)
hours : decimal(8,2)
result : varchar(50)
certificate_expiry : varchar(30)
attachment_url : text
notes : text
created_at : datetime

v		greentech wp_gta_kitchen_allocations
id : bigint(20) unsigned
expense_id : bigint(20) unsigned
category : varchar(100)
amount : decimal(12,2)
sort_order : int(11)

v		greentech wp_gta_kitchen_expenses
id : bigint(20) unsigned
expense_date : date
payee : varchar(190)
bill_total : decimal(12,2)
item_desc : text
category : varchar(100)
amount : decimal(12,2)
note : text
receipt_url : text
created_by : bigint(20) unsigned
created_at : datetime
supplier_id : bigint(20) unsigned
supplier_name : varchar(190)

v		greentech wp_gta_kitchen_suppliers
id : bigint(20) unsigned
supplier_name : varchar(190)
is_active : tinyint(1)
created_by : bigint(20) unsigned
created_at : datetime

v		greentech wp_gta_leave_employees
id : bigint(20) unsigned
employee_code : varchar(50)
full_name : varchar(190)
position_name : varchar(190)
department : varchar(190)

v		greentech wp_gta_rm_requests
id : bigint(20) unsigned
request_no : varchar(40)
requester_name : varchar(190)
department : varchar(100)
phone : varchar(50)
request_date : date
request_time : varchar(20)
product_name : varchar(190)
qty : decimal(12,2)
unit : varchar(50)
weight : decimal(12,2)
destination : text
requester_note : text
status : varchar(50)
handler_name : varchar(190)
handler_department : varchar(100)
handler_phone : varchar(50)
delivery_date : date
delivery_time : varchar(20)
packing_no : varchar(100)
lot_no : varchar(100)
bag_no : varchar(100)
actual_weight : decimal(12,2)
material_image : varchar(500)
warehouse_note : text
created_at : datetime
updated_at : datetime
items_json : longtext
purpose : text
urgency : varchar(20)
requester_email : varchar(190)
requester_line_user_id : varchar(100)
requester_line_code : varchar(32)
employee_id : varchar(80)
deleted_at : datetime

v		greentech wp_gta_training_history
id : bigint(20) unsigned
employee_code : varchar(50)
course_name : varchar(255)
training_date : date
provider : varchar(255)
training_type : varchar(120)
hours : decimal(8,2)
result : varchar(80)
certificate_expiry : date
certificate_url : text
notes : text
created_at : datetime

v		greentech wp_gta_vehicles
id : bigint(20) unsigned
vehicle_name : varchar(150)
plate_no : varchar(50)
seats : int(11)
status : varchar(30)
notes : text
created_at : datetime

v		greentech wp_gta_vehicle_bookings
id : bigint(20) unsigned
booking_no : varchar(50)
requester_name : varchar(180)
department : varchar(120)
phone : varchar(50)
passenger_count : int(11)
start_datetime : datetime
end_datetime : datetime
destination : text
purpose : text
requested_vehicle_id : bigint(20) unsigned
assigned_vehicle_id : bigint(20) unsigned
assigned_driver_id : bigint(20) unsigned
notes : text
status : varchar(30)
admin_note : text
created_at : datetime
updated_at : datetime
driver_job_token : varchar(100)
driver_first_name : varchar(100)
driver_last_name : varchar(100)
trip_plate_no : varchar(80)
accepted_at : datetime
actual_start_datetime : datetime
start_odometer : decimal(12,1)
start_odometer_photo : text
actual_end_datetime : datetime
end_odometer : decimal(12,1)
end_odometer_photo : text
distance_km : decimal(12,1)
vehicle_source : varchar(20)
private_vehicle_model : varchar(150)
private_plate_no : varchar(80)
private_owner_name : varchar(180)
driver_mode : varchar(20)
private_vehicle_make : varchar(150)
private_vehicle_plate : varchar(80)
private_vehicle_owner : varchar(180)

v		greentech wp_gti_helpdesk
id : bigint(20)
ticket_number : varchar(50)
requester_name : varchar(255)
department : varchar(255)
phone : varchar(100)
issue_type : varchar(255)
urgency : varchar(100)
description : longtext
image_url : varchar(500)
status : varchar(100)
technician : varchar(255)
solution : longtext
created_at : datetime
updated_at : datetime

v		greentech wp_gtmi_rsvp
id : bigint(20) unsigned
full_name : varchar(190)
response : varchar(20)
created_at : datetime
updated_at : datetime

v		greentech wp_kc_uu_history
id : bigint(20) unsigned
entry_id : varchar(50)
date : datetime
search_for : text
replace_with : text
tables : text
case_insensitive : tinyint(1)
replace_guids : tinyint(1)
total_changes : int(10) unsigned
total_updates : int(10) unsigned
undone : tinyint(1)
undo_recorded : int(10) unsigned
undo_restored : int(10) unsigned
undo_skipped : int(10) unsigned
undo_status : varchar(20)
details : longtext

v		greentech wp_kc_uu_profiles
id : bigint(20) unsigned
name : varchar(255)
search_for : text
replace_with : text
select_tables : text
case_insensitive : varchar(5)
replace_guids : varchar(5)

v		greentech wp_kc_uu_undo
id : bigint(20) unsigned
entry_id : varchar(50)
table_name : varchar(191)
column_name : varchar(191)
row_pk : varchar(191)
old_value : longtext
old_hash : char(40)
new_hash : char(40)
restored : tinyint(1)
outcome : varchar(16)
skip_reason : varchar(24)

v		greentech wp_links
link_id : bigint(20) unsigned
link_url : varchar(255)
link_name : varchar(255)
link_image : varchar(255)
link_target : varchar(25)
link_description : varchar(255)
link_visible : varchar(20)
link_owner : bigint(20) unsigned
link_rating : int(11)
link_updated : datetime
link_rel : varchar(255)
link_notes : mediumtext
link_rss : varchar(255)

v		greentech wp_options
option_id : bigint(20) unsigned
option_name : varchar(191)
option_value : longtext
autoload : varchar(20)

v		greentech wp_postmeta
meta_id : bigint(20) unsigned
post_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		greentech wp_posts
ID : bigint(20) unsigned
post_author : bigint(20) unsigned
post_date : datetime
post_date_gmt : datetime
post_content : longtext
post_title : text
post_excerpt : text
post_status : varchar(20)
comment_status : varchar(20)
ping_status : varchar(20)
post_password : varchar(255)
post_name : varchar(200)
to_ping : text
pinged : text
post_modified : datetime
post_modified_gmt : datetime
post_content_filtered : longtext
post_parent : bigint(20) unsigned
guid : varchar(255)
menu_order : int(11)
post_type : varchar(20)
post_mime_type : varchar(100)
comment_count : bigint(20)

v		greentech wp_termmeta
meta_id : bigint(20) unsigned
term_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		greentech wp_terms
term_id : bigint(20) unsigned
name : varchar(200)
slug : varchar(200)
term_group : bigint(10)

v		greentech wp_term_relationships
object_id : bigint(20) unsigned
term_taxonomy_id : bigint(20) unsigned
term_order : int(11)

v		greentech wp_term_taxonomy
term_taxonomy_id : bigint(20) unsigned
term_id : bigint(20) unsigned
taxonomy : varchar(32)
description : longtext
parent : bigint(20) unsigned
count : bigint(20)

v		greentech wp_usermeta
umeta_id : bigint(20) unsigned
user_id : bigint(20) unsigned
meta_key : varchar(255)
meta_value : longtext

v		greentech wp_users
ID : bigint(20) unsigned
user_login : varchar(60)
user_pass : varchar(255)
user_nicename : varchar(50)
user_email : varchar(100)
user_url : varchar(100)
user_registered : datetime
user_activation_key : varchar(255)
user_status : int(11)
display_name : varchar(250)

v		greentech wp_wpmailsmtp_debug_events
id : int(10) unsigned
content : text
initiator : text
event_type : tinyint(3) unsigned
created_at : timestamp

v		greentech wp_wpmailsmtp_tasks_meta
id : bigint(20)
action : varchar(255)
data : longtext
date : datetime

Create relationship
FOREIGN KEY
on delete
on update