뉴 커머스

테이블 (3)

detail_item

  • item_code — varchar2(50) — 기본 키 — NOT NULL
  • item_title — varchar2(50)
  • item_content — varchar2(3000)
  • item_image1 — varchar2(1000)
  • item_image2 — varchar2(1000)
  • item_image3 — varchar2(1000)
  • item_image4 — varchar2(1000)

item

  • item_code — varchar2(50) — 기본 키 — NOT NULL
  • item_category — varchar2(50)
  • item_name — varchar2(50) — NOT NULL
  • item_price — number
  • item_id — varchar2(50)
  • item_code (item_code2) — varchar2(50) — 외래 키 → detail_item.item_code — NOT NULL

member

  • id — varchar2(50) — 기본 키 — NOT NULL
  • password — varchar2(100)
  • nickname — varchar2(100)
  • email — varchar2(100)
  • name — varchar2(50)
  • address — varchar2(100)
  • grade — varchar2(50)
  • item_code — varchar2(50) — 외래 키 → item.item_code — NOT NULL