| Field | Type | Null | Key | Default | Extra |
|---|
| sparkle_id | bigint | NO | PRI | | auto_increment |
| parent_companies-name | varchar(64) | YES | | | |
| parent_companies-qid | varchar(64) | YES | | | |
| companies-child_company_name | varchar(64) | YES | | | |
| companies-qid | varchar(64) | YES | | | |
| companies-id | bigint | YES | | | |
| type | varchar(64) | YES | | | |
| item_company_id | double | YES | | | |
| ticket_id | text | YES | | | |
| action_at | text | YES | | | |
| action_at_date_in_tz | text | 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 | text | YES | | | |
| item_id | text | YES | | | |
| item_type | varchar(64) | YES | | | |
| item_label | text | YES | | | |
| item_class | text | YES | | | |
| item_quantity | double | YES | | | |
| item_employee_id | text | YES | | | |
| item_employee_name | text | YES | | | |
| item_client_id | double | YES | | | |
| item_client_name | varchar(102) | YES | | | |
| item_client_email | varchar(90) | YES | | | |
| item_client_mobile_phone | varchar(64) | YES | | | |
| item_client_home_phone | varchar(64) | YES | | | |
| item_client_work_phone | varchar(64) | YES | | | |
| item_child_id | text | YES | | | |
| item_child_label | text | YES | | | |
| item_child_secondary_label | text | YES | | | |
| item_child_is_deceased | text | YES | | | |
| source | text | 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 | | | |
| product_cost_amount | text | YES | | | |
| sub_item_id | text | YES | | | |
| sub_item_type | varchar(64) | YES | | | |
| sub_item_label | text | YES | | | |
| sub_item_class | text | YES | | | |
| category_id | text | YES | | | |
| category_type | text | YES | | | |
| category_label | text | YES | | | |
| category_class | text | YES | | | |
| in_membership | varchar(64) | YES | | | |
| in_package | varchar(64) | 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 | 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 | text | YES | | | |
| ticket_raw_status | text | YES | | | |
| ticket_status | text | YES | | | |
| ticket_closed_at | text | YES | | | |
| ticket_closed_at_date_in_tz | text | YES | | | |
| locations-qid | varchar(64) | YES | | | |
| location_nickname | varchar(64) | YES | | | |
| location_store_id | varchar(64) | YES | | | |
| location_entity_id | text | YES | | | |
| location_street_address | varchar(64) | YES | | | |
| location_street_address_2 | varchar(64) | YES | | | |
| location_zip_code | bigint | YES | | | |
| location_city | varchar(64) | YES | | | |
| location_state | varchar(64) | YES | | | |
| location_time_zone | datetime | YES | | | |
| location_resource_count | text | YES | | | |
| employees-qid | text | YES | | | |
| employee_name | varchar(64) | YES | | | |
| ticket_client_id | text | YES | | | |
| ticket_client_walk_in | text | YES | | | |
| ticket_client_name | text | YES | | | |
| ticket_client_email | text | YES | | | |
| client_visit_rank | text | YES | | | |
| is_member | text | YES | | | |
| owner_company_id | double | YES | | | |
| import_date | date | NO | MUL | | |
| import_timestamp | timestamp | YES | MUL | CURRENT_TIMESTAMP | DEFAULT_GENERATED |