Revel Systems

Explore the interactive ERD

Table & Field Reference

tax_tax_rate

Column	Type	Keys
`tax_id`	Unknown	PKFK
`tax_rate_id`	Unknown	PKFK

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	PKFK
`product_id`	Unknown	PKFK

product_printer

Column	Type	Keys
`printer`	Unknown	PK
`product_id`	Unknown	PKFK

product_list_printer

Column	Type	Keys
`list_printer`	Unknown	PK
`product_id`	Unknown	PKFK

combo_discount_product

Column	Type	Keys
`combo_discount_product`	Unknown	PKFK
`product_id`	Unknown	PKFK

product_combo_set

Column	Type	Keys
`combo_product_set_id`	Unknown	PKFK
`product_id`	Unknown	PKFK

product_product_category

Column	Type	Keys
`category`	Unknown	PKFK
`product_id`	Unknown	PKFK

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	PKFK

order_history

Column	Type	Keys
`order_history`	Unknown	PK
`order_id`	Unknown	PKFK

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	PKFK
`order_item_id`	Unknown	FK

order_item_applied_service_fee

Column	Type	Keys
`type`	Unknown	PK
`applied_service_fee_id`	Unknown	PKFK
`parent_id`	Unknown	PKFK

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	PKFK

customer_gift_card_number

Column	Type	Keys
`gift_card_number`	Unknown	PK
`customer_id`	Unknown	PKFK

customer_group

Column	Type	Keys
`customer_group`	Unknown	PK
`customer_id`	Unknown	PKFK

customer_customer_address

Column	Type	Keys
`address_id`	Unknown	PKFK
`customer_id`	Unknown	PKFK

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	PKFK
`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	PKFK
`product_class`	Unknown	PKFK

discount_volume_product_group

Column	Type	Keys
`discount_id`	Unknown	PKFK
`volume_product_group`	Unknown	PKFK

discount_volume_product_class

Column	Type	Keys
`discount_id`	Unknown	PKFK
`volume_product_class`	Unknown	PKFK

discount_volume_modifier_class

Column	Type	Keys
`volume_modifier_class`	Unknown	PK
`discount_id`	Unknown	PKFK

discount_product_group_price

Column	Type	Keys
`discount_id`	Unknown	PKFK
`product_group`	Unknown	PKFK
`price`	Unknown

discount_modifier_class

Column	Type	Keys
`modifier_class`	Unknown	PK
`discount_id`	Unknown	PKFK

discount_product_group

Column	Type	Keys
`discount_id`	Unknown	PKFK
`product_group`	Unknown	PKFK

discount_product_class_price

Column	Type	Keys
`discount_id`	Unknown	PKFK
`product_class`	Unknown	PKFK
`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	PKFK
`order_item_id`	Unknown	PKFK

order_item_ingredient

Column	Type	Keys
`ingredient_item`	Unknown	PK
`order_item_id`	Unknown	PKFK

order_item_commission_commission

Column	Type	Keys
`commission_id`	Unknown	PKFK
`order_item_id`	Unknown	PKFK

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	PKFK
`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	PKFK

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	PKFK

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