포트폴리오용

테이블 (7)

cart

  • cart_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL

category

  • category_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(30) — NOT NULL

product

  • product_id — INT — 기본 키 — NOT NULL
  • category_id — INT — 외래 키 → category.category_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • detail — VARCHAR(1000)
  • price — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • is_delelted (is_deleted) — BOOLEAN

product_image

  • product_image_id — INT — 기본 키 — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL
  • image_url — VARCHAR(100)
  • display_order — INT — NOT NULL
  • is_thumbnail — BOOLEAN — NOT NULL

purchase_history

  • history_id (Key) — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL
  • price (Field) — INT
  • bought_at (Field2) — TIMESTAMP
  • imp_uid (Field3) — VARCHAR(30)

user

  • user_id — INT — 기본 키 — NOT NULL
  • login_id — VARCHAR(15) — NOT NULL
  • password — VARCHAR(150) — NOT NULL
  • name — VARCHAR(15) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • role — ENUM('ROLE_USER', 'ROLE_ADMIN') — NOT NULL
  • is_withdraw — BOOLEAN — NOT NULL

wishlist

  • wishlist_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → user.user_id — NOT NULL
  • product_id — INT — 외래 키 → product.product_id — NOT NULL
  • is_wishlisted — BOOLEAN — NOT NULL