edd2
Tables (16)
AD (Untitled14)
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
- AD_EMAIL (메일광고) — NUMBER(1)
- AD_PHONE (문자광고) — NUMBER(1)
- AD_CALL (전화광고) — NUMBER(1)
CART (Untitled8)
- CTNO (장바구니 번호) — NUMBER(6) — Primary key — NOT NULL
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
- PCODE (상품 번호) — VARCHAR(30) — Foreign key → PRODUCT.PCODE — NOT NULL
- PCNT (구매수량) — NUMBER(6)
COUPON (Untitled)
- CONO (순차번호) — NUMBER(6) — Primary key — NOT NULL
- CNAME (쿠폰명) — VARCHAR(100)
- CCONDITION (쿠폰 조건) — VARCHAR(100)
- CDISPER (쿠폰할인율) — NUMBER(3)
- CDISCASH (쿠폰할인) — NUMBER(9)
- CORDATE (쿠폰생성일) — DATE
- CVALIDITY (쿠폰유효기간) — NUMBER(6)
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
CSMG_COMMENT (Untitled9)
- CSNO (순차) — NUMBER(6) — Primary key — NOT NULL
- CMSUBJECT (답글제목) — VARCHAR2(100)
- CMCONTENT (답글내용) — VARCHAR2(4000)
- CMRDATE (답글작성일) — DATE
- CNO (문의 번호) — NUMBER(6) — Foreign key → CUSTOMER_SERVICE.CNO — NOT NULL
- MGID (매니저 아이디) — VARCHAR(30) — Foreign key → MANAGER.MGID — NOT NULL
CUSTOMER_SERVICE (Untitled2)
- CNO (문의 번호) — NUMBER(6) — Primary key — NOT NULL
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
- CSUBJECT (글 제목) — VARCHAR(100)
- CCONTENT (글 내용) — VARCHAR(4000)
- CSECRET (글비밀여부) — NUMBER(10)
- CIMAGE (글 이미지) — VARCHAR(30)
- CHIT (고객게시판조회수) — NUMBER(6)
- CGROUP (답글위한 그룹) — NUMBER(6)
- CGROUP_OUTNUM (글 순서) — NUMBER(6)
- CINDENT (답글여백) — NUMBER(6)
- CRDATE (글작성일) — DATA
- ONO (주문번호) — VARCHAR(30)
DELIVERY (Untitled13)
- DNO (배송번호) — NUMBER(6) — Primary key — NOT NULL
- DNAME (수령인) — VARCHAR(30)
- DPHONE (배송지연락처) — VARCHAR(30)
- DPRICE (배송가격) — NUMBER(6)
- DCOMPANY (배송업체) — VARCHAR(30)
- DADDRESS (배송주소) — VARCHAR(100)
- ODATE (주문일자) — DATE
- PARRIVE_DATE (물품수령일) — DATE
GRADES (Untitled16)
- GNO (회원등급) — NUMBER(1) — Primary key — NOT NULL
- GNAME (등급명) — VARCHAR(30)
- LOWGRADE (최고구매) — NUMBER(9)
- HIGHGRADE (최대구매) — NUMBER(9)
MANAGER (Untitled10)
- MGID (매니저 아이디) — VARCHAR(30) — Primary key — NOT NULL
- MGPW (매니저 비밀번호) — VARCHAR(30)
- MGNAME (매니저 이름) — VARCHAR(30)
- MGPARTNAME (부서명) — VARCHAR(30)
MEMBER (Untitled3)
- MID (아이디) — VARCHAR(30) — Primary key — NOT NULL
- MPW (비밀번호) — VARCHAR(30)
- MNAME (이름) — VARCHAR(30)
- MPHONE (전화번호) — VARCHAR(30)
- MADDRESS_BASIC (기본주소) — VARCHAR(100)
- MADDRESS_DETAIL (상세주소) — VARCHAR(100)
- MBIRTH (생일) — DATE
- MEMAIL (이메일) — VARCHAR(100)
- MGENDER (성별) — VARCHAR2(30)
- MPOINT (고객포인트) — NUMBER(9)
- MCUMULATIVE_BUY (누적구매금액) — NUMBER(9)
- MSTATUS (회원탈퇴) — NUMBER(1)
- MJOINDATE (가입일) — DATE
- MSTATUS (탈퇴여부) — NUMBER(1)
ORDERS (Untitled4)
- ONO (주문번호) — NUMBER(6) — Primary key — NOT NULL
- ODATE (주문일자) — DATE
- PARRIVE_DATE (물품수령일) — DATE
- PURCHASE_AMOUNT (주문금액) — NUMBER(9)
- DNO (배송번호) — NUMBER(6) — Foreign key → DELIVERY.DNO — NOT NULL
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
ORDER_DETAIL (Untitled7)
- ODNO (주문순차 번호) — NUMBER(6) — Primary key — NOT NULL
- PCNT (구매수량) — NUMBER(6)
- PPRICE (상품단가) — NUMBER(9)
- ONO (주문번호) — NUMBER(6) — Foreign key → ORDERS.ONO — NOT NULL
- PCODE (상품 번호) — VARCHAR(30) — Foreign key → PRODUCT.PCODE — NOT NULL
PAYMENT (Untitled5)
- PANO (순차번호) — NUMBER(6) — Primary key — NOT NULL
- ONO (주문번호) — NUMBER(6) — Foreign key → ORDERS.ONO — NOT NULL
- PRODUCT_ALL_PAY (주문금액) — NUMBER(9)
- DISCOUNT (즉시할인) — NUMBER(9)
- COUPONDISCOUNT (쿠폰할인) — NUMBER(9)
- USEPOINT (사용포인트) — NUMBER(9)
- PURCHASE_AMOUNT (결제금액) — NUMBER(9)
PRODUCT (Untitled6)
- PCODE (상품 코드) — VARCHAR(30) — Primary key — NOT NULL
- MGID (매니저 아이디) — VARCHAR(30) — Foreign key → MANAGER.MGID — NOT NULL
- PNAME (상품 이름) — VARCHAR(30)
- PPRICE (상품 가격) — NUMBER(9)
- PIMAGE (상품 사진) — VARCHAR(30)
- PSTOCK (재고) — NUMBER(6)
- PDESCRIPTION (상품설명) — VARCHAR(1000)
- PDISCOUNT (할인율) — NUMBER(3)
- PREGIST (상품등록일) — DATE
- PCUMULATIVE_SALES (누적 판매량) — NUMBER(6)
- PREVIEW_COUNT (상품리뷰 수) — NUMBER(6)
- PRATING (평점) — NUMBER((5)
REVIEW (Untitled12)
- RNO (리뷰 번호) — NUMBER(6) — Primary key — NOT NULL
- PCODE (상품 코드) — VARCHAR(30) — Foreign key → PRODUCT.PCODE — NOT NULL
- MID (아이디) — VARCHAR(30) — Foreign key → MEMBER.MID — NOT NULL
- RIMAGE1 (첨부파일1) — VARCHAR(30)
- RIMAGE2 (첨부파일2) — VARCHAR(30)
- RIMAGE3 (첨부파일3) — VARCHAR(30)
- RGOOD (좋아요 수) — NUMBER(6)
- RSTAR (별점) — NUMBER(6)
- RCONTENT (리뷰내용) — VARCHAR(4000)
- RDATE (작성일자) — DATE
- RCEXIST (댓글여부) — NUMBER(6)
REVIEW_COMMENT (Untitled11)
- RCNO (리뷰댓글번호) — NUMBER(6) — Primary key — NOT NULL
- MGID (매니저아이디) — VARCHAR(30) — Foreign key → MANAGER.MGID — NOT NULL
- RCCONTENT (댓글내용) — VARCHAR(4000)
- RCDATE (댓글쓴날짜) — DATE
- RNO (리뷰 번호) — NUMBER(6) — Foreign key → REVIEW.RNO — NOT NULL
REVIEW_RGOOD (Untitled15)
- RGNO (순차번호) — NUMBER(6) — Primary key — NOT NULL
- MID (아이디) — VARCHAR(30)
- RNO (리뷰 번호) — NUMBER(6) — Foreign key → REVIEW.RNO — NOT NULL