Toast

Explore the interactive ERD

Table & Field Reference

payment

Column	Type	Keys
`id`	Unknown	PK
`amount`	Unknown
`amount_tendered`	Unknown
`authorized_amount`	Unknown
`card_entry_mode`	Unknown
`card_holder_first_name`	Unknown
`card_holder_last_name`	Unknown
`card_processor_type`	Unknown
`card_tender_type`	Unknown
`card_type`	Unknown
`cash_drawer_entity_type`	Unknown
`cash_drawer_external_id`	Unknown
`cash_drawer_guid`	Unknown
`check_guid`	Unknown
`created_device_id`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`gift_card_auth_request_id`	Unknown
`gift_card_authorization_state`	Unknown
`gift_card_card_number_identifier`	Unknown
`gift_card_entity_type`	Unknown
`gift_card_guid`	Unknown
`gift_card_rewards_balance`	Unknown
`gift_card_stored_value_balance`	Unknown
`house_account_entity_type`	Unknown
`house_account_external_id`	Unknown
`house_account_guid`	Unknown
`is_processed_offline`	Unknown
`last_modified_device_id`	Unknown
`mca_repayment_amount`	Unknown
`order_id`	Unknown
`order_owner_guid`	Unknown
`original_processing_fee`	Unknown
`other_payment_entity_type`	Unknown
`other_payment_external_id`	Unknown
`other_payment_guid`	Unknown
`paid_business_date`	Unknown
`paid_date`	Unknown
`payment_card_token_entity_type`	Unknown
`payment_card_token_guid`	Unknown
`payment_method_id`	Unknown
`payment_status`	Unknown
`prepaid_card_balance`	Unknown
`pro_rated_discount_amount`	Unknown
`pro_rated_tax_amount`	Unknown
`pro_rated_total_service_charge_amount`	Unknown
`processing_service`	Unknown
`receipt_token`	Unknown
`reference_code`	Unknown
`refund_amount`	Unknown
`refund_business_date`	Unknown
`refund_date`	Unknown
`refund_status`	Unknown
`refund_strategy`	Unknown
`refund_tip_amount`	Unknown
`refund_transaction_entity_type`	Unknown
`refund_transaction_guid`	Unknown
`restaurant_id`	Unknown
`server_entity_type`	Unknown
`server_external_id`	Unknown
`server_guid`	Unknown
`server_shift_entity_type`	Unknown
`server_shift_external_id`	Unknown
`server_shift_guid`	Unknown
`shift_entity_type`	Unknown
`shift_external_id`	Unknown
`shift_guid`	Unknown
`tender_room_id`	Unknown
`tip_amount`	Unknown
`type`	Unknown
`void_info_approver_guid`	Unknown
`void_info_business_date`	Unknown
`void_info_date`	Unknown
`void_info_reason_entity_type`	Unknown
`void_info_reason_external_id`	Unknown
`void_info_reason_guid`	Unknown
`void_info_user_guid`	Unknown

dining_option

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`behavior`	Unknown
`curbside`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`name`	Unknown

shift

Column	Type	Keys
`id`	Unknown	PK
`employee_reference_id`	Unknown	FK
`job_reference_id`	Unknown	FK
`restaurant_id`	Unknown	FK
`created_date`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`in_date`	Unknown
`modified_date`	Unknown
`out_date`	Unknown
`schedule_config_id`	Unknown
`schedule_config_min_after_clock_in`	Unknown
`schedule_config_min_after_clock_out`	Unknown
`schedule_config_min_before_clock_in`	Unknown
`schedule_config_min_before_clock_out`	Unknown

cash_deposit

Column	Type	Keys
`id`	Unknown	PK
`creator_guid`	Unknown	FK
`employee_guid`	Unknown	FK
`restaurant_id`	Unknown	FK
`amount`	Unknown
`creator_entity_type`	Unknown
`date`	Unknown
`employee_entity_type`	Unknown
`employee_external_id`	Unknown
`entity_type`	Unknown
`undoes`	Unknown

break

Column	Type	Keys
`id`	Unknown	PK
`time_entry_id`	Unknown	PKFK
`audit_response`	Unknown
`break_type_entity_type`	Unknown
`break_type_id`	Unknown
`missed`	Unknown

time_entry

Column	Type	Keys
`id`	Unknown	PK
`employee_reference_id`	Unknown	FK
`job_reference_id`	Unknown	FK
`restaurant_id`	Unknown	FK
`auto_clocked_out`	Unknown
`business_date`	Unknown
`cash_gratuity_service_charges`	Unknown
`cash_sales`	Unknown
`created_date`	Unknown
`declared_cash_tips`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`hourly_wage`	Unknown
`in_date`	Unknown
`modified_date`	Unknown
`non_cash_gratuity_service_charges`	Unknown
`non_cash_sales`	Unknown
`non_cash_tips`	Unknown
`out_date`	Unknown
`overtime_hours`	Unknown
`regular_hours`	Unknown
`shift_reference_id`	Unknown
`tips_withheld`	Unknown

revenue_center

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`description`	Unknown
`entity_type`	Unknown
`name`	Unknown

orders_applied_packing_item_type

Column	Type	Keys
`index`	Unknown	PK
`orders_applied_packing_item_id`	Unknown	PKFK
`orders_id`	Unknown	PKFK
`item_type`	Unknown

orders_applied_packing_item

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	PKFK
`entity_type`	Unknown
`guest_display_name`	Unknown
`inclusion`	Unknown
`item_config_id`	Unknown

orders_check_applied_discount_combo_item

Column	Type	Keys
`id`	Unknown	PK
`orders_applied_discount_id`	Unknown	FK
`entity_type`	Unknown
`external_id`	Unknown

orders_check_applied_discount_trigger

Column	Type	Keys
`index`	Unknown	PK
`orders_check_applied_discount_id`	Unknown	PKFK
`quantity`	Unknown
`selection_entity_type`	Unknown
`selection_external_id`	Unknown
`selection_guid`	Unknown

orders_check_applied_discount

Column	Type	Keys
`id`	Unknown	PK
`discount_guid`	Unknown	FK
`orders_check_id`	Unknown	FK
`applied_discount_reason_comment`	Unknown
`applied_discount_reason_description`	Unknown
`applied_discount_reason_discount_reason_entity_type`	Unknown
`applied_discount_reason_discount_reason_guid`	Unknown
`applied_discount_reason_name`	Unknown
`applied_promo_code`	Unknown
`approver_entity_type`	Unknown
`approver_external_id`	Unknown
`approver_guid`	Unknown
`discount_amount`	Unknown
`discount_entity_type`	Unknown
`discount_percent`	Unknown
`discount_type`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`loyalty_details_reference_id`	Unknown
`loyalty_details_vendor`	Unknown
`name`	Unknown
`non_tax_discount_amount`	Unknown
`processing_state`	Unknown

orders_check_applied_service_charge_applied_tax

Column	Type	Keys
`id`	Unknown	PK
`orders_check_applied_service_charge_id`	Unknown	FK
`entity_type`	Unknown
`facilitator_collect_and_remit_tax`	Unknown
`name`	Unknown
`rate`	Unknown
`tax_amount`	Unknown
`tax_rate_entity_type`	Unknown
`tax_rate_guid`	Unknown
`type`	Unknown

orders_check_applied_service_charge

Column	Type	Keys
`id`	Unknown	PK
`orders_check_id`	Unknown	PKFK
`charge_amount`	Unknown
`charge_type`	Unknown
`delivery`	Unknown
`destination`	Unknown
`dine_in`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`gratuity`	Unknown
`name`	Unknown
`payment_guid`	Unknown
`percents`	Unknown
`refund_amount`	Unknown
`refund_transaction_entity_type`	Unknown
`refund_transaction_guid`	Unknown
`service_charge_calculation`	Unknown
`service_charge_category`	Unknown
`service_charge_entity_type`	Unknown
`service_charge_external_id`	Unknown
`service_charge_guid`	Unknown
`tags`	Json
`takeout`	Unknown
`tax_refund_amount`	Unknown
`taxable`	Unknown

orders_check_payment

Column	Type	Keys
`orders_check_id`	Unknown	PKFK
`payment_id`	Unknown	PKFK
`order_guid`	Unknown	FK

orders_check_selection_applied_discount_combo_item

Column	Type	Keys
`id`	Unknown	PK
`orders_applied_discount_id`	Unknown	FK
`entity_type`	Unknown
`external_id`	Unknown

orders_check_selection_applied_discount_trigger

Column	Type	Keys
`_fivetran_id`	String	PK
`orders_check_selection_applied_discount_id`	Unknown	FK
`quantity`	Unknown
`selection_entity_type`	Unknown
`selection_external_id`	Unknown
`selection_guid`	Unknown

orders_check_selection_applied_discount

Column	Type	Keys
`id`	Unknown	PK
`discount_guid`	Unknown	FK
`orders_check_selection_id`	Unknown	FK
`applied_discount_reason_comment`	Unknown
`applied_discount_reason_description`	Unknown
`applied_discount_reason_discount_reason_entity_type`	Unknown
`applied_discount_reason_discount_reason_guid`	Unknown
`applied_discount_reason_name`	Unknown
`applied_promo_code`	Unknown
`approver_entity_type`	Unknown
`approver_external_id`	Unknown
`approver_guid`	Unknown
`discount_amount`	Unknown
`discount_entity_type`	Unknown
`discount_percent`	Unknown
`discount_type`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`loyalty_details_reference_id`	Unknown
`loyalty_details_vendor`	Unknown
`name`	Unknown
`non_tax_discount_amount`	Unknown
`processing_state`	Unknown

orders_check_selection_applied_tax

Column	Type	Keys
`index`	Unknown	PK
`orders_check_selection_id`	Unknown	PKFK
`entity_type`	Unknown
`facilitator_collect_and_remit_tax`	Unknown
`id`	Unknown
`name`	Unknown
`rate`	Unknown
`tax_amount`	Unknown
`tax_rate_entity_type`	Unknown
`tax_rate_guid`	Unknown
`type`	Unknown

orders_check_selection_modifier

Column	Type	Keys
`id`	Unknown	PK
`orders_check_selection_id`	Unknown	PKFK
`applied_discount`	Json
`applied_tax`	Json
`created_date`	Unknown
`deferred`	Unknown
`dining_option`	Unknown
`display_name`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`fulfillment_status`	Unknown
`item_entity_type`	Unknown
`item_external_id`	Unknown
`item_group`	Unknown
`item_guid`	Unknown
`item_multi_location_id`	Unknown
`modified_date`	Unknown
`modifier`	Json
`option_group_entity_type`	Unknown
`option_group_external_id`	Unknown
`option_group_guid`	Unknown
`option_group_multi_location_id`	Unknown
`option_group_pricing_mode`	Unknown
`pre_discount_price`	Unknown
`pre_modifier`	Unknown
`price`	Unknown
`quantity`	Unknown
`receipt_line_price`	Unknown
`refund_detail`	Unknown
`sales_category`	Unknown
`seat_number`	Unknown
`selection_type`	Unknown
`stored_value_transaction_id`	Unknown
`tax`	Unknown
`tax_inclusion`	Unknown
`toast_gift_card`	Unknown
`unit_of_measure`	Unknown

orders_check_selection

Column	Type	Keys
`id`	Unknown	PK
`orders_check_id`	Unknown	PKFK
`created_date`	Unknown
`deferred`	Unknown
`dining_option_entity_type`	Unknown
`dining_option_external_id`	Unknown
`dining_option_guid`	Unknown
`display_name`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`external_price_amount`	Unknown
`fulfillment_status`	Unknown
`gift_card_amount`	Unknown
`gift_card_email`	Unknown
`gift_card_from`	Unknown
`gift_card_guid`	Unknown
`gift_card_message`	Unknown
`gift_card_phone`	Unknown
`gift_card_purchaser_email`	Unknown
`gift_card_purchaser_phone`	Unknown
`gift_card_requested_delivery_date`	Unknown
`gift_card_to`	Unknown
`item_entity_type`	Unknown
`item_external_id`	Unknown
`item_group_entity_type`	Unknown
`item_group_external_id`	Unknown
`item_group_guid`	Unknown
`item_group_multi_location_id`	Unknown
`item_guid`	Unknown
`item_multi_location_id`	Unknown
`modified_date`	Unknown
`open_price_amount`	Unknown
`option_group_entity_type`	Unknown
`option_group_external_id`	Unknown
`option_group_guid`	Unknown
`option_group_multi_location_id`	Unknown
`option_group_pricing_mode`	Unknown
`pre_discount_price`	Unknown
`pre_modifier_entity_type`	Unknown
`pre_modifier_external_id`	Unknown
`pre_modifier_guid`	Unknown
`price`	Unknown
`quantity`	Unknown
`receipt_line_price`	Unknown
`refund_amount`	Unknown
`refund_transaction_entity_type`	Unknown
`refund_transaction_guid`	Unknown
`sales_category_entity_type`	Unknown
`sales_category_external_id`	Unknown
`sales_category_guid`	Unknown
`seat_number`	Unknown
`selection_type`	Unknown
`stored_value_transaction_id`	Unknown
`tax`	Unknown
`tax_inclusion`	Unknown
`tax_refund_amount`	Unknown
`toast_gift_card_entity_type`	Unknown
`toast_gift_card_guid`	Unknown
`unit_of_measure`	Unknown
`void_business_date`	Unknown
`void_date`	Unknown
`void_reason_entity_type`	Unknown
`void_reason_external_id`	Unknown
`void_reason_guid`	Unknown
`voided`	Unknown

orders_check_removed_selection

Column	Type	Keys
`id`	Unknown	PK
`orders_check_id`	Unknown	PKFK
`entity_type`	Unknown
`price`	Unknown
`quantity`	Unknown

orders_check

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	PKFK
`amount`	Unknown
`applied_loyalty_info_accrual_family_guid`	Unknown
`applied_loyalty_info_accrual_text`	Unknown
`applied_loyalty_info_entity_type`	Unknown
`applied_loyalty_info_guid`	Unknown
`applied_loyalty_info_loyalty_identifier`	Unknown
`applied_loyalty_info_masked_loyalty_identifier`	Unknown
`applied_loyalty_info_vendor`	Unknown
`applied_preauth_info_card_holder_expiration_month`	Unknown
`applied_preauth_info_card_holder_expiration_year`	Unknown
`applied_preauth_info_card_holder_first_name`	Unknown
`applied_preauth_info_card_holder_last_name`	Unknown
`applied_preauth_info_card_type`	Unknown
`applied_preauth_info_guid`	Unknown
`applied_preauth_info_mag_stripe_name`	Unknown
`applied_preauth_info_one_time_use`	Unknown
`applied_preauth_info_pre_auth_amount`	Unknown
`applied_preauth_info_reader_type`	Unknown
`applied_preauth_info_use_count`	Unknown
`billing_customer_email`	Unknown
`billing_customer_email_token`	Unknown
`billing_customer_entity_type`	Unknown
`billing_customer_first_name`	Unknown
`billing_customer_guid`	Unknown
`billing_customer_last_name`	Unknown
`billing_customer_phone`	Unknown
`billing_customer_phone_country_code`	Unknown
`billing_customer_phone_token`	Unknown
`closed_date`	Unknown
`created_date`	Unknown
`created_device_id`	Unknown
`customer_email`	Unknown
`customer_email_token`	Unknown
`customer_entity_type`	Unknown
`customer_first_name`	Unknown
`customer_guid`	Unknown
`customer_last_name`	Unknown
`customer_phone`	Unknown
`customer_phone_country_code`	Unknown
`customer_phone_token`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`display_number`	Unknown
`driver_shift_entity_type`	Unknown
`driver_shift_external_id`	Unknown
`driver_shift_guid`	Unknown
`duration`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`guest_profile_entity_type`	Unknown
`guest_profile_guid`	Unknown
`last_modified_device_id`	Unknown
`modified_date`	Unknown
`net_amount`	Unknown
`opened_date`	Unknown
`paid_date`	Unknown
`payment_status`	Unknown
`picked_up_date`	Unknown
`shift_entity_type`	Unknown
`shift_external_id`	Unknown
`shift_guid`	Unknown
`tab_name`	Unknown
`tax_amount`	Unknown
`tax_exempt`	Unknown
`tax_exemption_account_number`	Unknown
`tax_exemption_account_state`	Unknown
`tip_amount`	Unknown
`total_amount`	Unknown
`total_discount_amount`	Unknown
`void_business_date`	Unknown
`void_date`	Unknown
`voided`	Unknown

orders_pricing_feature

Column	Type	Keys
`index`	Unknown	PK
`orders_id`	Unknown	PKFK
`pricing_feature`	Unknown

orders_marketplace_facilitator_tax_info

Column	Type	Keys
`id`	Unknown	PK
`orders_id`	Unknown	FK
`entity_type`	Unknown
`facilitator_collect_and_remit_tax`	Unknown
`name`	Unknown
`rate`	Unknown
`tax_amount`	Unknown
`tax_rate_entity_type`	Unknown
`tax_rate_guid`	Unknown
`type`	Unknown

orders

Column	Type	Keys
`id`	Unknown	PK
`delivery_employee_guid`	Unknown	FK
`dining_option_guid`	Unknown	FK
`restaurant_id`	Unknown	FK
`restaurant_service_guid`	Unknown	FK
`revenue_center_guid`	Unknown	FK
`service_area_guid`	Unknown	FK
`table_guid`	Unknown	FK
`applied_packaging_info_entity_type`	Unknown
`applied_packaging_info_guid`	Unknown
`approval_status`	Unknown
`business_date`	Unknown
`capture_sequence_key`	Unknown
`channel_guid`	Unknown
`closed_date`	Unknown
`created_date`	Unknown
`created_device_id`	Unknown
`created_in_test_mode`	Unknown
`curbside_pickup_info_entity_type`	Unknown
`curbside_pickup_info_guid`	Unknown
`curbside_pickup_info_note`	Unknown
`curbside_pickup_info_transport_color`	Unknown
`curbside_pickup_info_transport_description`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`delivery_info_address_1`	Unknown
`delivery_info_address_2`	Unknown
`delivery_info_administrative_area`	Unknown
`delivery_info_city`	Unknown
`delivery_info_country`	Unknown
`delivery_info_delivered_date`	Unknown
`delivery_info_delivery_state`	Unknown
`delivery_info_dispatched_date`	Unknown
`delivery_info_latitude`	Unknown
`delivery_info_longitude`	Unknown
`delivery_info_note`	Unknown
`delivery_info_state`	Unknown
`delivery_info_zip_code`	Unknown
`delivery_service_info_driver_name`	Unknown
`delivery_service_info_driver_phone_number`	Unknown
`delivery_service_info_entity_type`	Unknown
`delivery_service_info_guid`	Unknown
`delivery_service_info_original_quoted_delivery_date`	Unknown
`delivery_service_info_provider_id`	Unknown
`delivery_service_info_provider_info`	Unknown
`delivery_service_info_provider_name`	Unknown
`duration`	Unknown
`entity_type`	Unknown
`estimated_fulfillment_date`	Unknown
`excess_food`	Unknown
`external_id`	Unknown
`facilitator_collect_and_remit_tax_order`	Unknown
`guest_order_status`	Unknown
`initial_date`	Unknown
`last_modified_device_id`	Unknown
`modified_date`	Unknown
`number_of_guest`	Unknown
`opened_date`	Unknown
`owner_entity_type`	Unknown
`owner_external_id`	Unknown
`owner_guid`	Unknown
`paid_date`	Unknown
`promised_date`	Unknown
`required_prep_time`	Unknown
`server_entity_type`	Unknown
`server_external_id`	Unknown
`server_guid`	Unknown
`source`	Unknown
`void_business_date`	Unknown
`void_date`	Unknown
`void_service_charge`	Unknown
`voided`	Unknown

restaurant_service

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`entity_type`	Unknown
`name`	Unknown

discounts

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`active`	Unknown
`amount`	Unknown
`entity_type`	Unknown
`fixed_total`	Unknown
`item_picking_priority`	Unknown
`name`	Unknown
`non_exclusive`	Unknown
`percentage`	Unknown
`selection_type`	Unknown
`type`	Unknown

job

Column	Type	Keys
`guid`	Unknown	PK
`restaurant_id`	Unknown	FK
`code`	Unknown
`created_date`	Unknown
`default_wage`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`entity_type`	Unknown
`exclude_from_reporting`	Unknown
`external_id`	Unknown
`modified_date`	Unknown
`tipped`	Unknown
`title`	Unknown
`wage_frequency`	Unknown

employee_job_reference

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`entity_type`	Unknown
`external_id`	Unknown

employee_wage_override

Column	Type	Keys
`id`	Unknown	PK
`employee_id`	Unknown	PKFK
`entity_type`	Unknown
`external_id`	Unknown
`wage`	Unknown

employee

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`chosen_name`	Unknown
`created_date`	Unknown
`deleted`	Unknown
`deleted_date`	Unknown
`email`	Unknown
`entity_type`	Unknown
`external_employee_id`	Unknown
`external_id`	Unknown
`first_name`	Unknown
`last_name`	Unknown
`modified_date`	Unknown
`passcode`	Unknown
`phone_number`	Unknown
`phone_number_country_code`	Unknown
`v_2_employee_guid`	Unknown

menu_item

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`calories`	Unknown
`entity_type`	Unknown
`external_id`	Unknown
`images`	Json
`inherit_option_groups`	Unknown
`inherit_unit_of_measure`	Unknown
`name`	Unknown
`orderable_online`	Unknown
`plu`	Unknown
`sku`	Unknown
`type`	Unknown
`unit_of_measure`	Unknown
`visibility`	Unknown

cash_entry

Column	Type	Keys
`id`	Unknown	PK
`approver_guid`	Unknown	FK
`creator_guid`	Unknown	FK
`employee_1_guid`	Unknown	FK
`employee_2_guid`	Unknown	FK
`restaurant_id`	Unknown	FK
`amount`	Unknown
`approver_entity_type`	Unknown
`cash_drawer_entity_type`	Unknown
`cash_drawer_guid`	Unknown
`creator_entity_type`	Unknown
`date`	Unknown
`employee_1_entity_type`	Unknown
`employee_1_external_id`	Unknown
`employee_2_entity_type`	Unknown
`employee_2_external_id`	Unknown
`entity_type`	Unknown
`no_sale_reason_entity_type`	Unknown
`no_sale_reason_guid`	Unknown
`payout_reason_entity_type`	Unknown
`payout_reason_guid`	Unknown
`reason`	Unknown
`type`	Unknown
`undoes`	Unknown

sale_category

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`entity_type`	Unknown
`name`	Unknown

tables

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`revenue_center_guid`	Unknown	FK
`service_area_guid`	Unknown	FK
`entity_type`	Unknown
`name`	Unknown

service_area

Column	Type	Keys
`id`	Unknown	PK
`restaurant_id`	Unknown	FK
`revenue_center_guid`	Unknown	FK
`entity_type`	Unknown
`name`	Unknown

restaurant

Column	Type	Keys
`id`	Unknown	PK
`created_by_email_address`	Unknown
`created_date`	Unknown
`external_group_ref`	Unknown
`external_restaurant_ref`	Unknown
`iso_created_date`	Unknown
`iso_modified_date`	Unknown
`location_name`	Unknown
`management_group_guid`	Unknown
`modified_date`	Unknown
`name`	Unknown

menu_group

Column	Type	Keys
`id`	Unknown	PK
`menu_id`	Unknown	PKFK
`entity_type`	Unknown
`external_id`	Unknown