SHOP

Tables (8)

CART (장바구니)

  • Key (장바구니번호) — Primary key — NOT NULL
  • Field (제품명)
  • Field (총가격)

DELIVERY (배송지)

  • DELIVERYNUM (배송지번호) — NUMBER — Primary key — NOT NULL
  • ID (아이디) — VARCHAR2(40) — Foreign key → MEMBER.ID — NOT NULL
  • ADDRESS (주소) — VARCHAR(200)
  • PHONE (전화번호) — VARCHAR2(50)
  • NAME (이름) — VARCHAR2(50)

MEMBER (회원정보)

  • ID (아이디) — VARCHAR2(40) — Primary key — NOT NULL
  • PW (비밀번호) — VARCHAR2(50)
  • NAME (이름) — VARCHAR2(50)
  • PHONE (연락처) — VARCHAR2(50)
  • EMAIL (이메일) — VARCHAR2(100)
  • ADDRESS (Field) — VARCHAR2(100)

MEMBER_ROLE (회원등급)

  • Key (아이디) — Foreign key → MEMBER.ID — NOT NULL
  • Key (등급번호) — Foreign key → ROLE.Key — NOT NULL

PRODUCT (상품들)

  • PRODUCTNUM (상품번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNAME (상품명) — VARCHAR2(200)
  • PRODUCTDETAIL (제품설명) — CLOB
  • PRODUCTJUMSU (평점) — NUMBER(2,1)

PRODUCTOPTION (상품옵션)

  • OPTIONNUM (옵션번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • OPTIONNAME (옵션명) — VARCHAR2(20)
  • OPTIONPRICE (옵션가격) — NUMBER
  • OPTIONSTOCK (옵션재고) — NUMBER

REVIEW (후기)

  • REVIEWNUM (리뷰번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCTNUM — NOT NULL
  • PRODUCTWRITER (작성자) — VARCHAR2(40) — Foreign key → MEMBER.ID — NOT NULL
  • REVIEWJUMSU (평점) — NUMBER(2,1)
  • REVIEWDATE (작성날짜) — DATE
  • REVIEWDESC (내용) — CLOB

ROLE (등급)

  • Key (등급번호) — Primary key — NOT NULL
  • Field (등급이름)