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