Tables
ERD
13 tables
Expand all
Collapse all
analytics_aggregated_sales
23 columns
analytics_check
21 columns
analytics_guest_by_payment
9 columns
analytics_labor
18 columns
analytics_labor_by_employee
18 columns
analytics_labor_by_job
17 columns
analytics_menu
23 columns
analytics_menu_by_menu
17 columns
analytics_menu_by_menu_item
17 columns
analytics_payout_by_payments
17 columns
analytics_payout_by_sales_date
13 columns
analytics_payout_by_settled_date
15 columns
analytics_restaurants_information
6 columns
Loading diagram…
analytics_aggregated_sales
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
net_sales_amount
double
gross_sales_amount
double
discount_amount
double
void_orders_amount
double
refund_amount
double
avg_order_value
double
revenue_center
string
dining_option
string
order_source
string
business_hour
string
hourly_job_total_hours
double
hourly_job_total_pay
double
hourly_job_sales_per_labor_hour
double
restaurant_name
string
_weld_synced
date
analytics_check
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
check_status
string
check_voided_status
boolean
dining_option
string
revenue_center
string
server_name
string
check_total_amount
double
check_discount_amount
double
check_tax_amount
double
check_tip_amount
double
check_gratuity_amount
double
check_refund_amount
double
restaurant_name
string
_weld_synced
date
analytics_guest_by_payment
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
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
regular_cost
double
overtime_cost
double
total_cost
double
net_sales_amount
double
gross_sales_amount
double
net_sales_per_employee_hour
double
gross_sales_per_employee_hour
double
total_cost_per_net_sales
double
total_cost_per_gross_sales
double
_weld_synced
date
analytics_labor_by_employee
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
total_hours
double
regular_cost
double
overtime_cost
double
total_cost
double
total_cost_per_net_sales
double
total_cost_per_gross_sales
double
employee_first_name
string
employee_last_name
string
employee_chosen_name
string
_weld_synced
date
analytics_labor_by_job
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
total_hours
double
regular_cost
double
overtime_cost
double
total_cost
double
total_cost_per_net_sales
double
total_cost_per_gross_sales
double
job_title
string
job_code
string
_weld_synced
date
analytics_menu
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
refund_amount
double
void_amount
double
quantity_sold
double
average_price
double
waste_count
double
waste_amount
double
menu_guid
string
menu_name
string
menu_group_guid
string
menu_group_name
string
menu_item_guid
string
menu_item_name
string
modifier_guid
string
modifier_name
string
_weld_synced
date
analytics_menu_by_menu
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
discount_amount
double
refund_amount
double
void_amount
double
quantity_sold
double
average_price
double
waste_count
double
waste_amount
double
menu_name
string
_weld_synced
date
analytics_menu_by_menu_item
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
discount_amount
double
refund_amount
double
void_amount
double
quantity_sold
double
average_price
double
waste_count
double
waste_amount
double
menu_item_name
string
_weld_synced
date
analytics_payout_by_payments
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
order_open_date_time
date
paid_date_time
date
payment_card_brand
string
payment_card_type
string
tip_amount
double
gratuity_amount
double
payment_subtotal
double
payment_total
double
_weld_synced
date
analytics_payout_by_sales_date
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
refund_amount
double
total_fee_amount
double
withholding_amount
double
payout_amount
double
_weld_synced
date
analytics_payout_by_settled_date
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
payment_amount
double
refund_amount
double
total_fee_amount
double
withholding_amount
double
payout_amount
double
payout_status
string
_weld_synced
date
analytics_restaurants_information
restaurant_guid
string
restaurant_name
string
active
boolean
test_mode
boolean
archived
boolean
_weld_synced
date
Table
Sub table
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.