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