facexlondon.eu.loclx.io / 127.0.0.1 / face_x_clinic_db / opd_patients

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 :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (455 total, Query took 0.0003 seconds.)

SELECT * FROM `opd_patients`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

Sort by key:

			id	opd_number รหัสผู้ป่วย OPDXXXXX	first_name ชื่อจริง	last_name นามสกุล	nickname ชื่อเล่น	date_of_birth	gender	phone_number เบอร์โทรศัพท์ (อาจซ้ำได้? ถ้าไม่ UNIQUE ให้ลบออก)	email	contact_channel ช่องทางติดต่อหลัก	contact_details รายละเอียดช่องทางติดต่อ (Line ID, Email)	address_line1	address_line2	city	postcode	country	referral_source ช่องทางที่รู้จักคลินิก	medical_conditions	allergies	current_medications	created_at	updated_at	created_by FK อ้างอิง user ที่เพิ่มข้อมูล	is_deleted สถานะการลบ (Soft Delete)
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 3	3	OPD00003	ham	jijun	ham_nick	1991-03-09	Other	0804016749	x@x.com	Line	hamklp	Flat 6	Alex	London	N4 2LQ	United Kingdom	NULL	ไม่มี	ไม่มี	ไม่มี	2025-04-01 18:01:51	2025-04-05 18:30:30	1	1
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 5	5	OPD00005	นภัท	ดีงาม	อาร์ม	1998-04-01	Female	0800000000	k@k.com	Line	oooop	y	y	y	J1 2KQ	United Kingdom	NULL	NULL	NULL	NULL	2025-04-05 12:36:24	2025-04-05 12:39:58	1	1
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 33	33	OPD00011	สมชาย	เข็มกลัด	มอส2	1991-03-09	Male	0897742093	x@y.com	Line	kkl	12	23	44	N1 KL2	United Kingdom	NULL	PCD	NULL	NULL	2025-04-06 22:02:15	2025-04-09 19:59:23	1	1
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 36	36	OPD00014	Praphasri	Jarernnak	Jee	1986-01-09	Female	07442362895	Praphasri_jarennak@yahoo.com	WhatsApp	07442362895	Neo Bankside, Building (Flat D805)	5 Sumner St., City of London , SE 19RE	London	SE1 9RE	United Kingdom	NULL	No	No	No	2025-05-10 16:41:05	2025-05-10 16:41:05	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 37	37	OPD00015	Wanida	Phraephasa	Marky	1978-12-13	Female	07495322074	NULL	WhatsApp	NULL	NULL	NULL	NULL	SM1 2AF	United Kingdom	NULL	NULL	NULL	NULL	2025-05-24 14:14:11	2025-05-24 14:14:11	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 38	38	OPD00016	Ratchanikorn	Tulezi	Ratchanikorn	1975-02-02	Female	07739547573	ratchanikornt@icloud.com	WhatsApp	NULL	19 flats	NULL	London	Nw65al	United Kingdom	NULL	แพ้อาหาร กุ้ง	อาหารทะเล	วิตามิน บีรวม ดี และ ซี 🔍 Consultation Summary: ...	2025-06-01 17:51:34	2025-06-09 23:19:50	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 39	39	OPD00017	Patimaporn	Saekhow	AUY	1984-11-30	Female	07414289889	nomprink.aui@gmail.com	WhatsApp	07414289889	Flat38 Barrie house	NULL	London	N160tx	United Kingdom	NULL	NULL	NULL	NULL	2025-06-04 10:09:42	2025-06-11 18:28:11	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 40	40	OPD00018	Chaitud	Tongpoondee	Got	1972-08-22	Male	07593634464	NULL	WhatsApp	07593634464	Flat 38 Barrie house	NULL	London	N160tx	United Kingdom	NULL	NULL	NULL	NULL	2025-06-04 10:11:37	2025-06-15 10:05:17	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 41	41	OPD00019	Phanphatchara	Banbua	Panbo	2022-03-23	Female	07828514424	kp_pan2123@hotmail.com	WhatsApp	NULL	123 Snowsfildes	NULL	London	SE1 3ST	United Kingdom	NULL	No	No	No	2025-06-04 17:11:41	2025-06-04 17:11:41	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 42	42	OPD00020	Natcha	Pratoomdang	Mint	NULL	NULL	07429137752	NULL	NULL	NULL	NULL	NULL	NULL	NULL	United Kingdom	NULL	NULL	NULL	NULL	2025-06-07 13:07:36	2025-06-07 13:07:36	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 43	43	OPD00021	Napasorn	Kruaeboon	Tan	1998-02-23	Female	07762255849	tarnnps@live.com	Email	tarnnps@live.com	44 Cassia Building, Gorsuch Place	NULL	London	E2 8HY	United Kingdom	NULL	N/A	N/A	🧾 สรุปการรักษา (สำหรับบัญชีและติดตามผล) 📅 วันที...	2025-06-08 10:24:19	2025-06-09 07:57:14	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 44	44	OPD00022	Nuchjanard	Chansri	Benz	1996-12-08	Female	07923804881	NULL	WhatsApp	07923804881	96 London road brentford	NULL	Brentford	Tw8 8jj	United Kingdom	NULL	NULL	NULL	📅 วันที่รักษา: 8 มิถุนายน 2025 👩‍⚕️ แพทย์ผู้ดูแล:...	2025-06-08 11:07:32	2025-06-09 23:21:29	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 45	45	OPD00023	Chanodom	Boonrungreung	James	1980-06-15	Male	07853656558	jboon2021@gmail.com	WhatsApp	NULL	119 Shenley Avenue	Ruislip	London	HA4 6BU	United Kingdom	NULL	NULL	NULL	📅 วันที่รักษา: 8 มิถุนายน 2025 👩‍⚕️ แพทย์ผู้ดูแล:...	2025-06-08 13:16:28	2025-06-09 23:20:55	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 46	46	OPD00024	Somying	soragja	Joy	1981-02-04	Female	07841675821	joy2222@hotmail.co.uk	Phone	NULL	13	Norton Close	London	E4 8LS	United Kingdom	NULL	NULL	NULL	สรุปการรักษา:9/6/25 1. Juvelook 1 vial (ครั้งที่...	2025-06-09 10:19:06	2025-06-09 23:18:23	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 47	47	OPD00025	June	Wilson	June	1982-05-06	Female	07469455551	June.nopparat@gmail.com	WhatsApp	NULL	32 Rockingham Avenue,	NULL	, Hornchurch	Rm11 1Hh	United Kingdom	NULL	NULL	NULL	9/6/25 สรุปการรักษา: 1. Botox Allergan 3 จุด ...	2025-06-09 10:24:30	2025-06-09 23:31:38	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 48	48	OPD00026	Chaba	Komram	Chaba	1982-12-05	Female	07975915795	kchaba1313@gmail.com	Other	fb	48 HERON HILL Bexleyheath London	NULL	London	DA17 5HF	United Kingdom	NULL	-	-	สรุปการรักษา: 1. Botox Allergan 3 จุด (หน้าผาก, ...	2025-06-09 16:27:12	2025-06-09 23:43:47	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 49	49	OPD00027	Chotika	Rinthong	Jenny	1982-06-01	NULL	07516320234	NULL		NULL	NULL	NULL	NULL	NULL	United Kingdom	NULL	NULL	NULL	9/6/25 หมอสรุปรายการรักษาไว้ให้เรียบร้อยแล้วค่ะ ...	2025-06-09 17:16:16	2025-06-09 23:52:32	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 50	50	OPD00028	Nang myint	Myint win	Mint	1978-11-30	Female	07869282989	NULL	WhatsApp	NULL	13,wiltshirt house	Avenue road	Acton town,London	W38ys	United Kingdom	NULL	Tachycardia, bppv บ้านหมุนเวียนหัว ยาบรรเทา ปรับพฤ...	NULL	NULL	2025-06-10 11:18:30	2025-06-10 11:18:30	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 51	51	OPD00029	Natthanicha	Thanapithakkul	Natt	1976-02-15	Female	07963585644	natalee_naja@hotmail.com	WhatsApp	NULL	20	NULL	Royston	SG87DS	United Kingdom	NULL	NULL	NULL	NULL	2025-06-11 17:32:38	2025-06-11 17:32:38	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 52	52	OPD00030	Manasanan	Thanantaseth	Bell	NULL	Female	07957642252	b_e_ll_e7@hotmail.com	WhatsApp	NULL	NULL	NULL	NULL	NULL	United Kingdom	NULL	NULL	NULL	NULL	2025-06-11 18:53:22	2025-06-11 18:53:22	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 55	55	OPD00031	Casper	SB	Yutt	NULL	Male	079576422520000	b_e_ll_e7@hotmail.com0	WhatsApp	NULL	NULL	NULL	NULL	NULL	United Kingdom	NULL	NULL	NULL	NULL	2025-06-11 18:55:49	2025-06-11 18:55:49	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 56	56	OPD00032	Suchada	Charoensiri	Kin	1996-11-08	Female	07880176890	kingshawol39@gmail.com	WhatsApp	07880176890	18A Studland street	NULL	London	W6 0JS	United Kingdom	NULL	NULL	NULL	NULL	2025-06-12 17:31:41	2025-06-12 17:31:41	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 57	57	OPD00033	Varisa	Piriyakitphaiboon	June	NULL	NULL	07769065301	NULL	NULL	NULL	NULL	NULL	NULL	NULL	United Kingdom	NULL	None	None	None	2025-06-15 11:05:57	2025-06-15 11:05:57	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 58	58	OPD00034	Kamonchanok	Srisaovanant	Gift	NULL	NULL	07956059998	k.srisaovanant@gmail.com	NULL	NULL	NULL	NULL	NULL	NW1 7BF	United Kingdom	NULL	NULL	NULL	NULL	2025-06-15 12:54:50	2025-06-15 12:54:50	1	0
Edit	Copy	Delete DELETE FROM opd_patients WHERE `opd_patients`.`id` = 59	59	OPD00035	Piyanan	Vongduangpha	Nana	1993-05-06	Female	07519541047	piyananvongduangpha36@gmil.com	Phone	NULL	NULL	NULL	NULL	NW1 6TL	United Kingdom	NULL	-	-	-	2025-06-15 14:27:07	2025-06-15 14:27:07	1	0

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view