schema modeling

Tables (4)

Comment

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • photoId (Key2) — ObjectId — Primary key — NOT NULL
  • userId (Key3) — ObjectId — Primary key — NOT NULL
  • content (Field) — String — NOT NULL
  • likes (Field2) — Array

Like

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • userId (Key2) — ObjectId — Primary key — NOT NULL
  • targetId (Key3) — ObjectId — Primary key — NOT NULL
  • targetType (Field) — String — NOT NULL

Photo

  • _id (Key) — ObjectId — Primary key — NOT NULL
  • userId (Key2) — ObjectId — Primary key — NOT NULL
  • imageUrl (Field) — String — NOT NULL
  • description (Field2) — String — NOT NULL
  • isPublic (Field3) — Boolean — NOT NULL
  • likes (Field4) — Array
  • comments (Field5) — Array

User

  • _id — ObjectId — Primary key — NOT NULL
  • email — String — NOT NULL
  • password (Field) — String — NOT NULL
  • nickname (Field2) — String — NOT NULL
  • gender (Field3) — String — NOT NULL
  • photos (Field4) — Array