Toast schema and ERD

67 tables

Loading diagram…

discount

employee

modifier_group

order

prep_station

service_charge

tax_rate

alternate_payment_type

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

break_type

guid

string

entity_type

string

name

string

restaurant_guid

string

active

boolean

paid

boolean

duration

int

enforce_minimum_time

boolean

cash_deposit

guid

string

entity_type

string

date

amount

double

employee_guid

string

employee_entity_type

string

employee_external_id

string

undoes

string

creator_guid

string

creator_entity_type

string

restaurant_guid

string

_weld_synced

date

cash_drawer

guid

string

entity_type

string

restaurant_guid

string

printer_guid

string

printer_entity_type

string

_weld_synced

date

cash_entry

guid

string

restaurant_guid

string

entity_type

string

amount

double

reason

string

type

string

date

undoes

string

dining_option

guid

string

entity_type

string

name

string

restaurant_guid

string

behavior

string

curbside

boolean

_weld_synced

date

discount

guid

string

entity_type

string

name

string

restaurant_guid

string

amount

double

percentage

double

type

string

selection_type

string

discount_promo_code

guid

string

entity_type

string

name

string

restaurant_guid

string

usage_type

string

discount_guid

string

_weld_synced

date

employee

guid

string

entity_type

string

external_id

string

external_employee_id

string

v2_employee_guid

string

first_name

string

last_name

string

chosen_name

string

employee_job_reference

employee_guid

string

restaurant_guid

string

guid

string

entity_type

string

external_id

string

_weld_synced

date

inventory

guid

string

item_guid_validity

string

quantity

double

status

string

version_id

string

multi_location_id

string

restaurant_guid

string

_weld_synced

date

item_fulfillment

selection_guid

string

ticket_guid

string

restaurant_guid

string

prep_station_guid

string

item_fulfilled_at

date

item_fulfillment_level

long

order_guid

string

selection_menu_item_guid

string

job

guid

string

entity_type

string

external_id

string

title

string

code

string

default_wage

double

tipped

boolean

exclude_from_reporting

boolean

guid

string

restaurant_guid

string

name

string

pos_name

string

multi_location_id

string

master_id

string

description

string

high_res_image

string

menu_visibility

menu_guid

string

restaurant_guid

string

visibility

string

_weld_synced

date

menu_group

guid

string

menu_guid

string

restaurant_guid

string

parent_menu_group_guid

string

name

string

pos_name

string

multi_location_id

string

master_id

string

menu_group_visibility

menu_guid

string

menu_group_guid

string

restaurant_guid

string

visibility

string

_weld_synced

date

menu_item

guid

string

menu_guid

string

restaurant_guid

string

menu_group_guid

string

name

string

pos_name

string

multi_location_id

string

master_id

string

menu_item_visibility

menu_guid

string

menu_group_guid

string

menu_item_guid

string

restaurant_guid

string

visibility

string

_weld_synced

date

menu_item_tax_rate

tax_rate_id

string

menu_guid

string

menu_group_guid

string

menu_item_guid

string

restaurant_guid

string

_weld_synced

date

menu_item_prep_station

prep_station_id

string

menu_guid

string

menu_group_guid

string

menu_item_guid

string

restaurant_guid

string

_weld_synced

date

menu_item_modifier_group_reference

menu_guid

string

menu_group_guid

string

menu_item_guid

string

restaurant_guid

string

modifier_group_reference

string

_weld_synced

date

menu_item_pricing_rule

menu_guid

string

restaurant_guid

string

menu_group_guid

string

menu_item_guid

string

time_specific_price

double

base_price

double

_weld_synced

date

menu_item_pricing_rule_schedule

menu_guid

string

restaurant_guid

string

menu_group_guid

string

menu_item_guid

string

days

string

_weld_synced

date

menu_item_pricing_rule_schedule_time_range

menu_guid

string

restaurant_guid

string

menu_group_guid

string

menu_item_guid

string

start

string

end

string

_weld_synced

date

menu_modifier_group

guid

string

restaurant_guid

string

reference_id

string

name

string

pos_name

string

multi_location_id

string

master_id

string

pricing_strategy

string

menu_modifier_group_visibility

menu_modifier_group_guid

string

menu_modifier_group_reference_id

string

restaurant_guid

string

visibility

string

_weld_synced

date

menu_modifier_group_option

menu_modifier_group_guid

string

restaurant_guid

string

menu_modifier_group_reference_id

string

modifier_option_reference

string

_weld_synced

date

menu_modifier_option

guid

string

restaurant_guid

string

reference_id

string

name

string

pos_name

string

multi_location_id

string

master_id

string

description

string

menu_modifier_option_visibility

menu_modifier_option_guid

string

menu_modifier_option_reference_id

string

restaurant_guid

string

visibility

string

_weld_synced

date

menu_modifier_option_tax_rate

menu_modifier_option_guid

string

menu_modifier_option_reference_id

string

restaurant_guid

string

tax_rate_guid

string

_weld_synced

date

menu_modifier_option_prep_station

prep_station_id

string

menu_modifier_option_guid

string

menu_modifier_option_reference_id

string

restaurant_guid

string

_weld_synced

date

modifier_group

guid

string

entity_type

string

name

string

restaurant_guid

string

min_selections

double

max_selections

double

_weld_synced

date

modifier_group_option

guid

string

entity_type

string

restaurant_guid

string

modifier_group_guid

string

_weld_synced

date

no_sale_reason

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

order

guid

string

entity_type

string

external_id

string

opened_date

date

modified_date

date

promised_date

date

channel_guid

string

dining_option_guid

string

order_marketplace_facilitator_tax

guid

string

order_guid

string

restaurant_guid

string

entity_type

string

tax_rate_guid

string

tax_rate_entity_type

string

name

string

rate

double

order_applied_packaging_item

guid

string

order_guid

string

restaurant_guid

string

entity_type

string

item_config_id

string

inclusion

string

item_types

string

guest_display_name

string

_weld_synced

date

order_check

guid

string

order_guid

string

restaurant_guid

string

entity_type

string

external_id

string

created_date

date

opened_date

date

closed_date

date

order_check_selection

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

entity_type

string

external_id

string

item_guid

string

item_entity_type

string

order_check_selection_applied_tax

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

order_check_selection_guid

string

entity_type

string

tax_rate_guid

string

tax_rate_entity_type

string

order_check_selection_applied_discount

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

order_check_selection_guid

string

entity_type

string

external_id

string

name

string

order_check_selection_modifier

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

order_check_selection_guid

string

entity_type

string

external_id

string

item_guid

string

order_check_payment

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

entity_type

string

external_id

string

paid_date

date

paid_business_date

double

order_check_applied_discount

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

entity_type

string

external_id

string

name

string

discount_amount

double

order_check_applied_service_charge

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

entity_type

string

external_id

string

charge_amount

double

service_charge_guid

string

order_check_applied_service_charge_applied_tax

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

order_check_applied_service_charge_guid

string

entity_type

string

tax_rate_guid

string

tax_rate_entity_type

string

payout_reason

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

prep_station

guid

string

entity_type

string

name

string

printing_mode

string

include_with_expediter

boolean

expo_routing

string

kitchen_printer_guid

string

kitchen_printer_entity_type

string

restaurant_guid

string

_weld_synced

date

prep_station_connected_prep_station

guid

string

entity_type

string

prep_station_guid

string

restaurant_guid

string

_weld_synced

date

price_group

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

printer

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

restaurant_service

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

restaurant

restaurant_guid

string

restaurant_name

string

location_name

string

management_group_guid

string

external_group_ref

string

external_restaurant_ref

string

created_by_email_address

string

created_date

date

revenue_center

guid

string

entity_type

string

name

string

restaurant_guid

string

description

string

_weld_synced

date

sales_category

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date

service_area

guid

string

entity_type

string

name

string

restaurant_guid

string

revenue_center_guid

string

revenue_center_entity_type

string

revenue_center_external_id

string

_weld_synced

date

service_charge

guid

string

entity_type

string

name

string

restaurant_guid

string

amount

double

percent

double

amount_type

string

type

string

service_charge_applicable_tax

guid

string

entity_type

string

name

string

restaurant_guid

string

service_charge_guid

string

is_default

boolean

rate

double

type

string

rounding_type

string

tax_table

string

_weld_synced

date

service_charge_applicable_tax_conditional_tax_rate

service_charge_guid

string

restaurant_guid

string

applicable_tax_guid

string

condition

string

rate

double

_weld_synced

date

shift

guid

string

entity_type

string

external_id

string

name

string

in_date

date

out_date

date

deleted

boolean

job_reference_guid

string

table

guid

string

entity_type

string

name

string

restaurant_guid

string

service_area_guid

string

service_area_entity_type

string

revenue_center_guid

string

revenue_center_entity_type

string

_weld_synced

date

tax_rate

guid

string

entity_type

string

name

string

restaurant_guid

string

rate

double

type

string

rounding_type

string

is_default

boolean

tax_table

string

_weld_synced

date

tax_rate_conditional_tax_rate

tax_rate_guid

string

restaurant_guid

string

condition

string

rate

double

_weld_synced

date

time_entry

guid

string

entity_type

string

external_id

string

employee_reference_guid

string

employee_reference_entity_type

string

employee_reference_external_id

string

job_reference_guid

string

job_reference_entity_type

string

tip_withholding

guid

string

entity_type

string

name

string

restaurant_guid

string

percent

double

_weld_synced

date

void_reason

guid

string

entity_type

string

name

string

restaurant_guid

string

_weld_synced

date