Packing_DB

Tables (4)

Friendship (사용자 간 관계 (여행 친구))

  • _id (Key) — Primary key — NOT NULL
  • requesterId (Field) — String — NOT NULL
  • receiverId (Field2) — String — NOT NULL
  • status (Field3) — String — NOT NULL
  • createdAt (Field4) — Date — NOT NULL
  • updatedAt (Field5) — Date — NOT NULL

Journey (여행 정보)

  • _id (Key) — Primary key — NOT NULL
  • creatorId (Field) — String — NOT NULL
  • title (Field2) — String — NOT NULL
  • transportType (Field3) — String — NOT NULL
  • destination (Field4) — String — NOT NULL
  • startDate (Field5) — Date — NOT NULL
  • endDate (Field6) — Date — NOT NULL
  • theme (Field7) — String — NOT NULL
  • imageUrl (Field8) — String
  • isPrivate (Field9) — Boolean — NOT NULL
  • participants (Field10) — Array<String> — NOT NULL
  • createdAt (Field11) — Date — NOT NULL
  • updatedAt (Field12) — Date — NOT NULL

PackingItem (여행준비물 항목)

  • _id (Key) — Primary key — NOT NULL
  • journeyId (Field) — String — NOT NULL
  • name (Field2) — String — NOT NULL
  • count (Field3) — Number — NOT NULL
  • isChecked (Field4) — Boolean — NOT NULL
  • category (Field5) — String — NOT NULL
  • isShared (Field6) — Boolean — NOT NULL
  • assignedTo (Field7) — String
  • createdBy (Field8) — String — NOT NULL
  • createdAt (Field9) — Date — NOT NULL
  • updatedAt (Field10) — Date — NOT NULL

User (사용자 정보)

  • _id (Key) — Primary key — NOT NULL
  • name (Field) — String — NOT NULL
  • email (Field2) — String — NOT NULL
  • password (Field3) — String
  • profileImage (Field4) — String
  • intro (Field5) — String
  • socialType (Field6) — String — NOT NULL
  • socialId (Field7) — String
  • refreshToken (Field8) — String
  • pushNotificationEnabled (Field9) — Boolean — NOT NULL
  • createdAt (Field10) — Date — NOT NULL
  • updatedAt (Field11) — Date — NOT NULL