Snack-bar

Tables (6)

Untitled (menu)

  • Key (idx) — Primary key — NOT NULL
  • Key (category_sub_idx) — Foreign key → Untitled.Key — NOT NULL
  • Field (menu_name)
  • Field (menu_price)
  • Field (menu_image)
  • Field (menu_content)
  • Field (register_date)
  • Field (modify_date)

Untitled (category_main)

  • Key (idx) — Primary key — NOT NULL
  • Field (category_name)
  • Field (is_use)

Untitled (member)

  • Key (idx) — Primary key — NOT NULL
  • Field (id)
  • Field (password)
  • Field (nick_name)
  • Field (register_date)
  • Field (modify_date)
  • Field (authority)

Untitled (menu_category)

  • Key (idx) — Primary key — NOT NULL
  • Key (menu_idx) — Foreign key → Untitled.Key — NOT NULL
  • Key (category_sub_idx) — Foreign key → Untitled.Key — NOT NULL

Untitled (category_sub)

  • Key (idx) — Primary key — NOT NULL
  • Key (category_main_idx) — Foreign key → Untitled.Key — NOT NULL
  • Field (category_name)
  • Field (is_use)

Untitled (menu_order)

  • Key (idx) — Primary key — NOT NULL
  • Key (member_idx) — Foreign key → Untitled.Key — NOT NULL
  • Key (menu_idx) — Foreign key → Untitled.Key — NOT NULL
  • Key (idx2) — Foreign key → Untitled.Key — NOT NULL
  • Field (menu_name)
  • Field (menu_price)
  • Field (order_quantity)
  • Field (order_time)