Dongnemento

Tables (5)

pin (Untitled2)

  • _id (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user._id — NOT NULL
  • _id (Key3) — Foreign key → report._id — NOT NULL
  • lat (Field)
  • lng (Field2)
  • title (Field3)
  • images (Field4)
  • body (Field5)
  • likeCount (Field11)
  • hateCount (Field8)
  • isLiked (Field9)
  • isHated (Field10)
  • createdAt (Field6)
  • updatedAt (Field7)

pinLikes (Untitled4)

  • _id (Key) — Primary key — NOT NULL
  • userId (Key2) — Foreign key → user._id — NOT NULL
  • pinId (Key3) — Foreign key → pin._id — NOT NULL
  • _id (Key32) — Foreign key → pin._id — NOT NULL

reply (Untitled3)

  • _id (Key) — Primary key — NOT NULL
  • postId (Key2) — Foreign key → pin._id — NOT NULL
  • _id (Key3) — Foreign key → pin._id — NOT NULL
  • userId (Field)
  • targetReplyId (Field5)
  • reply (Field2)
  • createdAt (Field3)
  • updatedAt (Field4)
  • likeCount (Field6)
  • hateCount (Field7)
  • isLiked (Field8)
  • isHated (Field9)

report (Untitled5)

  • _id (Key) — Primary key — NOT NULL
  • pinId (Field)

user (Untitled)

  • _id (Key) — Primary key — NOT NULL
  • fbUid (Field)
  • email (Field2)
  • password (Field3)
  • social (Field4)
  • name (Field5)
  • introduce (Field6)
  • profileImage (Field7)
  • pushEnabled (Field8)
  • lat (Field9)
  • lng (Field10)
  • address (Field11)
  • status (Field12)
  • createdAt (Field13)
  • updatedAt (Field14)