Database

Live Table Manager

Search, add, edit, and delete records in the live workflow tables, including the payment transaction ledger. Every save and delete is logged.

Jump To Module

Backend Home Change Log Backup First

This is a direct live-data tool. Create a backup snapshot before deleting or doing broad edits.

Customer Totals Daily Customer Totals

Daily Customer Totals

Add New Record

legacy_id

int(11) Â· nullable

customer_date

datetime Â· required

total_customers

decimal(10,2) Â· required

new_customers

decimal(10,2) Â· required

cash_sales

decimal(10,2) Â· required

edwards

decimal(10,2) Â· required

check_sales

decimal(10,2) Â· required

credit_card_sales

decimal(10,2) Â· required

total_sales

decimal(10,2) Â· required

total_sales_no_edwards

decimal(10,2) Â· required

dopu_can

varchar(100) Â· nullable

customer_name

varchar(255) Â· nullable

update_flag

varchar(50) Â· nullable

receipts

text Â· nullable

skyler_worked

tinyint(1) Â· required

skyler_pay

decimal(10,2) Â· required

ella_pay

decimal(10,2) Â· required

varchar(255) Â· nullable

lola

varchar(100) Â· nullable

created_at

datetime Â· required

edwards_type

varchar(40) Â· nullable

tips

decimal(10,2) Â· required

Find Records

Showing up to 75 newest/matching records. Use table-specific pages for normal workflow edits when possible.

Results

Daily Customer Totals Rows

Action	daily_customer_totals_id	customer_name	customer_date	total_customers	new_customers	cash_sales	check_sales	credit_card_sales	edwards	tips	total_sales	total_sales_no_edwards
Delete Edit	6171		2026-05-01 00:00:00	10.00	4.00	60.15	67.41	401.40	0.00	23.72	552.68	552.68
Delete Edit	6160		2026-05-09 00:00:00	8.00	6.00	10.70	0.00	565.85	0.00	0.00	576.55	576.55
Delete Edit	6126		2026-04-18 00:00:00	15.00	4.00	187.25	0.00	653.15	0.00	86.49	926.89	926.89
Delete Edit	6115		2026-05-03 00:00:00	11.00	8.00	0.00	0.00	256.80	0.00	13.91	270.71	270.71
Delete Edit	6103		2026-04-25 00:00:00	9.00	6.00	0.00	0.00	747.65	0.00	92.72	840.37	840.37
Delete Edit	6099		2026-05-08 00:00:00	9.00	8.00	100.00	0.00	506.62	0.00	56.44	663.06	663.06
Delete Edit	6032		2026-04-27 00:00:00	7.00	6.00	0.00	0.00	123.05	150.00	0.00	273.05	123.05
Delete Edit	6030		2026-03-20 00:00:00	12.00	1.00	80.00	0.00	1376.93	0.00	0.00	1456.93	1456.93
Delete Edit	6018		2026-05-06 00:00:00	1.00	1.00	0.00	0.00	0.00	150.00	0.00	150.00	0.00
Delete Edit	6016		2026-05-05 00:00:00	1.00	1.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	6014		2026-05-04 00:00:00	13.00	8.00	27.82	0.00	1246.84	0.00	88.81	1363.47	1363.47
Delete Edit	6002		2026-04-13 00:00:00	10.00	3.00	32.06	0.00	475.92	0.00	41.42	770.69	770.69
Delete Edit	5999		2026-04-24 00:00:00	6.00	1.00	0.00	0.00	850.45	0.00	36.11	886.56	886.56
Delete Edit	5944		2026-02-23 00:00:00	14.00	0.00	0.00	0.00	1744.72	0.00	0.00	1744.72	1744.72
Delete Edit	5942		2026-04-17 00:00:00	12.00	3.00	30.25	0.00	166.80	0.00	14.75	211.80	211.80
Delete Edit	5893		2026-01-30 00:00:00	17.00	0.00	0.00	0.00	1208.13	0.00	0.00	1208.13	1208.13
Delete Edit	5888		2026-05-02 00:00:00	7.00	3.00	0.00	0.00	335.65	0.00	21.11	356.76	356.76
Delete Edit	5822		2026-04-05 00:00:00	38.00	11.00	200.00	0.00	1057.74	0.00	0.59	1258.33	1258.33
Delete Edit	5813		2026-04-26 00:00:00	10.00	6.00	0.00	0.00	428.25	0.00	37.72	465.97	465.97
Delete Edit	5811		2026-04-12 00:00:00	12.00	5.00	0.00	0.00	859.30	0.00	106.28	965.58	965.58
Delete Edit	5809		2026-04-04 00:00:00	40.00	8.00	143.00	0.00	921.93	0.00	0.00	1064.93	1064.93
Delete Edit	5797		2026-04-11 00:00:00	15.00	6.00	140.00	0.00	503.60	0.00	12.84	656.44	656.44
Delete Edit	5791		2026-04-03 00:00:00	41.00	9.00	385.80	0.00	2985.54	0.00	0.00	3371.34	3371.34
Delete Edit	5637		2026-03-23 00:00:00	45.00	7.00	40.00	0.00	788.43	0.00	90.95	919.38	919.38
Delete Edit	5561		2026-03-28 00:00:00	34.00	11.00	0.00	0.00	1045.07	0.00	109.92	1154.99	1154.99
Delete Edit	5557		2026-03-21 00:00:00	29.00	9.00	150.00	0.00	3173.32	0.00	235.40	3558.72	3558.72
Delete Edit	5542		2026-04-10 00:00:00	11.00	7.00	204.00	0.00	791.05	0.00	0.00	995.05	995.05
Delete Edit	5517	Spreadsheet Import	2026-04-23 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5516	Spreadsheet Import	2026-04-22 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5515	Spreadsheet Import	2026-04-21 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5514	Spreadsheet Import	2026-04-20 00:00:00	9.00	4.00	403.00	0.00	490.25	0.00	0.00	893.25	893.25
Delete Edit	5513	Spreadsheet Import	2026-04-19 00:00:00	18.00	8.00	56.00	23.54	158.49	0.00	0.00	238.03	238.03
Delete Edit	5510	Spreadsheet Import	2026-04-16 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5509	Spreadsheet Import	2026-04-15 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5508	Spreadsheet Import	2026-04-14 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5503	Spreadsheet Import	2026-04-09 00:00:00	1.00	1.00	0.00	0.00	18.88	150.00	0.00	168.88	18.88
Delete Edit	5502	Spreadsheet Import	2026-04-08 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5501	Spreadsheet Import	2026-04-07 00:00:00	1.00	1.00	0.00	0.00	2.27	0.00	0.00	2.27	2.27
Delete Edit	5500	Spreadsheet Import	2026-04-06 00:00:00	9.00	5.00	85.00	0.00	530.18	0.00	0.00	615.18	615.18
Delete Edit	5496	Spreadsheet Import	2026-04-02 00:00:00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	5296		2026-03-29 00:00:00	40.00	0.00	0.00	0.00	377.17	0.00	0.00	377.17	377.17
Delete Edit	5292		2026-02-16 00:00:00	14.00	0.00	0.00	0.00	944.25	0.00	0.00	944.25	944.25
Delete Edit	4990	Daily Total	2026-02-20 00:00:00	14.00	3.00	150.00	0.00	1149.17	100.00	0.00	1399.17	1299.17
Delete Edit	4986	Daily Total	2026-01-31 00:00:00	28.00	8.00	200.00	0.00	3169.77	0.00	0.00	3369.77	3369.77
Delete Edit	4798	Daily Total	2026-03-30 00:00:00	44.00	5.00	0.00	0.00	859.54	0.00	80.25	859.54	859.54
Delete Edit	4774	Daily Total	2026-03-08 00:00:00	29.00	4.00	20.00	24.00	1350.47	0.00	0.00	1394.47	1394.47
Delete Edit	4772	Daily Total	2026-03-07 00:00:00	30.00	8.00	70.00	0.00	2019.02	0.00	0.00	2089.02	2089.02
Delete Edit	4771	Daily Total	2026-03-02 00:00:00	26.00	6.00	50.00	0.00	1957.65	0.00	0.00	2007.65	2007.65
Delete Edit	4769	Daily Total	2026-03-01 00:00:00	31.00	7.00	20.00	0.00	1712.05	0.00	0.00	1732.05	1732.05
Delete Edit	4768	Daily Total	2026-02-28 00:00:00	28.00	7.00	0.00	107.00	5189.26	0.00	0.00	5296.26	5296.26
Delete Edit	4767	Daily Total	2026-02-27 00:00:00	28.00	10.00	0.00	0.00	1442.20	0.00	0.00	1442.20	1442.20
Delete Edit	4764	Daily Total	2026-02-22 00:00:00	30.00	10.00	0.00	0.00	2345.25	0.00	0.00	2345.25	2345.25
Delete Edit	4763	Daily Total	2026-02-21 00:00:00	29.00	10.00	0.00	0.00	3091.95	0.00	0.00	3091.95	3091.95
Delete Edit	4761	Daily Total	2026-02-13 00:00:00	26.00	9.00	20.00	0.00	749.03	200.00	0.00	969.03	769.03
Delete Edit	4757	Daily Total	2026-02-08 00:00:00	37.00	8.00	90.00	0.00	2026.95	0.00	0.00	2116.95	2116.95
Delete Edit	4756	Daily Total	2026-02-06 00:00:00	16.00	2.00	60.00	0.00	562.40	0.00	0.00	622.40	622.40
Delete Edit	4755	Daily Total	2026-02-02 00:00:00	30.00	4.00	15.00	0.00	2111.11	0.00	0.00	2126.11	2126.11
Delete Edit	4754	Daily Total	2026-02-01 00:00:00	39.00	11.00	188.00	0.00	2035.61	0.00	0.00	2223.61	2223.61
Delete Edit	4746	Daily Total	2026-01-25 00:00:00	30.00	11.00	0.00	0.00	1876.49	0.00	0.00	1876.49	1876.49
Delete Edit	4742	Daily Total	2026-02-12 00:00:00	1.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00	0.00
Delete Edit	4741	Daily Total	2026-02-09 00:00:00	31.00	7.00	79.78	0.00	1656.36	0.00	0.00	1736.14	1736.14
Delete Edit	4739	Daily Total	2026-01-24 00:00:00	26.00	5.00	100.00	0.00	1093.77	0.00	0.00	1193.77	1193.77
Delete Edit	4737	Daily Total	2026-01-23 00:00:00	31.00	6.00	461.25	0.00	1148.39	0.00	0.00	1609.64	1609.64
Delete Edit	4735	Daily Total	2026-01-18 00:00:00	32.00	6.00	100.00	0.00	1626.74	0.00	0.00	1726.74	1726.74
Delete Edit	4732	Daily Total	2026-01-17 00:00:00	30.00	4.00	218.00	0.00	1930.82	0.00	0.00	2148.82	2148.82
Delete Edit	4731	Daily Total	2026-01-16 00:00:00	33.00	7.00	21.00	0.00	2305.87	0.00	0.00	2326.87	2326.87
Delete Edit	4730	Daily Total	2026-01-11 00:00:00	35.00	10.00	91.00	0.00	1195.84	0.00	0.00	1286.84	1286.84
Delete Edit	4726	Daily Total	2026-01-10 00:00:00	31.00	7.00	220.00	0.00	1870.80	0.00	0.00	2090.80	2090.80
Delete Edit	4724	Daily Total	2026-01-09 00:00:00	21.00	9.00	123.00	0.00	888.16	0.00	0.00	1011.16	1011.16
Delete Edit	4723	Daily Total	2026-01-05 00:00:00	33.00	6.00	36.00	0.00	3689.15	0.00	0.00	3725.15	3725.15
Delete Edit	4719	Daily Total	2026-01-04 00:00:00	19.00	2.00	60.00	0.00	1524.45	0.00	0.00	1584.45	1584.45
Delete Edit	4717	Daily Total	2026-01-03 00:00:00	23.00	4.00	242.00	0.00	1846.62	0.00	0.00	2088.62	2088.62
Delete Edit	4716	Daily Total	2026-01-02 00:00:00	22.00	7.00	120.00	0.00	1111.97	0.00	0.00	1231.97	1231.97
Delete Edit	4715	Daily Total	2025-12-28 00:00:00	18.00	6.00	0.00	0.00	1980.60	0.00	0.00	1980.60	1980.60
Delete Edit	4542	Daily Total	2026-03-27 00:00:00	21.00	9.00	0.00	0.00	710.24	0.00	0.00	710.24	710.24