몬스타북스_ERD

테이블 (16)

m_banner

  • bannerno — NUMBER — NOT NULL
  • eventno — NUMBER — NOT NULL
  • etitle — VARCHAR2(500) — NOT NULL
  • efilesrc — VARCHAR2(225) — NOT NULL
  • eregdate — DATE — NOT NULL

m_book

  • bookno — NUMBER — NOT NULL
  • bisbn — NUMBER — NOT NULL
  • btitle — VARCHAR2(225) — NOT NULL
  • bsubtitle — VARCHAR2(225)
  • bpublisher — VARCHAR2(100)
  • bwriter — VARCHAR2(100) — NOT NULL
  • btranslator — VARCHAR2(100)
  • bpdate — DATE — NOT NULL
  • bprice — NUMBER — NOT NULL
  • bpricesell — NUMBER — NOT NULL
  • bdiscount — NUMBER
  • bstatus — VARCHAR2(10) — NOT NULL — 판매중/품절/숨김
  • bcdate — date — NOT NULL
  • bmdate — date
  • bstock — NUMBER — NOT NULL

m_book_category

  • bcategoryno — NUMBER — NOT NULL
  • bcategory1 — VARCHAR2(100) — NOT NULL
  • bcategory2 — VARCHAR2(100)

m_book_detail

  • bookno — NUMBER — NOT NULL
  • bcategoryno — NUMBER — NOT NULL
  • bimg — VARCHAR2(225)
  • bimgdetail — VARCHAR2(225)
  • bdescription — VARCHAR2(1000)
  • bpage — NUMBER — ~~쪽 / 쪽은 빼고 페이지 수만 들어가게
  • bsize — VARCHAR2(100) — 책크기 ex)133*200*30mm
  • badge — VARCHAR2(15) — NOT NULL — 신상품/베스트/주문폭주

m_cart

  • cartno — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • bookno — NUMBER — NOT NULL
  • ccount — NUMBER

m_coupon

  • cpno — NUMBER — NOT NULL
  • cpname — VARCHAR2(100) — NOT NULL
  • cpdescription — VARCHAR2(225)
  • cpprice — NUMBER — NOT NULL
  • cpcreated — DATE — NOT NULL
  • cpvalid — DATE — NOT NULL
  • cpstatus — VARCHAR2(10) — NOT NULL — TRUE/FALSE

m_coupon_member

  • memberno — NUMBER — NOT NULL
  • cpno2 — NUMBER — NOT NULL
  • cpno — NUMBER — NOT NULL — 쿠폰의 쿠폰번호 가져오기
  • cprdate — DATE — NOT NULL
  • cpvalid — DATE — NOT NULL
  • cpstatus — VARCHAR2(10) — NOT NULL

m_delivery

  • deliveryno — NUMBER — NOT NULL
  • orderno — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • daddress1 — VARCHAR2(100)
  • daddress2 — VARCHAR2(100)
  • daddress3 — VARCHAR2(100)
  • dzipcode — NUMBER
  • dtel — VARCHAR2(100)
  • dname — VARCHAR2(100)

m_event

  • eventno — NUMBER — NOT NULL
  • etitle — VARCHAR2(500) — NOT NULL
  • ecnotent — VARCHAR2(500) — NOT NULL
  • efilesrc — VARCHAR2(225) — NOT NULL
  • eregdate — DATE — NOT NULL
  • deleted — char(3) — NOT NULL
  • yes — COMMENT — 처음 등록시 no, 삭제시 yes

m_faq

  • faqno — NUMBER — NOT NULL
  • fquestion — VARCHAR2(500) — NOT NULL
  • fanswer — VARCHAR2(500) — NOT NULL
  • fcategory — VARCHAR2(225) — NOT NULL — 반품/교환/환불, 주문취소/변경, 배송 / 수령일 안내
  • fregdate — DATE — NOT NULL
  • deleted — char(3) — NOT NULL
  • yes — COMMENT — 처음 등록시 no, 삭제시 yes

m_notice

  • noticeno — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • ntitle — VARCHAR2(225) — NOT NULL
  • ncontent — VARCHAR2(1000) — NOT NULL
  • nwriter — VARCAR2(100) — NOT NULL
  • nregdate — DATE — NOT NULL
  • nfilesrc — VARCAR2(100)
  • deleted — char(3) — NOT NULL
  • yes — COMMENT — 처음 등록시 no, 삭제시 yes

m_order

  • orderno — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • cpno — number — NOT NULL
  • ototalprice — NUMBER — NOT NULL
  • ostatus — VARCHAR2(50) — NOT NULL
  • opay — varchar2(50) — NOT NULL

m_order_detail

  • orderno — NUMBER — NOT NULL
  • bookno — NUMBER — NOT NULL
  • opricesell — NUMBER — NOT NULL — 도서의 판매가 가져오기
  • ocount — NUMBER — NOT NULL
  • orefund_check — VARCHAR2(50)
  • oregdate — Date — NOT NULL

m_qna

  • qnano — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • qcategory — VARCHAR2(100) — NOT NULL — 상품/주문/배송/환불/기타
  • qtitle — VARCHAR2(225) — NOT NULL
  • qcontent — VARCHAR2(1000) — NOT NULL
  • qregdate — DATE — NOT NULL
  • qstatus — VARCAR2(100) — NOT NULL — 처리중/답변완료
  • qanswer — VARCHAR2(1000)
  • qfilesrc — varchar2(255)

m_review

  • reviewno — NUMBER — NOT NULL
  • bookno — NUMBER — NOT NULL
  • memberno — NUMBER — NOT NULL
  • rtitle — VARCHAR2(225) — NOT NULL
  • rcontent — VARCHAR2(1000)
  • regdate — DATE
  • rstar — NUMBER — NOT NULL
  • refilesrc — VARCAR2(225)
  • deleted — char(3) — NOT NULL
  • yes — COMMENT — 처음 등록시 no, 삭제시 yes

사용자 (m_member)

  • memberno — NUMBER — NOT NULL
  • mid — VARCHAR2(100) — NOT NULL
  • mpw — VARCHAR2(100) — NOT NULL
  • mbirth — DATE — NOT NULL
  • mname — VARCHAR2(100) — NOT NULL
  • memail — VARCHAR2(100) — NOT NULL
  • mtel — VARCHAR2(100) — NOT NULL
  • mregdate — DATE — NOT NULL
  • mprofileimg — VARCHAR2(255)
  • mfavorite — VARCHAR2(255)
  • mauthority — VARCHAR2(10) — NOT NULL
  • deleted — char(3) — NOT NULL