SP

Tables (8)

ADDRESS (배송지)

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

COMMENT (댓글)

  • COMMENTNUM (댓글번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT NUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCT NUM — NOT NULL
  • ID (아이디) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • PRODUCTJUMSU (평점) — NUMBER(2.1)
  • CREATIONDATA (작성날짜) — VARCHAR2(50)
  • WRITER (작성자) — VARCHAR2(50)
  • DETAIL (내용) — CLOB

MEMBER (회원)

  • ID (아이디) — VARCHAR2(50) — Primary key — NOT NULL
  • PW (비밀번호) — NUMBER(50)
  • NAME (이름) — VARCHAR2(50)
  • PHONE (전화번호) — VARCHAR2(50)
  • EMAIL (이메일) — VARCHAR2(50)

MEMBER_ROLE (멤버권한)

  • ID (아이디) — VARCHAR2(50) — Foreign key → MEMBER.ID — NOT NULL
  • ANUM (권한번호) — NUMBER — Foreign key → ROLE.ANUM — NOT NULL

PRODUCT (상품들)

  • PRODUCT NUM (상품번호) — NUMBER — Primary key — NOT NULL
  • PRODUCTNAME (상품명) — VARCHAR2(50)
  • PRODUCTDETAIL (제품설명) — CLOB
  • PRODUCTJUMSU (평점) — NUMBER(2.1)

PRODUCTOPTION (상품옵션)

  • OPTIONNUMBER (옵션번호) — NUMBER — Primary key — NOT NULL
  • PRODUCT NUM (상품번호) — NUMBER — Foreign key → PRODUCT.PRODUCT NUM — NOT NULL
  • OPTION NAME (옵션명) — VARCHAR2(50)
  • OPTION PRICE (옵션가격) — NUMBER(50)
  • OPTION INVENTORY (옵션재고) — NUMBER

ROLE (권한)

  • ANUM (권한번호) — NUMBER — Primary key — NOT NULL
  • ANAME (권한이름) — VARCHAR2(50)

Untitled (장바구니)

  • Key (번호) — Primary key — NOT NULL
  • Field (옵션)
  • Field2 (제품명)
  • Field3 (옵션수량)
  • Field4 (옵션가격)
  • Field5 (총가격)