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 — “상세주소”