# Revel Systems schema ERD

Table and field reference for the Fivetran Revel Systems connector.

## Table & Field Reference

### tax_tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| tax_id | Unknown | PK, FK |
| tax_rate_id | Unknown | PK, FK |

### tax

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| agency | Unknown |  |
| created_date | Unknown |  |
| dining_options | Unknown |  |
| establishment | Unknown |  |
| fiscal_rate | Unknown |  |
| maximum_quantity_threshold | Unknown |  |
| maximum_threshold | Unknown |  |
| min_quantity_threshold | Unknown |  |
| min_threshold | Unknown |  |
| name | Unknown |  |
| rounding_type | Unknown |  |
| tax_type | Unknown |  |
| updated_date | Unknown |  |
| uri | Unknown |  |

### inventory

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| product | Unknown | FK |
| cost | Unknown |  |
| quantity_in_hand | Unknown |  |
| quantity_in_layaway | Unknown |  |
| threshold | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### store_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| alias | Unknown |  |
| building_number | Unknown |  |
| city_name | Unknown |  |
| country | Unknown |  |
| county | Unknown |  |
| created_date | Unknown |  |
| district | Unknown |  |
| door | Unknown |  |
| is_external | Unknown |  |
| latitude | Unknown |  |
| line_1 | Unknown |  |
| line_2 | Unknown |  |
| longitude | Unknown |  |
| province | Unknown |  |
| state | Unknown |  |
| updated_date | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |
| zip_code | Unknown |  |

### product_product_group

| Column | Type | Keys |
| --- | --- | --- |
| product_group | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_printer

| Column | Type | Keys |
| --- | --- | --- |
| printer | Unknown | PK |
| product_id | Unknown | PK, FK |

### product_list_printer

| Column | Type | Keys |
| --- | --- | --- |
| list_printer | Unknown | PK |
| product_id | Unknown | PK, FK |

### combo_discount_product

| Column | Type | Keys |
| --- | --- | --- |
| combo_discount_product | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_combo_set

| Column | Type | Keys |
| --- | --- | --- |
| combo_product_set_id | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product_product_category

| Column | Type | Keys |
| --- | --- | --- |
| category | Unknown | PK, FK |
| product_id | Unknown | PK, FK |

### product

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown | FK |
| created_by | Unknown | FK |
| parent_product | Unknown | FK |
| product_class | Unknown | FK |
| tax_id | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| allow_price_override | Unknown |  |
| attribute_1 | Unknown |  |
| attribute_1_name | Unknown |  |
| attribute_2 | Unknown |  |
| attribute_2_name | Unknown |  |
| attribute_parent | Unknown |  |
| attribute_type | Unknown |  |
| attribute_value_1 | Unknown |  |
| attribute_value_2 | Unknown |  |
| barcode | Unknown |  |
| bin_value | Unknown |  |
| color_code | Unknown |  |
| combo_product_1 | Unknown |  |
| combo_product_2 | Unknown |  |
| combo_product_3 | Unknown |  |
| combo_product_4 | Unknown |  |
| combo_product_5 | Unknown |  |
| combo_product_6 | Unknown |  |
| combo_product_7 | Unknown |  |
| combo_product_8 | Unknown |  |
| combo_saving_productset | Unknown |  |
| combo_upcharge | Unknown |  |
| comments | Unknown |  |
| commission | Unknown |  |
| commission_type | Unknown |  |
| conv_ordering_disp | Unknown |  |
| conv_ordering_sort_order | Unknown |  |
| cost | Unknown |  |
| course_number | Unknown |  |
| created_date | Unknown |  |
| crv_enabled | Unknown |  |
| crv_label | Unknown |  |
| crv_value | Unknown |  |
| default_inventory | Unknown |  |
| delivery_method | Unknown |  |
| dept | Unknown |  |
| description | Unknown |  |
| disable_modifier_popup | Unknown |  |
| discountable | Unknown |  |
| display_on_kiosk | Unknown |  |
| display_online | Unknown |  |
| dynamic_combo | Unknown |  |
| ebt_no | Unknown |  |
| eligible_for_purchase_rewards | Unknown |  |
| end_date | Unknown |  |
| establishment | Unknown |  |
| export | Unknown |  |
| flat_tax_units | Unknown |  |
| happy_hour_price | Unknown |  |
| image | Unknown |  |
| increase_group_combo_price_based_on_upcharge | Unknown |  |
| is_cold | Unknown |  |
| is_combo | Unknown |  |
| is_drink | Unknown |  |
| is_food | Unknown |  |
| item_no | Unknown |  |
| kitchen_description | Unknown |  |
| kitchen_print_name | Unknown |  |
| label_date | Unknown |  |
| limit_type | Unknown |  |
| limit_value | Unknown |  |
| manufacturer | Unknown |  |
| maximum_price | Unknown |  |
| maximum_threshold_price | Unknown |  |
| min_price | Unknown |  |
| msrp | Unknown |  |
| name | Unknown |  |
| negative_sales_restricted | Unknown |  |
| not_returnable | Unknown |  |
| original_price | Unknown |  |
| parent_dynamic_combo | Unknown |  |
| percent_markup | Unknown |  |
| point_redeem | Unknown |  |
| point_value | Unknown |  |
| pos_column_width | Unknown |  |
| prep_recipe | Unknown |  |
| prep_yield | Unknown |  |
| preparation_time | Unknown |  |
| prevent_sales | Unknown |  |
| price | Unknown |  |
| price_embedded | Unknown |  |
| print_tags | Unknown |  |
| product_brand | Unknown |  |
| product_height | Unknown |  |
| product_height_unit | Unknown |  |
| product_length | Unknown |  |
| product_length_unit | Unknown |  |
| product_price_in_combo | Unknown |  |
| product_weight | Unknown |  |
| product_weight_unit | Unknown |  |
| product_width | Unknown |  |
| product_width_unit | Unknown |  |
| promotional_product | Unknown |  |
| prompt_for_quantity | Unknown |  |
| prompt_for_upsell | Unknown |  |
| purchase_product_age | Unknown |  |
| purchase_product_age_msg | Unknown |  |
| purchase_reward_multiplier | Unknown |  |
| quick_pick_group | Unknown |  |
| receipt_text | Unknown |  |
| redemption_level | Unknown |  |
| require_serial_number | Unknown |  |
| retail | Unknown |  |
| rti_combo | Unknown |  |
| seasonal_item | Unknown |  |
| service_duration | Unknown |  |
| set_price_per_group_for_combo | Unknown |  |
| shelf_label_quantity | Unknown |  |
| shopify_sku | Unknown |  |
| show_on_pos | Unknown |  |
| size_chart | Unknown |  |
| sku | Unknown |  |
| sold_by_weight | Unknown |  |
| sorting | Unknown |  |
| start_date | Unknown |  |
| surcharge | Unknown |  |
| tare | Unknown |  |
| tax_class | Unknown |  |
| tax_included | Unknown |  |
| third_party_id | Unknown |  |
| track_in_inventory | Unknown |  |
| track_recipe | Unknown |  |
| type | Unknown |  |
| unit_size | Unknown |  |
| uom | Unknown |  |
| updated_date | LocalDateTime |  |
| upsell_combo_price | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |
| variable_pricing | Unknown |  |
| variable_pricing_by | Unknown |  |

### order_package

| Column | Type | Keys |
| --- | --- | --- |
| package | Unknown | PK |
| order_id | Unknown | PK, FK |

### order_history

| Column | Type | Keys |
| --- | --- | --- |
| order_history | Unknown | PK |
| order_id | Unknown | PK, FK |

### orders

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_parent | Unknown | FK |
| created_by | Unknown | FK |
| customer | Unknown | FK |
| delivery_employee | Unknown | FK |
| discounted_by | Unknown | FK |
| table_owner | Unknown | FK |
| tax | Unknown | FK |
| updated_by | Unknown | FK |
| asap | Unknown |  |
| auto_grat_pct | Unknown |  |
| bill_number | Unknown |  |
| billing_address | Unknown |  |
| billing_zip_code | Unknown |  |
| bills_info | Unknown |  |
| bills_type | Unknown |  |
| call_name | Unknown |  |
| call_number | Unknown |  |
| check_sum | Unknown |  |
| closed | Unknown |  |
| created_at | Unknown |  |
| created_date | Unknown |  |
| crv_taxed | Unknown |  |
| crv_value | Unknown |  |
| customer_address_distance | Unknown |  |
| customer_birthdate | Unknown |  |
| deleted | Unknown |  |
| deleted_discounts | Unknown |  |
| delivery_active | Unknown |  |
| delivery_city | Unknown |  |
| delivery_clock_in | Unknown |  |
| delivery_clock_out | Unknown |  |
| delivery_company_name | Unknown |  |
| delivery_country | Unknown |  |
| delivery_distance | Unknown |  |
| delivery_duration | Unknown |  |
| delivery_email | Unknown |  |
| delivery_estimated_distance | Unknown |  |
| delivery_id | Unknown |  |
| delivery_instruction | Unknown |  |
| delivery_latitude | Unknown |  |
| delivery_longitude | Unknown |  |
| delivery_name | Unknown |  |
| delivery_phone_number | Unknown |  |
| delivery_primary_billing | Unknown |  |
| delivery_primary_shipping | Unknown |  |
| delivery_state | Unknown |  |
| delivery_street_1 | Unknown |  |
| delivery_uuid | Unknown |  |
| delivery_zip_code | Unknown |  |
| device_id | Unknown |  |
| dining_option | Unknown |  |
| discount_code | Unknown |  |
| discount_nontaxable_surcharge_included | Unknown |  |
| discount_reason | Unknown |  |
| discount_rule_type | Unknown |  |
| drive_through_data | Unknown |  |
| establishment | Unknown |  |
| exchange_discount | Unknown |  |
| exchanged | Unknown |  |
| external_sync | Unknown |  |
| final_total | Unknown |  |
| fleet_service_data | Unknown |  |
| gift_reward_data | Unknown |  |
| gratuity | Unknown |  |
| gratuity_type | Unknown |  |
| has_delivery_info | Unknown |  |
| has_history | Unknown |  |
| has_items | Unknown |  |
| house_account_applied | Unknown |  |
| invoice_date | Unknown |  |
| is_discounted | Unknown |  |
| is_invoice | Unknown |  |
| is_readonly | Unknown |  |
| is_unpaid | Unknown |  |
| kitchen_status | Unknown |  |
| last_updated_at | Unknown |  |
| local_id | Unknown |  |
| loyalty_account_id | Unknown |  |
| notes | Unknown |  |
| notification_email_sent | Unknown |  |
| notification_text_sent | Unknown |  |
| number_of_people | Unknown |  |
| pickup_call_name | Unknown |  |
| pickup_customer_arrived | Unknown |  |
| pickup_email | Unknown |  |
| pickup_phone_number | Unknown |  |
| pickup_pickup_type | Unknown |  |
| pickup_send_confirmation | Unknown |  |
| pickup_status | Unknown |  |
| pickup_vehicle_color | Unknown |  |
| pickup_vehicle_make | Unknown |  |
| pickup_vehicle_type | Unknown |  |
| points_added | Unknown |  |
| points_redeemed | Unknown |  |
| pos_mode | Unknown |  |
| prevailing_surcharge | Unknown |  |
| prevailing_tax | Unknown |  |
| printed | Unknown |  |
| registry_coo_counter | Unknown |  |
| registry_custom_data | Unknown |  |
| registry_fiscale_sale_id | Unknown |  |
| registry_id | Unknown |  |
| registry_printer_serial | Unknown |  |
| registry_uri | Unknown |  |
| remaining_due | Unknown |  |
| reporting_id | Unknown |  |
| rounding_delta | Unknown |  |
| running_tax_number | Unknown |  |
| sent | Unknown |  |
| service_fee_tax | Unknown |  |
| service_fee_taxed | Unknown |  |
| service_fee_untaxed | Unknown |  |
| smart_order | Unknown |  |
| smartpay_gratuity | Unknown |  |
| smartpay_tip | Unknown |  |
| subtotal | Unknown |  |
| surcharge | Unknown |  |
| surcharge_excluded | Unknown |  |
| tables | Unknown |  |
| tax_country | Unknown |  |
| tax_excluded_amount | Unknown |  |
| tax_rebate | Unknown |  |
| tax_rounding_model | Unknown |  |
| taxable_surcharge | Unknown |  |
| taxable_surcharge_excluded | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |
| uuid | Unknown |  |
| vehicle | Unknown |  |
| version | Unknown |  |
| virtual_delivery_track_link | Unknown |  |
| virtual_order_status | Unknown |  |
| virtual_third_party_order_id | Unknown |  |
| web_order | Unknown |  |

### applied_discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_id | Unknown | FK |
| order_item_id | Unknown | FK |
| discount | Unknown |  |
| name | Unknown |  |
| quantity | Unknown |  |
| rule_amount | Unknown |  |
| rule_type | Unknown |  |
| stackable_type | Unknown |  |
| tax_amount_included | Unknown |  |
| taxed | Unknown |  |
| type | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |

### order_item_applied_tax

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| applied_tax_order_id | Unknown | PK, FK |
| order_item_id | Unknown | FK |

### order_item_applied_service_fee

| Column | Type | Keys |
| --- | --- | --- |
| type | Unknown | PK |
| applied_service_fee_id | Unknown | PK, FK |
| parent_id | Unknown | PK, FK |

### customer_vehicle

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer_id | Unknown | FK |
| active | Unknown |  |
| created_date | Unknown |  |
| manufacturer | Unknown |  |
| model | Unknown |  |
| odometer | Unknown |  |
| owner | Unknown |  |
| plate | Unknown |  |
| state | Unknown |  |
| updated_date | LocalDateTime |  |
| uuid | Unknown |  |
| vin | Unknown |  |
| year | Unknown |  |

### customer_reward_card_number

| Column | Type | Keys |
| --- | --- | --- |
| reward_card_number | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_gift_card_number

| Column | Type | Keys |
| --- | --- | --- |
| gift_card_number | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_group

| Column | Type | Keys |
| --- | --- | --- |
| customer_group | Unknown | PK |
| customer_id | Unknown | PK, FK |

### customer_customer_address

| Column | Type | Keys |
| --- | --- | --- |
| address_id | Unknown | PK, FK |
| customer_id | Unknown | PK, FK |

### customer

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| accept_check | Unknown |  |
| active | Unknown |  |
| birth_date | Unknown |  |
| company_name | Unknown |  |
| contract_expiration | Unknown |  |
| created_date | Unknown |  |
| credit_card_exp | Unknown |  |
| credit_card_first_name | Unknown |  |
| credit_card_last_4_digits | Unknown |  |
| credit_card_last_name | Unknown |  |
| deleted | Unknown |  |
| discount | Unknown |  |
| email | Unknown |  |
| email_opt_in | Unknown |  |
| exp_date | Unknown |  |
| expensify_account | Unknown |  |
| first_name | Unknown |  |
| gender | Unknown |  |
| image_resource_uri | Unknown |  |
| image_url | Unknown |  |
| is_visitor | Unknown |  |
| last_name | Unknown |  |
| lic_number | Unknown |  |
| loyalty_number | Unknown |  |
| loyalty_ref_id | Unknown |  |
| notes | Unknown |  |
| ok_to_email | Unknown |  |
| past_due | Unknown |  |
| phone_number | Unknown |  |
| phone_opt_in | Unknown |  |
| picture | Unknown |  |
| pin | Unknown |  |
| post_opt_in | Unknown |  |
| ref_number | Unknown |  |
| source | Unknown |  |
| tax_exempt | Unknown |  |
| tax_location | Unknown |  |
| third_party_id | Unknown |  |
| title | Unknown |  |
| track_as_company | Unknown |  |
| type | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |
| uuid | Unknown |  |
| version_date | Unknown |  |

### applied_service_fee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| orders | Unknown | FK |
| parent_uuid | Unknown | FK |
| amount | Unknown |  |
| application_type | Unknown |  |
| apply_to | Unknown |  |
| created_date | Unknown |  |
| deleted | Unknown |  |
| include_employee_pass_through_fee_in | Unknown |  |
| invoice_document_uuid | Unknown |  |
| item | Unknown |  |
| local_service_fee_id | Unknown |  |
| name | Unknown |  |
| pass_through_amount | Unknown |  |
| pass_through_fee_type | Unknown |  |
| pass_through_type | Unknown |  |
| post_tax | Unknown |  |
| sort | Unknown |  |
| tax_amount | Unknown |  |
| taxed | Unknown |  |
| total_amount | Unknown |  |
| type | Unknown |  |
| updated_date | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |

### product_group

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| discount | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| display | Unknown |  |
| establishment | Unknown |  |
| name | Unknown |  |
| sorting | Unknown |  |
| tax_rule | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### applied_tax_order

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| local_tax_id | Unknown | FK |
| orders | Unknown | FK |
| dining_options | Unknown |  |
| fiscal_rate | Unknown |  |
| is_prevailing | Unknown |  |
| maximum_quantity_threshold | Unknown |  |
| maximum_threshold | Unknown |  |
| min_quantity_threshold | Unknown |  |
| min_threshold | Unknown |  |
| name | Unknown |  |
| on_full_price | Unknown |  |
| rounding_type | Unknown |  |
| tax_rate | Unknown |  |
| tax_table | Unknown |  |
| tax_type | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |

### discount_timetable

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| discount_id | Unknown | PK, FK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| close_time | Unknown |  |
| created_date | Unknown |  |
| day_of_week | Unknown |  |
| open_time | Unknown |  |
| timetable | Unknown |  |
| updated_date | Unknown |  |

### discount_product_class

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| product_class | Unknown | PK, FK |

### discount_volume_product_group

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| volume_product_group | Unknown | PK, FK |

### discount_volume_product_class

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| volume_product_class | Unknown | PK, FK |

### discount_volume_modifier_class

| Column | Type | Keys |
| --- | --- | --- |
| volume_modifier_class | Unknown | PK |
| discount_id | Unknown | PK, FK |

### discount_product_group_price

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| product_group | Unknown | PK, FK |
| price | Unknown |  |

### discount_modifier_class

| Column | Type | Keys |
| --- | --- | --- |
| modifier_class | Unknown | PK |
| discount_id | Unknown | PK, FK |

### discount_product_group

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| product_group | Unknown | PK, FK |

### discount_product_class_price

| Column | Type | Keys |
| --- | --- | --- |
| discount_id | Unknown | PK, FK |
| product_class | Unknown | PK, FK |
| price | Unknown |  |

### discount

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| category | Unknown | FK |
| created_by | Unknown | FK |
| gift | Unknown | FK |
| modifier | Unknown | FK |
| product | Unknown | FK |
| product_class | Unknown | FK |
| timetable_created_by | Unknown | FK |
| timetable_updated_by | Unknown | FK |
| updated_by | Unknown | FK |
| action_code | Unknown |  |
| active | Unknown |  |
| admin_key | Unknown |  |
| alt_price_tier | Unknown |  |
| amount | Unknown |  |
| application_type | Unknown |  |
| apply_multiple_times | Unknown |  |
| apply_reprice_to_sum_of_products | Unknown |  |
| apply_to_all_qualifying_products | Unknown |  |
| apply_to_base_product_only | Unknown |  |
| apply_to_entire_application_type | Unknown |  |
| apply_to_weighted_products | Unknown |  |
| at_item_level | Unknown |  |
| auto_apply | Unknown |  |
| awarding | Unknown |  |
| barcode | Unknown |  |
| code | Unknown |  |
| created_date | Unknown |  |
| dining_options | Unknown |  |
| display_on_ipad | Unknown |  |
| dummy_pan | Unknown |  |
| effective_from | Unknown |  |
| effective_to | Unknown |  |
| establishment | Unknown |  |
| exclude_upsell_from_discount | Unknown |  |
| floor | Unknown |  |
| function | Unknown |  |
| how_often_apply | Unknown |  |
| is_repeating_cash_off | Unknown |  |
| is_variable | Unknown |  |
| is_wholesale | Unknown |  |
| loyalty_code | Unknown |  |
| maximum_limit | Double |  |
| maximum_off | Unknown |  |
| method | Unknown |  |
| minimum_amount | Unknown |  |
| minimum_amount_to_entire_order | Unknown |  |
| minimum_limit | Double |  |
| modifier_class | Unknown |  |
| name | Unknown |  |
| old_taxed_flag | Unknown |  |
| ovs_validation | Unknown |  |
| password_required | Unknown |  |
| points_needed_for_redemption | Unknown |  |
| product_from_each_cls_grp | Unknown |  |
| qualification_subtype | Unknown |  |
| qualification_type | Unknown |  |
| receipt_text | Unknown |  |
| reduce_by_product_upcharge_value | Unknown |  |
| restricted_payment_methods_array | Unknown |  |
| rewards_type | Unknown |  |
| scheme_code | Unknown |  |
| stackable_discount_type | Unknown |  |
| tally | Unknown |  |
| target_volume | Unknown |  |
| taxed | Unknown |  |
| tier | Unknown |  |
| timetable_active | Unknown |  |
| timetable_created_date | Unknown |  |
| timetable_establishment | Unknown |  |
| timetable_from_date | Unknown |  |
| timetable_id | Unknown |  |
| timetable_to_date | Unknown |  |
| timetable_type | Unknown |  |
| timetable_updated_date | Unknown |  |
| type | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |
| volume | Unknown |  |
| volume_modifier | Unknown |  |
| volume_modifier_class | Unknown |  |
| volume_product | Unknown |  |
| volume_type | Unknown |  |
| weborder_name | Unknown |  |

### order_item_modifier

| Column | Type | Keys |
| --- | --- | --- |
| item_modifier_id | Unknown | PK, FK |
| order_item_id | Unknown | PK, FK |

### order_item_ingredient

| Column | Type | Keys |
| --- | --- | --- |
| ingredient_item | Unknown | PK |
| order_item_id | Unknown | PK, FK |

### order_item_commission_commission

| Column | Type | Keys |
| --- | --- | --- |
| commission_id | Unknown | PK, FK |
| order_item_id | Unknown | PK, FK |

### order_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| bill_parent | Unknown | FK |
| created_by | Unknown | FK |
| discounted_by | Unknown | FK |
| gift_card_number | Unknown | FK |
| orders | Unknown | FK |
| parent_combo_uuid | Unknown | FK |
| parent_uuid | Unknown | FK |
| product | Unknown | FK |
| updated_by | Unknown | FK |
| appointment | Unknown |  |
| appointment_ref_uuid | Unknown |  |
| catering_complete | Unknown |  |
| catering_delivery_date | Unknown |  |
| combo_fraction_part | Unknown |  |
| combo_product_set | Unknown |  |
| combo_saving_amount | Unknown |  |
| combo_type | Unknown |  |
| combo_used | Unknown |  |
| combo_uuid | Unknown |  |
| commission_amount | Unknown |  |
| cost | Unknown |  |
| course_number | Unknown |  |
| created_date | Unknown |  |
| crv_value | Unknown |  |
| cup_quantity | Unknown |  |
| cup_weight | Unknown |  |
| date_paid | Unknown |  |
| deleted | Unknown |  |
| deleted_date | Unknown |  |
| dining_option | Unknown |  |
| discount_reason | Unknown |  |
| dynamic_combo | Unknown |  |
| dynamic_combo_slot | Unknown |  |
| ervc_type | Unknown |  |
| event_date | Unknown |  |
| exchange_discount | Unknown |  |
| exchanged | Unknown |  |
| exclude_from_discount | Unknown |  |
| expedited | Unknown |  |
| external_shipping_address | Unknown |  |
| initial_price | Unknown |  |
| invoice_document_uuid | Unknown |  |
| is_cold | Unknown |  |
| is_discounted | Unknown |  |
| is_layaway | Unknown |  |
| is_store_credit | Unknown |  |
| item_type | Unknown |  |
| kitchen_completed | Unknown |  |
| manual_unit_price_adjustment | Unknown |  |
| modifier_amount | Unknown |  |
| modifier_cost | Unknown |  |
| not_returnable | Unknown |  |
| on_hold | Unknown |  |
| on_layaway | Unknown |  |
| order_local_id | Unknown |  |
| package | Unknown |  |
| package_uuid | Unknown |  |
| price | Unknown |  |
| price_to_display | Unknown |  |
| printed | Unknown |  |
| product_name_override | Unknown |  |
| pump_date | Unknown |  |
| pump_number | Unknown |  |
| pure_sales | Unknown |  |
| quantity | Unknown |  |
| reference_discount | Unknown |  |
| reference_discounts | Unknown |  |
| returned_establishment | Unknown |  |
| sales_tax_exemption_reason | Unknown |  |
| scanned_barcode | Unknown |  |
| seat_number | Unknown |  |
| sent | Unknown |  |
| serial_number | Unknown |  |
| service_provider | Unknown |  |
| shared | Unknown |  |
| sold_by_weight | Unknown |  |
| special_request | Unknown |  |
| split_parts | Unknown |  |
| split_type | Unknown |  |
| split_with_seat | Unknown |  |
| start_time | Unknown |  |
| station | Unknown |  |
| tax_amount | Unknown |  |
| tax_included | Unknown |  |
| tax_rate | Unknown |  |
| tax_rebate | Unknown |  |
| taxed_flag | Unknown |  |
| temp_sort | Unknown |  |
| uom | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |
| uuid | Unknown |  |
| void_ref_uuid | Unknown |  |
| voided_by | Unknown |  |
| voided_date | Unknown |  |
| voided_reason | Unknown |  |
| weight | Unknown |  |
| wholesale_saving_amount | Unknown |  |

### users

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| additional_data | Json |  |
| auth_0_id | Unknown |  |
| date_joined | Unknown |  |
| first_name | Unknown |  |
| google_id | Unknown |  |
| has_ems_access | Unknown |  |
| has_mc_access | Unknown |  |
| is_active | Unknown |  |
| is_bill_to | Unknown |  |
| is_global_super_user | Unknown |  |
| is_reseller | Unknown |  |
| is_sold_to | Unknown |  |
| is_staff | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| ruid | Unknown |  |
| uri | Unknown |  |
| username | Unknown |  |

### order_item_commission

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| commission_user | Unknown | FK |
| created_by | Unknown | FK |
| order_item | Unknown | FK |
| updated_by | Unknown | FK |
| commission_amount | Unknown |  |
| commission_pct | Unknown |  |
| created_date | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### customer_address

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| customer | Unknown | FK |
| active | Unknown |  |
| city | Unknown |  |
| company_name | Unknown |  |
| country | Unknown |  |
| created_date | Unknown |  |
| delivery_instructions | Unknown |  |
| email | Unknown |  |
| latitude | Unknown |  |
| longitude | Unknown |  |
| name | Unknown |  |
| phone_number | Unknown |  |
| primary_billing | Unknown |  |
| primary_shipping | Unknown |  |
| state | Unknown |  |
| street_1 | Unknown |  |
| street_2 | Unknown |  |
| updated_date | Unknown |  |
| uuid | Unknown |  |
| zip_code | Unknown |  |

### timesheet

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| employee | Unknown | FK |
| parent | Unknown | FK |
| updated_by | Unknown | FK |
| break_length | Unknown |  |
| break_type | Unknown |  |
| clock_in | Unknown |  |
| clock_out | Unknown |  |
| created_date | Unknown |  |
| department_name | Unknown |  |
| establishment | Unknown |  |
| exempt_salaried | Unknown |  |
| is_auto_clock_out | Unknown |  |
| remarks | Unknown |  |
| returned_date | Unknown |  |
| role_name | Unknown |  |
| role_wage | Unknown |  |
| stage | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### modifier_item_split_combo

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| modifier_item_id | Unknown | PK, FK |
| value | Unknown |  |

### modifier_item

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| order_item | Unknown | FK |
| conditional_of | Unknown |  |
| is_discounted | Unknown |  |
| is_substituted | Unknown |  |
| mod_type | Unknown |  |
| modifier | Unknown |  |
| modifier_cost | Unknown |  |
| modifier_price | Unknown |  |
| no_modifier_substitute | Unknown |  |
| quantity | Unknown |  |
| quantity_type | Unknown |  |
| substitution_of | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |

### time_schedule

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| employee | Unknown | FK |
| updated_by | Unknown | FK |
| break_type | Unknown |  |
| created_date | Unknown |  |
| department | Unknown |  |
| establishment | Unknown |  |
| exempt_salaried | Unknown |  |
| role | Unknown |  |
| role_wage | Unknown |  |
| shift_begin_time | Unknown |  |
| shift_end_time | Unknown |  |
| stage | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### business_day

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| closed | Unknown |  |
| date | Unknown |  |
| establishment | Unknown |  |
| opened | Unknown |  |
| third_party_id | Unknown |  |
| uri | Unknown |  |
| uuid | Unknown |  |

### employee_role

| Column | Type | Keys |
| --- | --- | --- |
| role | Unknown | PK |
| employee_id | Unknown | PK, FK |

### employee

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| updated_by | Unknown | FK |
| users | Unknown | FK |
| active | Unknown |  |
| card | Unknown |  |
| created_date | Unknown |  |
| email | Unknown |  |
| end | Unknown |  |
| exempt | Unknown |  |
| external_id | Unknown |  |
| failed_login_attempts | Unknown |  |
| first_name | Unknown |  |
| internal_employee_id | Unknown |  |
| last_login | Unknown |  |
| last_name | Unknown |  |
| last_timesheet_entry | Unknown |  |
| locked_account | Unknown |  |
| locked_account_timestamp | Unknown |  |
| mileage_reimbursement | Unknown |  |
| phone_number | Unknown |  |
| picture | Unknown |  |
| pin | Unknown |  |
| pplc_notification | Unknown |  |
| start | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |
| weekly_wage | Unknown |  |

### tax_rate

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| tax | Unknown | FK |
| updated_by | Unknown | FK |
| created_date | Unknown |  |
| effective_from | Unknown |  |
| effective_to | Unknown |  |
| tax_rate | Unknown |  |
| tax_table | Unknown |  |
| updated_date | Unknown |  |
| uri | Unknown |  |
| use_tax_table | Unknown |  |

### product_sub_category

| Column | Type | Keys |
| --- | --- | --- |
| product_sub_category_id | Unknown | PK |
| product_category_id | Unknown | PK, FK |

### product_category

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| parent | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| color_code | Unknown |  |
| conv_ordering_disp | Unknown |  |
| conv_ordering_sort_order | Unknown |  |
| created_date | Unknown |  |
| description | Unknown |  |
| establishment | Unknown |  |
| event_info | Unknown |  |
| img_url | Unknown |  |
| is_service | Unknown |  |
| lock_add_product | Unknown |  |
| lock_add_subcategory | Unknown |  |
| name | Unknown |  |
| sorting | Unknown |  |
| third_party_id | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### product_class

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| parent | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| admin_class_key | Unknown |  |
| created_date | Unknown |  |
| deleted | Unknown |  |
| exclude_from_discount | Unknown |  |
| is_admin_class | Unknown |  |
| name | Unknown |  |
| sorting | Unknown |  |
| updated_date | LocalDateTime |  |
| uri | Unknown |  |

### combo_product_set_combo_set

| Column | Type | Keys |
| --- | --- | --- |
| _fivetran_id | String | PK |
| combo_product_set_id | Unknown | FK |
| product | Unknown | FK |
| default_qty | Unknown |  |
| sorting | Unknown |  |
| upcharge_price | Unknown |  |
| uri | Unknown |  |

### combo_product_set

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| created_by | Unknown | FK |
| product | Unknown | FK |
| updated_by | Unknown | FK |
| active | Unknown |  |
| barcode | Unknown |  |
| base_price_on | Unknown |  |
| charge_full_price | Unknown |  |
| combo_type | Unknown |  |
| created_date | Unknown |  |
| is_combo_saving | Unknown |  |
| is_upsell | Unknown |  |
| name | Unknown |  |
| pos_column_width | Unknown |  |
| price_in_combo | Unknown |  |
| quantity | Unknown |  |
| surcharge | Unknown |  |
| updated_date | Unknown |  |
| uri | Unknown |  |

## Relationships

- tax_tax_rate(tax_rate_id) → tax_rate(id)
- tax_tax_rate(tax_id) → tax(id)
- tax(created_by) → users(uri)
- tax(updated_by) → users(uri)
- inventory(product) → product(uri)
- store_address(created_by) → users(uri)
- store_address(updated_by) → users(uri)
- product_product_group(product_group) → product_group(id)
- product_product_group(product_id) → product(id)
- product_printer(product_id) → product(id)
- product_list_printer(product_id) → product(id)
- combo_discount_product(combo_discount_product) → product(uri)
- combo_discount_product(product_id) → product(id)
- product_combo_set(combo_product_set_id) → combo_product_set(id)
- product_combo_set(product_id) → product(id)
- product_product_category(category) → product_category(id)
- product_product_category(product_id) → product(id)
- product(tax_id) → tax(id)
- product(created_by) → users(uri)
- product(parent_product) → product(uri)
- product(product_class) → product_class(uri)
- product(category) → product_category(uri)
- product(updated_by) → users(uri)
- order_package(order_id) → orders(id)
- order_history(order_id) → orders(id)
- orders(delivery_employee) → users(uri)
- orders(table_owner) → users(uri)
- orders(created_by) → users(uri)
- orders(tax) → tax(uri)
- orders(discounted_by) → users(uri)
- orders(customer) → customer(uri)
- orders(updated_by) → users(uri)
- orders(bill_parent) → orders(uri)
- applied_discount(order_id) → orders(id)
- applied_discount(order_item_id) → order_item(id)
- order_item_applied_tax(applied_tax_order_id) → applied_tax_order(id)
- order_item_applied_tax(order_item_id) → order_item(id)
- order_item_applied_service_fee(applied_service_fee_id) → applied_service_fee(id)
- order_item_applied_service_fee(parent_id) → order_item(id)
- customer_vehicle(customer_id) → customer(id)
- customer_reward_card_number(customer_id) → customer(id)
- customer_gift_card_number(customer_id) → customer(id)
- customer_group(customer_id) → customer(id)
- customer_customer_address(address_id) → customer_address(id)
- customer_customer_address(customer_id) → customer(id)
- customer(created_by) → users(uri)
- customer(updated_by) → users(uri)
- applied_service_fee(parent_uuid) → applied_service_fee(uuid)
- applied_service_fee(orders) → orders(uri)
- product_group(discount) → discount(uri)
- product_group(created_by) → users(uri)
- product_group(updated_by) → users(uri)
- applied_tax_order(local_tax_id) → tax(id)
- applied_tax_order(orders) → orders(uri)
- discount_timetable(created_by) → users(uri)
- discount_timetable(updated_by) → users(uri)
- discount_timetable(discount_id) → discount(id)
- discount_product_class(product_class) → product_class(id)
- discount_product_class(discount_id) → discount(id)
- discount_volume_product_group(volume_product_group) → product_group(id)
- discount_volume_product_group(discount_id) → discount(id)
- discount_volume_product_class(volume_product_class) → product_class(id)
- discount_volume_product_class(discount_id) → discount(id)
- discount_volume_modifier_class(discount_id) → discount(id)
- discount_product_group_price(product_group) → product_group(id)
- discount_product_group_price(discount_id) → discount(id)
- discount_modifier_class(discount_id) → discount(id)
- discount_product_group(product_group) → product_group(id)
- discount_product_group(discount_id) → discount(id)
- discount_product_class_price(product_class) → product_class(id)
- discount_product_class_price(discount_id) → discount(id)
- discount(gift) → product(uri)
- discount(created_by) → users(uri)
- discount(product) → product(uri)
- discount(modifier) → modifier_item(uri)
- discount(updated_by) → users(uri)
- discount(timetable_created_by) → users(uri)
- discount(timetable_updated_by) → users(uri)
- discount(category) → product_category(uri)
- discount(product_class) → product_class(uri)
- order_item_modifier(item_modifier_id) → modifier_item(id)
- order_item_modifier(order_item_id) → order_item(id)
- order_item_ingredient(order_item_id) → order_item(id)
- order_item_commission_commission(commission_id) → order_item_commission(id)
- order_item_commission_commission(order_item_id) → order_item(id)
- order_item(created_by) → users(uri)
- order_item(product) → product(uri)
- order_item(gift_card_number) → customer_gift_card_number(gift_card_number)
- order_item(parent_uuid) → order_item(uuid)
- order_item(discounted_by) → users(uri)
- order_item(updated_by) → users(uri)
- order_item(parent_combo_uuid) → order_item(combo_uuid)
- order_item(orders) → orders(uri)
- order_item(bill_parent) → order_item(uri)
- order_item_commission(created_by) → users(uri)
- order_item_commission(commission_user) → users(uri)
- order_item_commission(updated_by) → users(uri)
- order_item_commission(order_item) → order_item(uri)
- customer_address(customer) → customer(uri)
- timesheet(parent) → timesheet(uri)
- timesheet(created_by) → users(uri)
- timesheet(employee) → employee(uri)
- timesheet(updated_by) → users(uri)
- modifier_item_split_combo(modifier_item_id) → modifier_item(id)
- modifier_item(order_item) → order_item(uri)
- time_schedule(created_by) → users(uri)
- time_schedule(employee) → employee(uri)
- time_schedule(updated_by) → users(uri)
- employee_role(employee_id) → employee(id)
- employee(created_by) → users(uri)
- employee(users) → users(uri)
- employee(updated_by) → users(uri)
- tax_rate(created_by) → users(uri)
- tax_rate(tax) → tax(uri)
- tax_rate(updated_by) → users(uri)
- product_sub_category(product_category_id) → product_category(id)
- product_category(parent) → product_category(uri)
- product_category(created_by) → users(uri)
- product_category(updated_by) → users(uri)
- product_class(parent) → product_class(uri)
- product_class(created_by) → users(uri)
- product_class(updated_by) → users(uri)
- combo_product_set_combo_set(product) → product(uri)
- combo_product_set_combo_set(combo_product_set_id) → combo_product_set(id)
- combo_product_set(created_by) → users(uri)
- combo_product_set(product) → product(uri)
- combo_product_set(updated_by) → users(uri)