deliveryApp

Tables (5)

menu (Untitled3)

  • menu_id (Key) — LONG — Primary key — NOT NULL
  • menu_name (Field) — VARCHAR
  • price (Field2) — INT
  • store_id (Key2) — LONG — Foreign key → store.store_id — NOT NULL

order (Untitled4)

  • order_id (Key) — LONG — Primary key — NOT NULL
  • ordered_at (Field) — DATETIME
  • order_status (Field2) — VARCHAR
  • menu_id (Key2) — LONG — Foreign key → menu.menu_id — NOT NULL
  • user_id (Key3) — LONG — Foreign key → user.user_id — NOT NULL

review (Untitled5)

  • review_id (Key) — LONG — Primary key — NOT NULL
  • rating (Field) — INT
  • created_at (Field2) — DATETIME
  • content (Field3) — VARCHAR
  • user_id (Key4) — LONG — Foreign key → user.user_id — NOT NULL
  • store_id (Key2) — LONG — Foreign key → store.store_id — NOT NULL
  • order_id (Key3) — LONG — Foreign key → order.order_id — NOT NULL

store (Untitled2)

  • store_id (Key) — LONG — Primary key — NOT NULL
  • store_name (Field) — VARCHAR
  • open_close_time (Field2) — VARCHAR
  • delivery_min_price (Field3) — INT
  • store_status (Field4) — VARCHAR
  • user_id (Key2) — LONG — Foreign key → user.user_id — NOT NULL

user (Untitled)

  • user_id (Key) — LONG — Primary key — NOT NULL
  • user_name (Field) — VARCHAR
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • user_type (Field7) — VARCHAR
  • is_deleted (Field8) — TINYINT(1)