Toast schema and ERD

44 tables

Loading diagram…

employee

guid

string

restaurant_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

guid

string

restaurant_guid

string

employee_guid

string

entity_type

string

external_id

string

_weld_synced

date

guid

string

restaurant_guid

string

entity_type

string

name

string

orderable_online

string

visibility

string

unit_of_measure

string

_weld_synced

date

menu_group

new_foreign_key

type

guid

string

entity_type

string

restaurant_guid

string

menu_guid

string

_weld_synced

date

menu_group

menu_group_item

guid

string

restaurant_guid

string

menu_group_guid

string

entity_type

string

_weld_synced

date

menu_group_option_group

guid

string

restaurant_guid

string

menu_group_guid

string

entity_type

string

_weld_synced

date

menu_item

guid

string

restaurant_guid

string

entity_type

string

name

string

sku

string

plu

string

calories

int

visibility

string

orderable_online

string

type

string

inherit_option_groups

boolean

inherit_unit_of_measure

boolean

unit_of_measure

string

_weld_synced

date

menu_item_option_group

guid

string

restaurant_guid

string

menu_item_guid

string

entity_type

string

_weld_synced

date

modifier_group

guid

string

restaurant_guid

string

entity_type

string

name

string

min_selections

double

max_selections

double

_weld_synced

date

modifier_group_option

guid

string

restaurant_guid

string

modifier_group_guid

string

entity_type

string

_weld_synced

date

name

string

order

guid

string

restaurant_guid

string

dining_option_guid

string

table_guid

string

service_area_guid

string

restaurant_service_guid

string

revenue_center_guid

string

server_guid

string

entity_type

string

external_id

string

opened_date

date

modified_date

date

promised_date

date

channel_guid

string

dining_option_entity_type

string

dining_option_external_id

string

order_check

guid

string

order_guid

string

restaurant_guid

string

opened_by_guid

string

entity_type

string

external_id

string

created_date

date

opened_date

date

closed_date

date

modified_date

date

deleted_date

date

deleted

boolean

order_check_selection

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

item_guid

string

void_reason_guid

string

dining_option_guid

string

item_group_guid

type

entity_type

string

external_id

string

item_entity_type

string

item_multi_location_id

string

item_external_id

string

item_group_entity_type

string

item_group_multi_location_id

string

item_group_external_id

string

order_check_selection_applied_tax

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

tax_rate_guid

type

order_check_selection_guid

string

entity_type

string

tax_rate_entity_type

string

name

string

rate

double

tax_amount

double

type

string

facilitator_collect_and_remit_tax

boolean

display_name

string

jurisdiction

string

jurisdiction_type

string

_weld_synced

date

order_check_selection_applied_discount

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

discount_guid

string

approver_guid

string

order_check_selection_guid

string

entity_type

string

external_id

string

name

string

discount_amount

double

non_tax_discount_amount

double

discount_entity_type

string

approver_entity_type

string

order_check_selection_modifier

guid

string

order_guid

string

order_check_guid

string

restaurant_guid

string

item_guid

string

item_group_guid

string

option_group_guid

string

void_reason_guid

string

dining_option_guid

string

order_check_selection_guid

string

entity_type

string

external_id

string

item_entity_type

string

item_multi_location_id

string

item_external_id

string

item_group_entity_type

string

item_group_multi_location_id

string

order_check_payment

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

server_guid

string

cash_drawer_guid

string

entity_type

string

external_id

string

paid_date

date

paid_business_date

double

created_by_client_name

string

type

string

card_entry_mode

string

amount

double

order_check_applied_discount

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

discount_guid

string

approver_guid

string

entity_type

string

external_id

string

name

string

discount_amount

double

non_tax_discount_amount

double

discount_entity_type

string

triggers

string

approver_entity_type

string

order_check_applied_service_charge

guid

string

order_guid

string

restaurant_guid

string

order_check_guid

string

service_charge_guid

string

payment_guid

string

entity_type

string

external_id

string

charge_amount

double

service_charge_entity_type

string

service_charge_external_id

string

charge_type

string

name

string

delivery

boolean

alternate_payment_type

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

break_type

guid

string

restaurant_guid

string

entity_type

string

name

string

active

boolean

paid

boolean

duration

int

enforce_minimum_time

boolean

track_missed_breaks

boolean

break_interval_hrs

double

break_interval_mins

double

track_break_acknowledgement

boolean

_weld_synced

date

cash_deposit

guid

string

restaurant_guid

string

employee_guid

type

creator_guid

type

entity_type

string

date

amount

double

employee_entity_type

string

employee_external_id

string

undoes

string

creator_entity_type

string

_weld_synced

date

cash_drawer

guid

string

restaurant_guid

string

entity_type

string

printer_guid

string

printer_entity_type

string

_weld_synced

date

cash_entry

guid

string

restaurant_guid

string

employee1_guid

string

employee2_guid

string

payout_reason_guid

string

no_sale_reason_guid

string

cash_drawer_guid

string

creator_or_shift_review_subject_guid

string

approver_or_shift_review_subject_guid

string

entity_type

string

amount

double

reason

string

type

string

date

undoes

string

employee1_entity_type

string

employee1_external_id

string

dining_option

guid

string

restaurant_guid

string

entity_type

string

name

string

behavior

string

curbside

boolean

_weld_synced

date

discount

guid

string

restaurant_guid

string

entity_type

string

name

string

amount

double

percentage

double

type

string

selection_type

string

active

boolean

non_exclusive

boolean

item_picking_priority

string

fixed_total

boolean

_weld_synced

date

inventory

guid

string

restaurant_guid

string

item_guid_validity

string

quantity

double

status

string

version_id

string

multi_location_id

string

_weld_synced

date

job

guid

string

restaurant_guid

string

entity_type

string

external_id

string

title

string

code

string

default_wage

double

tipped

boolean

exclude_from_reporting

boolean

deleted

boolean

created_date

date

modified_date

date

_weld_synced

date

no_sale_reason

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

payout_reason

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

price_group

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

printer

guid

string

restaurant_guid

string

entity_type

string

name

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

modified_date

date

iso_created_date

date

iso_modified_date

date

deleted

boolean

_weld_synced

date

restaurant_service

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

revenue_center

guid

string

restaurant_guid

string

entity_type

string

name

string

description

string

_weld_synced

date

sales_category

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date

service_area

guid

string

restaurant_guid

string

revenue_center_guid

string

entity_type

string

name

string

revenue_center_entity_type

string

revenue_center_external_id

string

_weld_synced

date

service_charge

guid

string

restaurant_guid

string

entity_type

string

name

string

amount

double

percent

double

amount_type

string

type

string

gratuity

boolean

service_charge_calculation

string

shift

guid

string

restaurant_guid

string

entity_type

string

external_id

string

name

string

in_date

date

out_date

date

deleted

boolean

job_reference_guid

string

job_reference_entity_type

string

table

guid

string

restaurant_guid

string

service_area_guid

string

entity_type

string

name

string

service_area_entity_type

string

revenue_center_guid

string

revenue_center_entity_type

string

_weld_synced

date

tax_rate

guid

string

restaurant_guid

string

entity_type

string

name

string

rate

double

type

string

rounding_type

string

is_default

boolean

tax_table

string

_weld_synced

date

time_entry

guid

string

restaurant_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

job_reference_external_id

string

tip_withholding

guid

string

restaurant_guid

string

entity_type

string

name

string

percent

double

_weld_synced

date

void_reason

guid

string

restaurant_guid

string

entity_type

string

name

string

_weld_synced

date