쇼핑몰

테이블 (6)

BASKET

  • b_num — INT — 기본 키 — NOT NULL
  • id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
  • p_num — INT — 외래 키 → PRODUCT.p_num — NOT NULL
  • b_quantity — INT — NOT NULL
  • b_rgst_date — DATE — NOT NULL

MEMBER

  • id — VARCHAR(50) — 기본 키 — NOT NULL
  • pw — VARCHAR(50) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • address — VARCHAR(200) — NOT NULL
  • cp — INT — NOT NULL
  • admin — CHAR — NOT NULL
  • del — CHAR — NOT NULL
  • rgst_date — DATE — NOT NULL

ORDERS

  • o_num — INT — 기본 키 — NOT NULL
  • id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
  • o_rgst_date — DATE — NOT NULL

ORDER_DETAIL

  • od_num — INT — 기본 키 — NOT NULL
  • o_num — INT — 외래 키 → ORDERS.o_num — NOT NULL
  • p_num — INT — 외래 키 → PRODUCT.p_num — NOT NULL
  • od_quantity — INT — NOT NULL
  • od_result — CHAR — NOT NULL

PRODUCT

  • p_num — INT — 기본 키 — NOT NULL
  • p_name — VARCHAR(100) — NOT NULL
  • p_category — CHAR — NOT NULL
  • p_cost — INT — NOT NULL
  • p_price — INT — NOT NULL
  • p_con — VARCHAR(3000) — NOT NULL
  • p_image — VARCHAR(3000) — NOT NULL
  • p_view_count — INT — NOT NULL
  • p_delete — CHAR — NOT NULL
  • p_rgst_date — DATE — NOT NULL

REVIEW

  • r_num — INT — 기본 키 — NOT NULL
  • id — VARCHAR(50) — 외래 키 → MEMBER.id — NOT NULL
  • od_num — INT — 외래 키 → ORDER_DETAIL.od_num — NOT NULL
  • r_title — VARCHAR(100) — NOT NULL
  • r_content — VARCHAR(3000) — NOT NULL
  • r_image — VARCHAR(3000) — NOT NULL
  • r_starrate — INT — NOT NULL
  • r_delete — CHAR — NOT NULL
  • r_rgst_date — DATE — NOT NULL