mydb

Tables (6)

Cart (Untitled6)

  • cart_id (Key) — INT(10) — Primary key — NOT NULL
  • user_id (Field) — INT(20)
  • store_id (Field2) — INT(20)
  • menu_id (Field3) — INT(20)
  • menu_name (Field4) — VARCHAR(20)
  • menu_qty (Field5) — INT(10)
  • menu_price (Field6) — INT(30)
  • last_modify (Field7) — DATETIME
  • created_at (Field8) — DATETIME

Menu (Untitled4)

  • menu_id (Key) — INT(20) — Primary key — NOT NULL
  • store_id (Key2) — INT(20) — Foreign key → Store.store_id — NOT NULL
  • menu_name (Field) — VARCHAR(20)
  • menu_price (Field2) — INT(30)
  • menu_img (Field5) — VARCHAR(50)
  • last_modify (Field3) — DATETIME
  • created_at (Field4) — DATETIME

Order_details (Untitled5)

  • order_detail_id (Key) — INT(10) — Primary key — NOT NULL
  • order_id (Key2) — INT(20) — Foreign key → Orders.order_id — NOT NULL
  • user_id (Key22) — INT(20) — Foreign key → Orders.user_id — NOT NULL
  • menu_id (Key3) — INT(20) — Foreign key → Menu.menu_id — NOT NULL
  • store_id (Key23) — INT(20) — Foreign key → Menu.store_id — NOT NULL
  • food_qty (Field3) — INT(10)
  • food_price (Field4) — INT(30)
  • last_modify (Field5) — DATETIME
  • created_at (Field) — DATETIME

Orders (Untitled2)

  • order_id (Key) — INT(20) — Primary key — NOT NULL
  • user_id (Key2) — INT(20) — Foreign key → User.user_id — NOT NULL
  • total_qty (Field) — INT(10)
  • total_price (Field2) — INT(30)
  • last_modify (Field3) — DATETIME
  • created_at (Field4) — DATETIME

Store (Untitled3)

  • store_id (Key) — INT(20) — Primary key — NOT NULL
  • store_name (Field) — VARCHAR(20)
  • category (Field2) — VARCHAR(20)
  • last_modify (Field3) — DATETIME
  • created_at (Field4) — DATETIME

User (Untitled)

  • user_id (Key) — INT(20) — Primary key — NOT NULL
  • age_segment (Field) — INT(4)
  • emotion (Field2) — INT(4)
  • sex (Field3) — INT(4)
  • capture_chk (Field6) — CHAR(2)
  • last_modify (Field4) — DATETIME
  • created_at (Field5) — DATETIME