shoppingmall

Tables (4)

cart_product (Untitled4)

  • cart_product_id (Key) — Long — Primary key — NOT NULL
  • count (Field2) — Int

product (Untitled3)

  • product_id (Key) — Primary key — NOT NULL
  • product_name (Field2) — String
  • price (Field3) — Double
  • description (Field) — String
  • cart_product_id (Key2) — Long — Foreign key → cart_product.cart_product_id — NOT NULL

shopping_cart (Untitled2)

  • cart_id (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → users.user_id — NOT NULL
  • cart_product_id (Key3) — Long — Foreign key → cart_product.cart_product_id — NOT NULL

users (Untitled)

  • user_id (Key) — Long — Primary key — NOT NULL
  • email (Field2) — String
  • name (Field3) — String