mydb

Tables (5)

Cart (Untitled3)

  • cart_id (Key) — Primary key — NOT NULL
  • User_id (Key2) — Foreign key → User.User_id — NOT NULL
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL
  • quantity (Field)

Order (Untitled4)

  • order_id (Key) — Primary key — NOT NULL
  • total_price (Field)
  • created_at (Field2)
  • User_id (Key2) — Foreign key → User.User_id — NOT NULL

Product (Untitled2)

  • product_id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • stock (Field3)

User (Untitled)

  • User_id (Key) — Primary key — NOT NULL
  • login_id (Field)
  • password (Field2)

order_item (Untitled5)

  • order_item_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → Order.order_id — NOT NULL
  • product_id (Key3) — Foreign key → Product.product_id — NOT NULL
  • quantity (Field)
  • price (Field2)