쇼핑몰ERD

테이블 (6)

big_category

  • categoryNum — int — 기본 키 — NOT NULL
  • categoryName — varchar(20) — NOT NULL

cart

  • cart_id — int — 기본 키 — NOT NULL
  • product_id — int — 외래 키 → product.product_id — NOT NULL
  • product_cnt — int — NOT NULL
  • user_id — varchar(20) — NOT NULL

category

  • categoryNum — int — 기본 키 — NOT NULL
  • categoryDetail — varchar(20) — NOT NULL
  • bigCategoryNum — int — 외래 키 → big_category.categoryNum — NOT NULL

order1

  • order_id — int — 기본 키 — NOT NULL
  • user_id — varchar(20) — NOT NULL
  • order_date — datetime — NOT NULL
  • receiver_name — varchar(20) — NOT NULL
  • receiver_phone — varchar(20) — NOT NULL
  • receiver_id — varchar(100) — NOT NULL
  • addr1 — varchar(100) — NOT NULL
  • addr2 — varchar(100) — NOT NULL
  • addr3 — varchar(100) — NOT NULL
  • total_price — int — NOT NULL

order_detail

  • order_id — int — 외래 키 → order1.order_id — NOT NULL
  • product_id — int — 외래 키 → product.product_id — NOT NULL
  • ordered_cnt — int — NOT NULL
  • order_status — varchar(10) — NOT NULL
  • refundCheck_YN — varchar(1) — NOT NULL

product

  • product_id — int — 기본 키 — NOT NULL
  • product_name — varchar(100) — NOT NULL
  • product_price — int — NOT NULL
  • category1 — int — NOT NULL
  • category2 — int — 외래 키 → category.categoryNum — NOT NULL
  • detail — int — NOT NULL
  • product_img — varchar(500) — NOT NULL
  • product_cnt — int — NOT NULL