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 (우편번호)