wanted

Tables (5)

menu (Untitled4)

  • menu_id — NOT NULL — Primary key — NOT NULL
  • store_id (Key) — NOT NULL — Foreign key → store.store_id — NOT NULL
  • menu_name — NOT NULL
  • menu_price — NOT NULL
  • menu_state (menu_stat) — NOT NULL

order (Untitled3)

  • order_id (Key) — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • order_price — NOT NULL
  • order_request — NULL
  • order_state — NOT NULL

order_detail (Untitled5)

  • order_detail_id — NOT NULL — Primary key — NOT NULL
  • order_id (Key) — NOT NULL — Foreign key → order.order_id — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • menu_id — NOT NULL — Foreign key → menu.menu_id — NOT NULL
  • order_detail_quantity — NOT NULL

store (Untitled)

  • store_id (Key) — NOT NULL — Primary key — NOT NULL
  • store_name — NOT NULL
  • store_address — NOT NULL
  • store_time — NOT NULL
  • store_phone — NOT NULL
  • store_content — NULL

user (Untitled2)

  • user_id — NOT NULL — Primary key — NOT NULL
  • user_name — NOT NULL
  • user_email — NOT NULL
  • password — NOT NULL
  • user_address — NOT NULL