mutasa-vac-session1

Tables (4)

carts (Untitled3)

  • cart_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id (Key2) — BIGINT — Foreign key → users.user_id — NOT NULL

carts_products (Untitled4)

  • carts_products_id (Key3) — BIGINT — Primary key — NOT NULL
  • cart_id (Key) — BIGINT — Foreign key → carts.cart_id — NOT NULL
  • product_id (Key2) — BiGINT — Foreign key → products.product_id — NOT NULL
  • quantity (Field) — BIGINT

products (Untitled)

  • product_id (Key) — BiGINT — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • price (Field2) — FLOAT
  • description (Field3) — TEXT
  • stock (Field4) — BIGINT

users (Untitled2)

  • user_id (Key) — BIGINT — Primary key — NOT NULL
  • username (Field) — VARCHAR(50)
  • password (Field2) — VARCHAR(50)