Out-Of-Print bookstore
테이블 (9)
Address (address)
- 배송지고유번호 (addrKey) — INT — 기본 키 — NOT NULL
- 회원고유번호 (custKey) — INT — 외래 키 → 회원 정보.Member ID — NOT NULL
- Name (name) — VARCHAR(15) — NOT NULL
- Contact (tel) — VARCHAR(15) — NOT NULL
- Postcode (postcode) — VARCHAR(6) — NOT NULL
- Address 1 (addr) — VARCHAR(300) — NOT NULL
- Address 2 (addrDetail) — VARCHAR(100) — NOT NULL
- Default Shipping Address Status (default) — CHAR
관리자 정보 (admin)
- Admin ID (adminKey) — INT — 기본 키 — NOT NULL
- ID (userid) — VARCHAR(15) — NOT NULL
- Name (username) — INT(15) — NOT NULL
- Password (userpwd) — VARCHAR(150) — NOT NULL
구매희망도서정보 (buyerBook)
- Bid ID (itemBuyKey) — INT — 기본 키 — NOT NULL — PK(Book Wanted)
- Member ID (custKey) — INT — 외래 키 → 회원 정보.Member ID — NOT NULL
- Title (itemTitle) — VARCHAR(30) — NOT NULL
- Author (author) — VARCHAR(20) — NOT NULL
- Publisher (publisher) — VARCHAR(20) — NOT NULL
- bid deadline (expiry) — INT — NOT NULL
- Auction Status (aucStatus) — INT — NOT NULL — Successful Bid(1)//Ongoing(2)/Expired(3)/Canceled(삭제)
문의 (enquiry)
- Review ID (boardKey) — INT — 기본 키 — NOT NULL
- Member ID (custKey) — INT — NOT NULL
- Date (date) — INT — NOT NULL
- Title (boardTitle) — VARCHAR(100) — NOT NULL
- Enquiry — VARCHAR(400) — NOT NULL
문의 답변 (reply)
- Comment ID (replayKey) — INT — 기본 키 — NOT NULL
- Review ID (boardKey) — INT — 외래 키 → 문의.Review ID — NOT NULL
- Admin ID (adminKey) — INT — 외래 키 → 관리자 정보.Admin ID — NOT NULL
- Date (date) — INT — NOT NULL
- Reply (reply) — VARCHAR(400) — NOT NULL
주문 (order)
- Order ID (itemKey) — INT — 기본 키 — NOT NULL — PK(Order ID)
- Sale ID (itemSellKey) — INT — 외래 키 → 판매도서정보.Sale ID — NOT NULL — FK(Book for Sale)
- Price (price) — VARCHAR(10) — NOT NULL
- Name (name) — VARCHAR(15) — NOT NULL — Recipient
- Contact (tel) — VARCHAR(15) — NOT NULL — Recipient's Mobile Number
- Postcode (postcode) — VARCHAR(6) — NOT NULL
- Address1 (addr) — VARCHAR(300) — NOT NULL — Recipient's Address
- Address2 (addrDetail) — VARCHAR(100) — NOT NULL
판매도서정보 (sellerBook)
- Sale ID (itemSellKey) — INT — 기본 키 — NOT NULL — PK(Book for Sale)
- Bid ID (itemBuyKey) — INT — 외래 키 → 구매희망도서정보.Bid ID — NOT NULL — FK(Book Wanted)
- Member ID (custKey) — INT — 외래 키 — NOT NULL — Buyer
- Book Image (itemImg) — VARCHAR(600) — NOT NULL
- Book Condition (damage) — INT — NOT NULL — Checklist Count Rating (0: Excellent, 1: Good, 2-3: Fair)
- Date (date) — INT — NOT NULL — Registration Date
- Bid Price (price) — INT(8) — NOT NULL
회원 정보 (customers)
- Member ID (custKey) — INT — 기본 키 — NOT NULL
- ID (userid) — VARCHAR(15) — NOT NULL
- Email (email) — VARCHAR(50) — NOT NULL
- Password (userpwd) — VARCHAR(150) — NOT NULL
- Nickname (nickname) — VARCHAR(15) — NOT NULL
- Age (age) — INT(3)
- Gender (gender) — CHAR
- Contact (contact) — INT(11) — NOT NULL
- Seller Grade (grade) — INT(2)
- Seller Point (point) — INT(3) — Average( Grade 1:4~5 points/Grade 2:3~4/Grade3 :2~3/Grade 4:1~2/Grade 5:0~1)
후기 (review)
- Review ID (reviewKey) — INT — 기본 키 — NOT NULL
- Order ID (itemKey) — INT — 외래 키 → 주문.Order ID — NOT NULL
- Condition Rating (satisfaction) — INT — NOT NULL — 1~5 points
- Re-transaction Score (repurchase) — INT — NOT NULL — 1~5 points
- Review (review) — VARCHAR(400)