Data Structure

All new Menus and Dishes will default to "draft mode" (unpublished).

Menu
A published menu is official, set-in-stone, locked, done. A published menu must be 100% done.

Dish

• A draft dish can not be added to a draft menu.

• A published dish is available for adding to a draft menu.

• An archived dish is no longer available for adding or editing.

• A dish may be edited as long as it is not locked.

• When a Menu is published, all dishes associated with that menu become locked. The menu also becomes locked.

• A published locked or unlocked dish can be copied. It becomes a draft, and unlocked.

**Note:** _Italic Indicates For Later_

• User

  • pk_User
  • deleted
  • deleted_on
  • created
  • modified

• Order

  • pk_Order
  • fk_User
  • created
  • modified
  • status [queued, en route, delivered]
  • fk_Coupon
  • pre_coupon_total
  • coupon_discount
  • tax
  • delivery_fee
  • total

• Coupon

  • pk_Coupon
  • code
  • description

• Order_Item

  • pk_Order_Item
  • fk_Order
  • fk_item
  • item_type [BentoBoxOrder, BentoBox]

• BentoBoxOrder: This is used for customer defined bento boxes.

  • pk_BentoBoxOrder
  • fk_Order
  • created

• BentoBoxOrder_Item

  • pk_BentoBoxItem
  • fk_BentoBoxOrder
  • fk_item
  • item_type: Defaults to Dish. Later on we could create other objects to include in a BentoBox.

• BentoBox: This is used for our own pre-defined bento boxes.

  • pk_BentoBox
  • created
  • name
  • description
  • published_on
  • modified
  • locked
  • archived
  • archived_on
  • price
  • image1
  • image2

• BentoBox_Item

  • pk_BentoBoxItem
  • fk_BentoBox
  • fk_item
  • item_type: Defaults to Dish. Later on we could create other objects to include in a BentoBox.

• Driver

  • pk_Driver
  • status
  • created
  • modified
  • firstname
  • lastname
  • mobile_phone

• DriverInventoryPoint: This driver, with this inventory, at this time. A data point. This should be graph-able.

  • pk_DriverInventoryPoint
  • fk_Driver
  • fk_item
  • item_type (defaults to Dish)
  • timestamp
  • amount
  • change_reason [initial_load, reload, delivery]

• Menu

  • pk_Menu
  • parent_pk_Menu (Used if you copy a menu.)
  • created
  • modified
  • published
  • published_on
  • deleted (only draft menus can be deleted)
  • deleted_on
  • for_date
  • locked
  • name
  • i_notes

• Dish (An individual item that would go onto a plate.)

  • pk_Dish
  • parent_pk_Dish (Used if copied.)
  • created
  • modified
  • published
  • published_on
  • archived
  • archived_on
  • locked
  • name
  • short_name
  • description
  • type [main, side]
  • price
  • label
  • temp [hot, cold]
  • image1
  • image2
  • max_per_order
  • ingredients (text)
  • preparation (text)
  • unit_cost (defaults to 6.00)
  • i_notes

• Menu_Item

  • pk_Menu_Dish
  • fk_Menu
  • fk_item
  • item_type [Dish, BentoBox]
  • deleted
  • published
  • created
  • modified

• Kitchen_CookedItem

  • pk_Kitchen_CookedItem
  • fk_item
  • item_type [Dish, BentoBox]
  • date
  • amount
  • i_notes