Toast Analytics schema

13 tables

About the connector Start free

13 tables

Joins between these tables aren't mapped yet.

Loading diagram…

analytics_aggregated_sales

23

restaurant_guid

string

business_date

string

guest_count

int

void_orders_count

int

discount_order_count

int

orders_count

int

open_orders_count

int

closed_orders_count

int

analytics_check

21

restaurant_guid

string

check_guid

string

order_number

string

order_guid

string

check_number

string

order_opened_date

string

check_paid_date_time

date

check_modified_date_time

date

analytics_guest_by_payment

9

restaurant_guid

string

payment_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

payment_date

string

order_guid

string

card_fingerprint

string

_weld_synced

date

analytics_labor

18

business_date

string

restaurant_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

regular_hours

double

overtime_hours

double

total_hours

double

analytics_labor_by_employee

18

business_date

string

restaurant_guid

string

employee_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

regular_hours

double

overtime_hours

double

analytics_labor_by_job

17

business_date

string

restaurant_guid

string

job_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

regular_hours

double

overtime_hours

double

analytics_menu

23

restaurant_guid

string

business_date

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

net_sales_amount

double

gross_sales_amount

double

discount_amount

double

analytics_menu_by_menu

17

restaurant_guid

string

business_date

string

menu_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

net_sales_amount

double

gross_sales_amount

double

analytics_menu_by_menu_item

17

restaurant_guid

string

business_date

string

menu_item_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

net_sales_amount

double

gross_sales_amount

double

analytics_payout_by_payments

17

restaurant_guid

string

payment_guid

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

order_guid

string

check_guid

string

settled_date

string

analytics_payout_by_sales_date

13

restaurant_guid

string

sales_date

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

settled_dates

string

transaction_count

int

payment_amount

double

analytics_payout_by_settled_date

15

restaurant_guid

string

settled_date

string

restaurant_name

string

restaurant_location_name

string

restaurant_location_code

string

sales_period_start_date_time

date

sales_period_end_date_time

date

transaction_count

int

analytics_restaurants_information

6

restaurant_guid

string

restaurant_name

string

active

boolean

test_mode

boolean

archived

boolean

_weld_synced

date