마켓컬리

테이블 (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