마켓컬리
테이블 (9)
address (배송지)
- _id — ObjectID
- userID — ObjectID
- address — String
- recipient — String — 받는사람
- phone — String
- sendType — String
- isBaseAddress — Boolean
category (상품 카테고리)
- _id — ObjectID
- name — String
- subCategory — Array
goods (상품정보)
- _id — ObjectID — NOT NULL
- title — String
- subTitle — String
- price — Number
- discount — Number — 할인율
- buyOption — Array
- category — Array — 카테고리의 ObjectID 배열
- thumbnail — String
- stockCount — Number — 재고량
- goodsDesc — Array — 상품설명
- goodsImg — Array — 상품 이미지
goodsQnA (1:1문의)
- _id — ObjectID
- qnaID (qndID) — Number
- title — String
- body — String
- userID — ObjectID
- createdAt — Date
- replies — Array
goodsReview (상품 리뷰)
- _id — ObjectID
- reviewID — Number
- title — String
- files — Array
- body — String
- goodsID — ObjectID
- userID — ObjectID
- createdAt — Date
- likes — Number
- views — Number
- isNotice — Boolean
kart (장바구니)
- _id — ObjectID
- userID — ObjectID
- goodsID — ObjectID
- count — Number
notice (공지)
- _id — ObjectID
- title — String
- author — String
- createdAt — Date
- views — Number
- body — Object
purchase (결제)
- _id — ObjectID
- userID — ObjectID
- goodsID — ObjectID
- orderNumber — Number
- price — Number
- orderState — String
- deliverPrice — Number
- paymentAmount — Number — 결제 금액
- discount — Object — NOT NULL — goodsDiscount: Number, usePoint: Number
- paymentType — Object
users (회원정보)
- _id — ObjectID
- id — String
- password — String
- name — String
- email — String
- phone — String
- address — String
- gender — String
- dateBirth — String — 생년월일
- recommenderID — ObjectID
- termUseAgreement — Object
- marketingAgreement — Object
- grade — String — 14세 이상 여부
- point — Number
- subscribeState — Object