몬스타북스_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