choncance

Tables (4)

accommodations (숙소)

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • accommodation_num (Field12) — int
  • name (Field2) — string
  • address (Field) — string
  • region (Field11) — string
  • person (Field3) — int
  • max_person (Field4) — int
  • explain (Field5) — string
  • grade (Field6) — int
  • price (Field7) — int
  • photo (Field8) — array
  • ref_url (Field9) — string
  • create_date (Field10) — date
  • review (Field13) — array
  • phone (Field14) — string

reservations (예약)

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • accommodationId (Field3) — ObjectId
  • userId (Field6) — ObjectId
  • startDate (Field2) — date
  • endDate (Field4) — date
  • person (Field8) — int
  • state (Field5) — int
  • createdAt (Field7) — date
  • message (Field) — string

timeslots (예약별 날짜)

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • date (Field) — date
  • reservationId (Field2) — ObjectId
  • am (Field3) — boolean
  • pm (Field4) — boolean

users (회원)

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • id (Field) — string
  • password (Field2) — string
  • name (Field3) — string
  • phone (Field4) — string
  • user_type (Field5) — int
  • deleted (Field6) — float
  • create_date (Field7) — date
  • delete_date (Field8) — date
  • update_date (Field9) — date