Aggregated Data Table Structure

1. Table Columns

Field	Type	Null	Key	Default	Extra
sparkle_id	bigint(20)	NO	PRI		auto_increment
parent_companies-name	varchar(44)	YES
parent_companies-qid	varchar(18)	YES
companies-child_company_name	varchar(30)	YES
companies-qid	varchar(18)	YES
companies-id	bigint(20)	YES
type	varchar(12)	YES
item_company_id	bigint(20)	YES
ticket_id	double	YES
action_at	datetime	YES
action_at_date_in_tz	datetime	YES
scheduled_at	text	YES
scheduled_at_date_in_tz	text	YES
created_at	datetime	YES
created_at_date_in_tz	datetime	YES
item_start_at	datetime	YES
item_start_at_date_in_tz	datetime	YES
adjustment_id	double	YES
item_id	double	YES
item_type	varchar(20)	YES
item_label	varchar(50)	YES
item_class	varchar(62)	YES
item_quantity	double	YES
item_employee_id	double	YES
item_employee_name	varchar(30)	YES
item_client_id	double	YES
item_client_name	varchar(48)	YES
item_client_email	varchar(70)	YES
item_client_mobile_phone	varchar(28)	YES
item_client_home_phone	varchar(28)	YES
item_client_work_phone	varchar(28)	YES
item_child_id	double	YES
item_child_label	varchar(52)	YES
item_child_secondary_label	varchar(68)	YES
item_child_is_deceased	varchar(10)	YES
source	varchar(16)	YES
appt_status	text	YES
service_duration	text	YES
appt_id	text	YES
days_since_last_appointment	text	YES
client_appointment_rank	text	YES
item_amount	text	YES
item_amount_before_discount	text	YES
discount_amount	text	YES
sub_item_id	double	YES
sub_item_type	varchar(32)	YES
sub_item_label	varchar(32)	YES
sub_item_class	varchar(58)	YES
category_id	text	YES
category_type	text	YES
category_label	text	YES
category_class	text	YES
in_membership	varchar(8)	YES
in_package	varchar(10)	YES
usage_amount	text	YES
usage_original_amount	text	YES
gift_cards_prepaid_amount	text	YES
item_return_id	double	YES
refund_amount	double	YES
item_edit_id	text	YES
edit_amount	text	YES
edit_amount_before_discount	text	YES
item_tax_id	text	YES
tax_amount	text	YES
payment_item_id	text	YES
payment_id	text	YES
payment_type	text	YES
payment_label	text	YES
payment_class	text	YES
payment_amount	text	YES
payment_amount_collected	text	YES
payment_hold_amount	text	YES
payment_deposit	text	YES
payment_charged_at	text	YES
payment_status	text	YES
time_zone	datetime	YES
location_id	double	YES
ticket_uuid	varchar(16)	YES
ticket_raw_status	double	YES
ticket_status	varchar(12)	YES
ticket_closed_at	datetime	YES
ticket_closed_at_date_in_tz	datetime	YES
locations-qid	varchar(18)	YES
location_nickname	varchar(30)	YES
location_store_id	varchar(14)	YES
location_entity_id	text	YES
location_street_address	varchar(48)	YES
location_street_address_2	varchar(18)	YES
location_zip_code	bigint(20)	YES
location_city	varchar(30)	YES
location_state	varchar(4)	YES
location_time_zone	datetime	YES
location_resource_count	text	YES
employees-qid	varchar(18)	YES
employee_name	varchar(26)	YES
ticket_client_id	double	YES
ticket_client_walk_in	double	YES
ticket_client_name	varchar(46)	YES
ticket_client_email	varchar(70)	YES
import_date	date	NO	MUL
import_timestamp	timestamp	YES	MUL	current_timestamp()

2. Sample Data (5 rows)

sparkle_id	parent_companies-name	parent_companies-qid	companies-child_company_name	companies-qid	companies-id	type	item_company_id	ticket_id	action_at	action_at_date_in_tz	scheduled_at	scheduled_at_date_in_tz	created_at	created_at_date_in_tz	item_start_at	item_start_at_date_in_tz	adjustment_id	item_id	item_type	item_label	item_class	item_quantity	item_employee_id	item_employee_name	item_client_id	item_client_name	item_client_email	item_client_mobile_phone	item_client_home_phone	item_client_work_phone	item_child_id	item_child_label	item_child_secondary_label	item_child_is_deceased	source	appt_status	service_duration	appt_id	days_since_last_appointment	client_appointment_rank	item_amount	item_amount_before_discount	discount_amount	sub_item_id	sub_item_type	sub_item_label	sub_item_class	category_id	category_type	category_label	category_class	in_membership	in_package	usage_amount	usage_original_amount	gift_cards_prepaid_amount	item_return_id	refund_amount	item_edit_id	edit_amount	edit_amount_before_discount	item_tax_id	tax_amount	payment_item_id	payment_id	payment_type	payment_label	payment_class	payment_amount	payment_amount_collected	payment_hold_amount	payment_deposit	payment_charged_at	payment_status	time_zone	location_id	ticket_uuid	ticket_raw_status	ticket_status	ticket_closed_at	ticket_closed_at_date_in_tz	locations-qid	location_nickname	location_store_id	location_entity_id	location_street_address	location_street_address_2	location_zip_code	location_city	location_state	location_time_zone	location_resource_count	employees-qid	employee_name	ticket_client_id	ticket_client_name	ticket_client_email	import_date	import_timestamp
23994	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	edit	143134	43437682	2025-08-11 20:21:55	2025-08-11 00:00:00	2025-08-11 18:00:00	2025-08-11 00:00:00	2025-08-06 23:57:01	2025-08-06 00:00:00	NULL	NULL	132705820	97896260	Appointment	The Essentials (Non-Member)	SlotVariation	NULL	306655	Kwatrelle B.	22906830	chloe smart	9py2b2kcvs@privaterelay.appleid.com	(509) 591-1688	NULL	NULL	3102201	Cabo	Cockapoo	False	in_store	completed	45.0	65453588.0	62.0	4.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	265356.0	Service Category	Non-Members	Deal	False	False	NULL	NULL	NULL	NULL	NULL	106039715.0	65.0	65.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-04-16 18:02:30	158462	MYOHJIE2	1	closed	2025-08-11 20:21:55	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-04-16 18:02:30	NULL	qid306655	Kwatrelle B.	22906830	chloesmart	9py2b2kcvs@privaterelay.appleid.com	2026-04-16	2026-04-16 04:02:30
28515	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	edit	143134	43436716	2025-08-11 19:55:19	2025-08-11 00:00:00	2025-08-11 18:00:00	2025-08-11 00:00:00	2025-08-11 18:01:28	2025-08-11 00:00:00	NULL	NULL	132701742	98076100	Appointment	Hypoallergenic Treatment	SlotVariation	NULL	307595	Maddy W.	23645622	Laura Wesley	Jasonwesley@cox.net	(602) 793-0907	(602) 793-0906	NULL	3331998	Jaxson	Jack Russell Terrier	False	in_store	completed	1.0	65529404.0	16.0	2.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	263954.0	Service Category	Pamper + Protect	Deal	False	False	NULL	NULL	NULL	NULL	NULL	106036135.0	10.0	10.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-04-16 18:02:31	158462	CAINP8Z5	1	closed	2025-08-11 19:55:19	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-04-16 18:02:31	NULL	qid307595	Maddy W.	23645622	LauraWesley	Jasonwesley@cox.net	2026-04-16	2026-04-16 04:02:32
32569	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	edit	143134	43365361	2025-08-11 17:55:53	2025-08-11 00:00:00	2025-08-11 17:30:00	2025-08-11 00:00:00	2025-08-08 18:56:04	2025-08-08 00:00:00	NULL	NULL	132405013	97971814	Appointment	Plaque Reduction Treatment	SlotVariation	NULL	300465	Megan K.	23096008	Alison Collins	alison@collinsaz.com	(602) 743-4675	NULL	NULL	3129200	Riley	Boston Terrier	False	online	completed	0.0	65502418.0	35.0	4.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	263952.0	Service Category	Add-ons	Deal	False	False	NULL	NULL	NULL	NULL	NULL	106021749.0	12.0	15.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-04-16 18:02:33	158462	G38OS4CI	1	closed	2025-08-11 17:55:53	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-04-16 18:02:33	NULL	qid300465	Megan K.	23096008	AlisonCollins	alison@collinsaz.com	2026-04-16	2026-04-16 04:02:33
33723	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	edit	143134	43437682	2025-08-11 20:21:55	2025-08-11 00:00:00	2025-08-11 18:00:00	2025-08-11 00:00:00	2025-08-11 18:27:22	2025-08-11 00:00:00	NULL	NULL	132705821	98077846	Appointment	Haircut	SlotVariation	NULL	306655	Kwatrelle B.	22906830	chloe smart	9py2b2kcvs@privaterelay.appleid.com	(509) 591-1688	NULL	NULL	3102201	Cabo	Cockapoo	False	in_store	completed	45.0	65453588.0	62.0	4.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	263955.0	Service Category	Add Style or Comfort	Deal	False	False	NULL	NULL	NULL	NULL	NULL	106039716.0	60.0	60.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-04-16 18:02:33	158462	MYOHJIE2	1	closed	2025-08-11 20:21:55	2025-08-11 00:00:00	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-04-16 18:02:33	NULL	qid306655	Kwatrelle B.	22906830	chloesmart	9py2b2kcvs@privaterelay.appleid.com	2026-04-16	2026-04-16 04:02:33
41362	Sparkle Grooming Corp.	qid141656	Sparkle - 48002	qid143134	143134	service	143134	43208424	2025-08-02 16:00:51	2025-08-02 00:00:00	2025-08-11 21:15:00	2025-08-11 00:00:00	2025-08-02 16:00:42	2025-08-02 00:00:00	NULL	NULL	131819184	97691261	Appointment	Trim	SlotVariation	1	300465	Megan K.	23226568	Matthew Mansholt	mattmansholt@yahoo.com	(661) 208-6731	NULL	NULL	3193459	Azura	Mix Medium (Short Hair)	False	online	canceled_by_consumer	20.0	65317228.0	NULL	NULL	0.0	0.0	NULL	NULL	NULL	NULL	NULL	263952.0	Service Category	Add-ons	Deal	False	False	0.0	NULL	0.0	NULL	NULL	NULL	0.0	0.0	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	NULL	2026-04-16 18:02:36	158462	HLM7C4H6	2	void	NULL	NULL	qid158462	Scottsdale Shea	US48002	NULL	10392 N Scottsdale Rd	Suite 101	85254	Scottsdale	AZ	2026-04-16 18:02:36	NULL	qid300465	Megan K.	23226568	MatthewMansholt	mattmansholt@yahoo.com	2026-04-16	2026-04-16 04:02:36

3. Key Field Values

Unique values in 'appt_status':

completed: 178492 records
canceled_by_merchant: 16578 records
booked: 15931 records
canceled_by_consumer: 9144 records
confirmed: 1099 records
canceled_waiting: 345 records
no_show: 20 records
waiting: 16 records

Unique values in 'payment_type':

Card: 76062 records
Cash: 72760 records

Unique values in 'item_child_label':

Charlie: 3942 records
Lucy: 3716 records
Daisy: 3306 records
Luna: 3286 records
Stella: 2382 records
Lola: 2297 records
Bella: 1961 records
Winston: 1945 records
Teddy: 1849 records
Rocky: 1823 records

Unique values in 'client_membership_status':

Fatal error: Uncaught mysqli_sql_exception: Unknown column 'client_membership_status' in 'SELECT' in /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php:70 Stack trace: #0 /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php(70): mysqli_query(Object(mysqli), 'SELECT DISTINCT...') #1 {main} thrown in /home2/dataforsparkle/public_html/reports/explore-aggregated-table.php on line 70