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)