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 (총가격)