커머스

테이블 (4)

Cart (Untitled3)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • user_id (FK) — BIGINT — 외래 키 → User.id — NOT NULL

CartItem (Untitled4)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • cart_id (FK) — BIGINT — 외래 키 → Cart.user_id — NOT NULL
  • product_id (Fk) — BIGINT — 외래 키 → Product.id — NOT NULL
  • quantity (Field2) — INT

Product (Untitled)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • name (Field) — VARCHAR
  • price (Field2) — INT
  • stock (Field3) — INT
  • created_at (Field4) — DATETIME

User (Untitled2)

  • id (PK) — BIGINT — 기본 키 — NOT NULL
  • username (UN) — VARCHAR
  • password (Field) — VARCHAR
  • role (Field2) — VARCHAR
  • created_at (Field3) — DATETIME