d

Tables (6)

book_page

  • 도서고유번호 (BOOK_ID) — NUMBER — Primary key — NOT NULL
  • 장르코드 (BOOK_GENER_ID) — NUMBER — Foreign key → gener_page.장르코드 — NOT NULL
  • 도서명 (BOOK_NAME) — VARCHAR2(50) — NOT NULL
  • ISBN13코드 (ISBN13_ID) — NUMBER — NOT NULL
  • 저자 (BOOK_WRITER) — VARCHAR2(50) — NOT NULL
  • 출판사 (BOOK_PUBLISHER) — VARCHAR2(50) — NOT NULL
  • 가격 (BOOK_PRICE) — NUMBER — NOT NULL
  • 도서소개 (BOOK_INTRODUCE) — VARCHAR2(50) — NOT NULL
  • 목차 (BOOK_INDEX) — NUMBER — NOT NULL
  • 대표리뷰 (BOOK_REVIEW) — VARCHAR2(50) — NOT NULL
  • 재고 (BOOK_STOCK) — NUMBER — NOT NULL

gener_page

  • 장르코드 (BOOK_GENER_ID) — NUMBER — Primary key — NOT NULL
  • 장르명 (BOOK_GENER_NAME) — VARCHAR2(50) — NOT NULL

member

  • 회원고유아이디 (MEMBER_ID) — VARCHAR2(50) — Primary key — NOT NULL
  • 이름 (MEMBER_NAME) — VARCHAR2(50) — NOT NULL
  • 주민번호 (MEMBER_RESIDENT_NUMBER) — VARCHAR2(50) — NOT NULL
  • 전화번호 (MEMBER_PHONE_NUMBER) — VARCHAR2(50) — NOT NULL
  • 우편번호 (MEMBER_POST_NUMBER) — NUMBER — NOT NULL
  • 주소 (MEMBER__ADD) — VARCHAR2(50) — NOT NULL
  • 가입일 (MEMBER_SUBSCRIPTION) — DATE — NOT NULL

order_page

  • 주문번호 (ORDER_NUMBER) — NUMBER — Primary key — NOT NULL
  • 회원고유아이디 (MEMBER_ID) — VARCHAR2(50) — Foreign key → member.회원고유아이디 — NOT NULL
  • 도서고유번호 (BOOK_ID) — NUMBER — Foreign key → book_page.도서고유번호 — NOT NULL
  • 배송지 (SHIPPING_ADD) — VARCHAR2(50) — NOT NULL
  • 배송상태 (DELIVERY_STATE) — VARCHAR2(50) — NOT NULL
  • 결제일 (ORDER_DATE) — DATE — NOT NULL
  • 주문금액 (ORDER_PRICE) — NUMBER — NOT NULL

point_page

  • 포인트잔액 (POINT) — NUMBER — Primary key — NOT NULL
  • 회원고유아이디 (MEMBER_ID) — VARCHAR2(50) — Foreign key → member.회원고유아이디 — NOT NULL
  • 포인트적립 (POINT_SAVE) — NUMBER — NOT NULL

review_page

  • 리뷰고유번호 (REVIEW_ID) — NUMBER — Primary key — NOT NULL
  • 도서고유번호 (BOOK_ID) — NUMBER — Foreign key → book_page.도서고유번호 — NOT NULL
  • 회원고유아이디 (MEMBER_ID) — VARCHAR2(50) — Foreign key → member.회원고유아이디 — NOT NULL
  • 리뷰내용 (REVIEW_TEXT) — VARCHAR2(100) — NOT NULL