| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| sparkle_id | bigint | 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 | YES | |||
| type | varchar(18) | YES | |||
| item_company_id | bigint | 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(76) | YES | |||
| item_class | varchar(28) | YES | |||
| item_quantity | double | YES | |||
| item_employee_id | double | YES | |||
| item_employee_name | varchar(16) | YES | |||
| item_client_id | double | YES | |||
| item_client_name | varchar(40) | 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(24) | YES | |||
| item_child_secondary_label | varchar(58) | 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 | double | YES | |||
| item_amount_before_discount | double | YES | |||
| discount_amount | text | YES | |||
| product_cost_amount | text | YES | |||
| sub_item_id | double | YES | |||
| sub_item_type | varchar(28) | YES | |||
| sub_item_label | varchar(28) | 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(10) | YES | |||
| in_package | varchar(10) | YES | |||
| usage_amount | text | YES | |||
| usage_original_amount | text | YES | |||
| gift_cards_prepaid_amount | double | YES | |||
| memberships_prepaid_amount | text | YES | |||
| packages_prepaid_amount | text | YES | |||
| gift_cards_prepaid_amount_v2 | text | YES | |||
| item_return_id | text | YES | |||
| refund_amount | text | YES | |||
| item_edit_id | double | YES | |||
| edit_amount | double | YES | |||
| edit_amount_before_discount | double | 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 | 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(38) | YES | |||
| ticket_client_email | varchar(70) | YES | |||
| client_visit_rank | double | YES | |||
| is_member | varchar(10) | YES | |||
| import_date | date | NO | MUL | ||
| import_timestamp | timestamp | YES | MUL | CURRENT_TIMESTAMP | DEFAULT_GENERATED |
| 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 | product_cost_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 | memberships_prepaid_amount | packages_prepaid_amount | gift_cards_prepaid_amount_v2 | 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_walk_in | ticket_client_name | ticket_client_email | client_visit_rank | is_member | import_date | import_timestamp |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17262 | Sparkle Grooming Corp. | qid141656 | Sparkle - 48002 | qid143134 | 143134 | edit | 143134 | 43443689 | 2025-08-11 23:17:30 | 2025-08-11 00:00:00 | 2025-08-11 22:00:00 | 2025-08-11 00:00:00 | 2025-08-04 17:03:57 | 2025-08-04 00:00:00 | NULL | NULL | 132731401 | 97781425 | Appointment | Pro-Keratin Leave-in Conditioner | SlotVariation | NULL | 300614 | Mari V. | 21875621 | Festina Guri | Festinasopa@hotmail.com | (623) 500-1164 | NULL | NULL | 3062690 | Remi | Peekapoo | False | in_store | completed | 1.0 | 65377495.0 | 7.0 | 25.0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 263954.0 | Service Category | Pamper + Protect | Deal | False | False | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 106061959 | 10.5 | 15 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-08-09 18:03:50 | 158462 | OSOS5NG0 | 1 | closed | 2025-08-11 23:17:30 | 2025-08-11 00:00:00 | qid158462 | Scottsdale Shea | US48002 | NULL | 10392 N Scottsdale Rd | Suite 101 | 85254 | Scottsdale | AZ | 2026-08-09 18:03:50 | NULL | qid300614 | Mari V. | 21875621 | 0 | FestinaGuri | Festinasopa@hotmail.com | 27 | True | 2026-08-09 | 2026-08-09 11:03:50 |
| 33584 | Sparkle Grooming Corp. | qid141656 | Sparkle - 48002 | qid143134 | 143134 | service | 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 | 1 | 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 | 12 | 15 | NULL | NULL | NULL | NULL | NULL | NULL | 263952.0 | Service Category | Add-ons | Deal | False | False | 0.0 | 0.0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | -12 | -15 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-08-09 18:03:58 | 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-08-09 18:03:58 | NULL | qid300465 | Megan K. | 23096008 | 0 | AlisonCollins | alison@collinsaz.com | 4 | True | 2026-08-09 | 2026-08-09 11:03:59 |
| 36578 | Sparkle Grooming Corp. | qid141656 | Sparkle - 48002 | qid143134 | 143134 | service | 143134 | 43439145 | 2025-08-11 21:02:37 | 2025-08-11 00:00:00 | 2025-08-11 18:30:00 | 2025-08-11 00:00:00 | 2025-05-11 20:30:41 | 2025-05-11 00:00:00 | NULL | NULL | 132711984 | 93829537 | Appointment | Unlimited | SlotVariation | 1 | 300465 | Megan K. | 21704080 | Hamid Shojaee | Hamid@shojaee.com | (602) 295-5216 | NULL | NULL | 3008697 | Biscuit | Goldendoodle | False | in_store | completed | 60.0 | 62659531.0 | 0.0 | 13.0 | 115 | 115 | NULL | NULL | NULL | NULL | NULL | NULL | 263953.0 | Service Category | Members | Deal | True | False | 115.0 | 0.0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | -115 | -115 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-08-09 18:04:00 | 158462 | ASZVKLH7 | 1 | closed | 2025-08-11 21:02:37 | 2025-08-11 00:00:00 | qid158462 | Scottsdale Shea | US48002 | NULL | 10392 N Scottsdale Rd | Suite 101 | 85254 | Scottsdale | AZ | 2026-08-09 18:04:00 | NULL | qid300614 | Mari V. | 21704080 | 0 | HamidShojaee | Hamid@shojaee.com | 13 | True | 2026-08-09 | 2026-08-09 11:04:00 |
| 38593 | Sparkle Grooming Corp. | qid141656 | Sparkle - 48002 | qid143134 | 143134 | service | 143134 | 43377342 | 2025-08-12 00:00:28 | 2025-08-11 00:00:00 | 2025-08-11 21:45:00 | 2025-08-11 00:00:00 | 2025-08-09 01:16:22 | 2025-08-08 00:00:00 | NULL | NULL | 132463027 | 97988414 | Appointment | Unlimited | SlotVariation | 1 | 300465 | Megan K. | 23102490 | Quinn Heimann | quinnkduane@gmail.com | (916) 208-6926 | (480) 213-6212 | NULL | 3130462 | Cash | Bernedoodle | False | online | completed | 70.0 | 65513105.0 | 27.0 | 5.0 | 115 | 115 | NULL | NULL | NULL | NULL | NULL | NULL | 263953.0 | Service Category | Members | Deal | True | False | 115.0 | 115.0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | -115 | -115 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-08-09 18:04:01 | 158462 | POGQ6EPF | 1 | closed | 2025-08-12 00:00:28 | 2025-08-11 00:00:00 | qid158462 | Scottsdale Shea | US48002 | NULL | 10392 N Scottsdale Rd | Suite 101 | 85254 | Scottsdale | AZ | 2026-08-09 18:04:01 | NULL | qid300465 | Megan K. | 23102490 | 0 | QuinnHeimann | quinnkduane@gmail.com | 7 | True | 2026-08-09 | 2026-08-09 11:04:01 |
| 97704 | Sparkle Grooming Corp. | qid141656 | Sparkle - 48002 | qid143134 | 143134 | discount | 143134 | 43443689 | 2025-08-11 23:17:30 | 2025-08-11 00:00:00 | 2025-08-11 22:00:00 | 2025-08-11 00:00:00 | 2025-08-04 17:03:57 | 2025-08-04 00:00:00 | NULL | NULL | 132731400 | 97781424 | Appointment | True Color Brightening Treatment | SlotVariation | NULL | 300614 | Mari V. | 21875621 | Festina Guri | Festinasopa@hotmail.com | (623) 500-1164 | NULL | NULL | 3062690 | Remi | Peekapoo | False | in_store | completed | 1.0 | 65377495.0 | 7.0 | 25.0 | NULL | NULL | -3.0 | NULL | 9345096 | PosAppliedDiscount | Discount | NULL | 263954.0 | Service Category | Pamper + Protect | Deal | False | False | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2026-08-09 18:04:36 | 158462 | OSOS5NG0 | 1 | closed | 2025-08-11 23:17:30 | 2025-08-11 00:00:00 | qid158462 | Scottsdale Shea | US48002 | NULL | 10392 N Scottsdale Rd | Suite 101 | 85254 | Scottsdale | AZ | 2026-08-09 18:04:36 | NULL | qid300614 | Mari V. | 21875621 | 0 | FestinaGuri | Festinasopa@hotmail.com | 27 | True | 2026-08-09 | 2026-08-09 11:04:37 |