쇼핑몰 erd

테이블 (4)

cart (Untitled2)

  • cart_id (Key) — BIGINT — 기본 키 — NOT NULL
  • quantity (Field) — INT
  • product_id (Key2) — BIGINT — 외래 키 → product.product_id — NOT NULL
  • customer_id (Key3) — BIGINT — 외래 키 → customer.customer_id — NOT NULL

customer (Untitled)

  • customer_id (Key) — BIGINT — 기본 키 — NOT NULL
  • email (Field) — VARCHAR(255)
  • name (Field2) — VARCHAR(255)
  • password (Field3) — VARCHAR(255)
  • addr (Field4) — VARCHAR(255)

orders (Untitled4)

  • order_id (Key) — BIGINT — 기본 키 — NOT NULL
  • order_date (Field) — DATETIME — NOT NULL
  • order_status (Field2) — VARVHAR(255) — NOT NULL
  • quantity (Field3) — INT
  • product_id (Key2) — BIGINT — 외래 키 → product.product_id — NOT NULL
  • customer_id (Key4) — BIGINT — 외래 키 → customer.customer_id — NOT NULL

product (Untitled3)

  • product_id (Key) — BIGINT — 기본 키 — NOT NULL
  • category (Field) — VARCHAR(255) — NOT NULL
  • description (Field2) — VARCHAR(255)
  • name (Field3) — VARCHAR(255)
  • price (Field4) — INT — NOT NULL
  • stock (Field5) — INT — NOT NULL