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 (등급이름)