Book

Tables (13)

ADDRESS (주소)

  • ZIPCODE (우편번호) — VARCHAR
  • PROVINCE (구) — VARCHAR
  • ROAD (도로명) — VARCHAR
  • BUILDING (건물명) — VARCHAR
  • OLDADDR (구주소) — VARCHAR

BUYER_INFO (주문정보)

  • BUYER_SEQ (주문번호) — INT — Primary key
  • RECIEVER_ADDR (배송지주소) — VARCHAR
  • RECIEVER_ZIPCODE (배송지우편번호) — VARCAHR
  • RECIEVER_DETAIL_ADDR (배송지 상세주소) — VARCHAR
  • RECEIVER_NAME (수령인이름) — VARCHAR
  • RECIEVER_TELNO (수령인전화번호) — VARCHAR
  • USERID (아이디) — VARCHAR — Foreign key → MEMBER.USERID — NOT NULL

CART (장바구니)

  • CARTID (장바구니번호) — INT — Primary key
  • USERID (아이디) — VARCHAR — Foreign key → MEMBER.USERID — NOT NULL
  • BOOKID (도서번호) — INT — Foreign key → PRODUCT.BOOKID
  • CARTVOLUME (수량) — INT
  • CARTREGDATE (등록일) — DATE

CATEGORY (분류)

  • CATEGORY_SEQ (목록번호) — INT — Primary key
  • CATEGORY_NAME (분류명) — VARCHAR
  • CATEGORY_NUMBER (분류번호) — VARCHAR
  • DEPTH (깊이순서) — INT
  • PARENT (부모) — VARCHAR

DELIVERLY_ADDR (배송지정보)

  • DELIVERLY_SEQ (배송지번호) — INT — Primary key — NOT NULL
  • USERID (아이디) — VARCHAR — Foreign key → MEMBER.USERID — NOT NULL
  • ADDR (주소) — VARCHAR
  • DETTAIL_ADDR (상세주소) — VARCHAR
  • ZIPCODE (우편번호) — VARCHAR
  • NAME (수령인) — VARCHAR
  • MEMO (메모) — VARCHAR
  • TELNO (전화번호) — VARCHAR

MEMBER (회원정보)

  • USERID (아이디) — VARCHAR — Primary key — NOT NULL
  • NICKNAME (별명) — VARCHAR
  • USERNAME (이름) — VARCHAR
  • BIRTHDAY (생년월일) — DATE
  • GENDER (성별) — VARCHAR
  • TELNO (전화번호) — VARCHAR
  • PASSWORD (비밀번호) — VARCHAR
  • REGDATE (가입일) — DATE
  • POINT (포인트) — INT
  • MEMBERCLASS (등급) — VARCHAR
  • PWCHECK (비밀번호 변경확인) — INT
  • LASTLOGINDATE (마지막 로그인 날짜) — DATE
  • LASTLOGOUTDATE (마지막 로그아웃 날짜) — DATE
  • LASTPWDATE (마지막 비밀번호 변경일) — DATE
  • FROMSOCIAL (소셜로그인유무) — VARCHAR
  • ROLE (권한) — VARCHAR
  • INTERESTS (관심분야) — VARCHAR

PRODUCT (책정보)

  • BOOKID (도서번호) — INT — Primary key
  • CATEGORY_SEQ (분류번호) — INT — Foreign key → CATEGORY.CATEGORY_SEQ
  • BOOKNAME (책이름) — VARCHAR
  • PUBLISHER (출판사) — VARCHAR
  • PRICE (원가) — INT
  • STOCK (재고) — INT
  • DESCRIPTION (설명) — VARCHAR
  • COVER (표지이름) — VARCHAR
  • REGDATE (등록일) — DATE
  • ISBN (책고유번호) — VARCHAR
  • STATUS (판매상태) — VARCHAR
  • PUBLICATIONDATE (출판일) — DTAE

PURCHASE_INFO (구매상세정보)

  • PURCHASE_DETAEL_SEQ (구매번호) — INT — Primary key
  • BOOKID (도서번호) — INT — Foreign key → PRODUCT.BOOKID
  • PURCHASEDATE (주문날짜) — DTAE
  • VOLUME (수량) — INT
  • TOTALPRICE (총결제금액) — INT
  • STATUSSEQ (구매상태번호) — INT — Foreign key → PURCHASE_STATUS.STATUS_SEQ
  • BUYER_SEQ (주문번호) — INT — Foreign key → BUYER_INFO.BUYER_SEQ
  • UNMEMBER_SEQ (비회원주문번호) — INT — Foreign key → UNMEMBER_INFO.UNMEMBER_SEQ

PURCHASE_STATUS (주문상태)

  • STATUS_SEQ (주문상태번호) — INT — Primary key
  • STATUS_NAME (주문상태) — VARCHAR

REFUND (환불)

  • REFUND_SEQ (환불번호) — INT — Primary key
  • PURCHASE_DETAEL_SEQ (구매번호) — INT — Foreign key → PURCHASE_INFO.PURCHASE_DETAEL_SEQ
  • REFUND_REASON (환불이유) — VARCHAR

REVIEW (리뷰)

  • REVIEWSEQ (리뷰번호) — INT — Primary key
  • BOOKID (도서번호) — INT — Foreign key → PRODUCT.BOOKID
  • USERID (아이디) — VARCHAR — Foreign key → MEMBER.USERID — NOT NULL
  • REV IEWER (작성자이름) — VARCHAR
  • REVIEWCONTENT (내용) — VARCHAR
  • REVIEWREGDATE (등록일) — DATE

UNMEMBER_INFO (비회원 주문정보)

  • UNMEMBER_SEQ (비회원주문번호) — INT — Primary key
  • PURCHASEDATE (구매날짜) — DATE
  • TOTAL_PRICE (총 구매비용) — INT
  • VOLUME (구매수량) — INT
  • BOOKID (도서번호) — INT — Foreign key → PRODUCT.BOOKID
  • UNMEMBERSEQ (비회원번호) — INT — Foreign key → UnMember.UNMEMBERSEQ — NOT NULL
  • STATUS_SEQ (주문상태번호) — INT — Foreign key → PURCHASE_STATUS.STATUS_SEQ

UnMember (비회원정보)

  • UNMEMBERSEQ (비회원번호) — INT — Primary key — NOT NULL
  • ADDR (주소) — VARCHAR
  • BUYERTELNO (구매자전화번호) — VARCHAR
  • DETAILADDR (상세주소) — VARCHAR
  • RECEIVERNAME (구매자이름) — VARCHAR
  • RECEIVERTELNO (구매자전화번호1) — VARCHAR
  • TEMPPASSWORD (구매자비밀번호) — VARCHAR
  • ZIPCODE (우편번호)