DreamBook

Tables (9)

BankAccount

  • AccountID — INT — “은행계좌ID”
  • MemberID — VARCHAR2(100)
  • BankName — VARCHAR2(100) — NOT NULL — “은행명”
  • AccountNumber — VARCHAR2(50) — NOT NULL — “계좌번호”
  • Name — VARCHAR2(255) — NOT NULL — “계좌명”

Book

  • BookID — VARCHAR2(100) — “도서ID”
  • ISBN — VARCHAR2(20) — NOT NULL — “ISBN번호”
  • Title — VARCHAR2(255) — NOT NULL — “도서명”
  • Author — VARCHAR2(255) — NOT NULL — “저자명”
  • Publisher — VARCHAR2(255) — NOT NULL
  • PublicationYear — YEAR — NOT NULL — “발행년도”
  • Quantity — INT — NOT NULL — “수량”
  • Price — number — NOT NULL — “가격”
  • Photo1 — VARCHAR2(1000) — “책이미지1”
  • Photo2 — VARCHAR2(1000) — “책이미지2”
  • Photo3 — VARCHAR2(1000) — “책이미지3”
  • Photo4 — VARCHAR2(1000) — “책이미지4”
  • Photo5 — VARCHAR2(1000) — “책이미지5”
  • SellerID — varchar2(100)

BookStatus

  • BookID — VARCHAR2(100)
  • Status — VARCHAR2(50) — NOT NULL — “도서상태”
  • BuyerID — INT — “구매자ID(회원ID)”

Cart

  • CartID — INT
  • MemberID — VARCHAR2(100) — “회원ID”
  • CreatedDate — DATE — NOT NULL — “생성일자”

CreditCard

  • CardID — INT — “결제카드ID”
  • MemberID — VARCHAR2(100) — “회원ID”
  • CardNumber — VARCHAR2(20) — NOT NULL — “결제카드번호”
  • ExpiryDate — DATE — NOT NULL — “결제카드유효기간”
  • CardType — VARCHAR2(50) — NOT NULL — “결제카드

Member

  • MemberID — VARCHAR2(100) — “회원ID”
  • Password — VARCHAR2(255) — NOT NULL — “회원PW’
  • Name — VARCHAR2(255) — NOT NULL — “회원이름”
  • PhoneNumber — VARCHAR2(20) — NOT NULL — “회원핸드폰번호”
  • Email — VARCHAR2(255) — “회원email”

Order

  • OrderID — INT — “주문ID”
  • MemberID — VARCHAR2(100) — “회원ID”
  • OrderDate — DATE — NOT NULL
  • CreditCardID — INT — “결제카드ID”
  • ShippingAddressID — VARCHAR2(100) — “배송주소ID”

OrderDetail

  • OrderID — INT — “주문ID”
  • BookID — VARCHAR2(100) — “도서ID”
  • Quantity — NUMBER — NOT NULL — “주문수량”

ShippingAddress

  • AddressID — VARCHAR2(100) — “배송주소ID”
  • MemberID — VARCHAR2(100) — “회원ID”
  • ZipCode — VARCHAR2(20) — NOT NULL — “우편번호”
  • BaseAddress — VARCHAR2(255) — NOT NULL — “기본주소”
  • DetailAddress — VARCHAR2(255) — NOT NULL — “상세주소”