localhost:8080 / 127.0.0.1 / db_empower_migration / participant

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 (5519 total, Query took 0.0829 seconds.) [emergencycontact_relationship: WWIFE... - WIFE...]

SELECT * FROM `participant` ORDER BY `emergencycontact_relationship` DESC

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

Filter rows:

Sort by key:

			participant_id	firstname	lastname	middlename	dob	gender	ssn_lastfourdigits	phonenumber	email	address	city_id	state_id	zipcode	medications	special_diet	allergies	medical_needs	medical_needs_details	pregnancy	smoker	prior_treatment_drugalcohol	dl_number	dl_issued_state	dl_suspended	dl_points	court_order	blood_alcohol_content	emergencycontact_name	emergencycontact_phoneNumber	emergencycontact_relationship 1	created_date	created_by	updated_date	updated_by	notes
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 4869	4869	Herbert	Harvey		1970-03-13	M	9885	7703099885	h2laboratory@gmail.com	14616 Ona away RD	C04386	OH	44120		N.A	N.A	N.A	N.A	0	0	0	59306428	GA		0	1	NULL	Brenda Moton	6024750968	WWife	2022-11-30 17:33:26	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3881	3881	Nate	Whritenour		1994-04-07	M	0372	4192503783	nwhrotenour94@gmail.com	115 Kline Ave	C12512	OH	43532						0	0	0	Tt298872	OH		6	1	0.120	Corrie whritenour	5672778639	Wofe	2021-08-12 06:29:45	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3719	3719	Chett	Ovitt		1980-10-01	M	8870	4192063867	chett.ovitt@gmail.com	4721 Sadalia Rd	C21941	OH	43623	Prevacid 30 Zoloft 100 Buspirone 15 twice Atorv...		No sea food		Glenbeigh January to present	0	0	1	RQ382495	Oh		0	1	0.162	Allison Ovitt	4194699041	Wife/boss	2021-05-07 09:44:49	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 2305	2305	Steven	Meeks		1900-01-01	U	8691	4193924980	testerg876@aol.com	12410 SHAFFER ROAD	C21484	OH	43558						0	0	0	rr185921	OH		2	1	NULL	kenya meeks	4193928469	wife	2019-05-20 09:50:25	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3073	3073	Kevin	Roche		1986-05-03	M	1241	3378491274	kevin.roche04@gmail.com	405 seychelles lane	C11849	LA	70508						0	1	0	8151908	LA		0	1	NULL	emily roche	3186638395	wife	2020-01-20 10:30:53	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3585	3585	Nathan	Pickettay		1982-05-25	M	5122	6025868801	qpprice87@gmail.com	6610 Dorr St	C21941	OH	43615	NA	NA	NA	NA	Detox Westhaven/Dayton	0	0	1	DO6524711	AZ		0	1	NULL	Ebony McClain	6233269373	wife	2021-01-18 09:19:36	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 4865	4865	Edward	Merriman		1971-11-22	M	7936	4192795178	merriman864@gmail.com	864 Elm Street	C17231	OH	43551						0	0	0	RP360535	OH	1	4	1	0.097	Teresa Merriman	4194901770	Wife	2022-11-30 10:38:51	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 1026	1026	David	Welch		1961-08-17	M	1044	4197081012	amelia_welch@sbcglobal.net	10402 Monclova Rd	C14632	OH	43542	NA	NA	NA	NA	14 yrs prior Nazareth	0	0	1	RU544760	OH		0	1	NULL	Amelia	4194661867	wife	2018-05-29 06:34:12	MigrationUser	2025-11-17 05:02:48	MigrationUser	Migration Notes: 18 TRC 02312-A
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3842	3842	Bernard	Lamarr		1955-03-09	M	1390	3134125712	trusteelamarr55@hotmail.com	24276 Schroeder Ave.	C06510	MI	48021	Folic acid 1mg 1x - Glipizide 10mg 2x - Pantoprazo...	none	none	none	No	0	0	0	L560085018182	MI		0	1	0.135	Mrs. Selena A. Lamarr	3137493392	Wife	2021-07-08 07:37:17	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 6402	6402	Justin	Ringer		1980-10-08	M	1697	5672026953	dolphinsfan4413@gmail.com	2912 E Moreland	C16518	OH	43616	methadone	none	none	needs to pick up methadone at 6:30am daily	-	0	1	1	R52645449775	MI	1	0	1	NULL	Erin Ringer	5673951797	wife	2024-03-27 06:55:00	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 1283	1283	Jeffrey	Potter		1968-09-18	M	4361	4193040020	jpotter@skylifetech.com	3001 Squirrel Bend	C21941	OH	43617	NA	NA	NA	NA		0	0	0	RN810333	OH		0	1	NULL	Tonia Poll	4193040020	wife	2018-08-07 09:53:50	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 2819	2819	Michael	Pinson		1968-11-14	M	6091	4194642435	mike68@bex.net	2268 Scottwood Ave	C21941	OH	43620	Cholesterol, high blood pressure, reflux, muscle r...					0	0	0	None	OH		6	1	NULL	Carla Pinson		Wife	2019-10-19 12:00:13	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 4867	4867	Tom	Smith		1981-09-01	M	1316	4192973874	tsmif3@yahoo.com	2332 Castlewood Dr	C21941	OH	43613		N.A	N.A	N.A	Assessment done in 2022	0	0	1	RU518762	OH	1	0	1	NULL	Tiffany Hawkins	4199177559	Wife	2022-11-30 13:52:29	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 2308	2308	Daniel	Marchand		1961-08-09	M	4771	4193454205	keno@worker.com	3241 Marsrow Ave	C21527	OH	43615	NA	NA	NA	NA		0	0	0	RM609972	OH		0	1	NULL	Peggy Marchand	4193464205	wife	2019-05-21 06:54:51	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 773	773	Steven	Thomas		1965-09-04	M	3898	7342553358	stevehollywoodconcrete@gmail.com	5647 Dartmouth Crt	C24491	MI	48197	insulin	Na	NA	NA		0	0	0	T520777271689	MI		0	1	NULL	Carmen	7346442979	wife	2018-02-20 08:36:17	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 2565	2565	Donald	Cade		1978-06-12	M	5230	3132363756	ddcadeii@yahoo.com	6558 Bridgewater Dr	C23412	MI	48322	Lexapro, Antabuse, Benadryl, Hydromine	no beef or pork	n/a	n/a		0	0	0	C300149139440	MI		0	1	0.180	Toy Cade	3132363756	Wife	2019-08-02 08:53:06	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 774	774	Sherman	Howard		1984-11-26	M	2679	4199755680	noemail@talbotservicesdip.foxtechies.com	3332 Maplewood	C21941	OH	43610	NA	NA	NA	NA		0	0	0	SK452331	OH		0	1	NULL	Ivory	4199755680	wife	2018-02-20 08:41:48	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3334	3334	Wayne	Tolmie		1972-08-09	M	2224	4199028788	wtolmie72@gmail.com	7135 Marissa Ct	C13772	OH	43537	Metoprolol (BP)	Keto Diet				0	0	0	TZ728749	OH		0	1	0.108	Christine Tolmie	4193774749	Wife	2020-08-15 10:22:40	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 775	775	Jovan	Powell		1986-06-05	M	8450	4199845584	jjovanp23@gmail.com	5875 Yermo Dr.	C21941	OH	43613	NA	NA	NA	NA		0	1	0	SP499794	OH		0	1	NULL	Victoria	5673156371	wife	2018-02-20 11:43:35	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 2823	2823	Alan	Cullenen		1953-01-24	M	2271	4198369444	noemail@talbotservicesdip.foxtechies.com	1378 Walbridge Rd	C14394	OH	43447	Bringing medications	NA	NA	NA		0	0	0	RU511641	OH		0	1	NULL	Naomi	4192488616	wife	2019-10-21 11:15:41	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3847	3847	Trevor	Mclear		1993-11-30	M	1660	4197041720	t.mclear@aol.com	905 N Opfer-Lentz Rd	C08365	OH	43430	NA	NA	NA	NA		0	0	0	TQ883301	OH		0	1	NULL	Chelsea McLear	4194109652	wife	2021-07-13 08:58:52	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 4103	4103	John	Miller		1991-07-07	M	0459	4197049052	jc.miller16@gmail.com	3359 Bordeaux Rue	C16064	OH	43619	Insulin, Rexulti, Pristiq					0	0	0	TG895149	OH		4	1	NULL	Katie Miller		Wife	2021-12-08 10:22:46	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 6919	6919	Antonio	Gaston		1971-04-22	M	7797	8155431238	antoniogaston71@yahoo.com	2012 N Cove Blvd.	C21941	OH	43606	RosuvastatTin, triamterene, Omeprazole, allopurino...	No	No			0	0	0	G23500571115	IL	1	0	1	NULL	Renita shores-Gast Gaston	8155432789	Wife	2024-09-19 00:00:00	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 5896	5896	Bryan	Ruiz		1991-10-16	M	0925	4194389574	bryan15ruiz@gmail.com	18727 road 153	C05689	OH	43512						0	0	0	Tl661967	OH	1	8	1	NULL	Katelyn Ruiz	4194388177	wife	2023-10-05 04:29:38	MigrationUser	2025-11-17 05:02:48	MigrationUser
Edit	Copy	Delete DELETE FROM participant WHERE `participant`.`participant_id` = 3593	3593	Dillon	Baird		1989-10-23	M	6057	4194949945	dillongbaird@gmail.com	13880 Center St	C23641	OH	43569	NA	NA	NA	NA		0	0	0	TL730024	OH		0	1	NULL	Nakia Baird	4194946097	wife	2021-01-20 10:49:26	MigrationUser	2025-11-17 05:02:48	MigrationUser

Check all With selected:

Filter rows:

Sort by key:

Query results operations

Copy to clipboard

Export

Display chart

Create view