mobile

Tables (7)

comments

  • id — TEXT — Primary key
  • authorId (id2) — TEXT — Foreign key → users.id
  • postId — TEXT — Foreign key → posts.id
  • content — TEXT — NOT NULL
  • likesCount — INTEGER
  • created — DATETIME
  • updated — DATETIME

follows

  • id — TEXT — Primary key
  • followerId — TEXT — Foreign key → users.id
  • followingId — TEXT — Foreign key → users.id
  • created — DATETIME
  • updated — DATETIME
  • CHECK — (followerId <> followingId)

likes

  • id — TEXT — Primary key
  • userId — TEXT — Foreign key → users.id
  • postId — TEXT — Foreign key → posts.id
  • created — DATETIME
  • updated — DATETIME

messages

  • id — TEXT — Primary key
  • senderId — TEXT — Foreign key → users.id
  • recipientId — TEXT — Foreign key → users.id
  • content — TEXT — NOT NULL
  • isRead — BOOLEAN
  • created — DATETIME
  • updated — DATETIME

notifications

  • id — TEXT — Primary key
  • recipientId — TEXT — Foreign key → users.id
  • senderId — TEXT — Foreign key → users.id
  • postId — TEXT — Foreign key → posts.id
  • type — TEXT — NOT NULL
  • content — TEXT
  • isRead — BOOLEAN
  • created — DATETIME

posts

  • id — TEXT — Primary key
  • content — TEXT — NOT NULL
  • images — TEXT
  • likesCount — INTEGER
  • commentsCount — INTEGER
  • sharesCount — INTEGER
  • authorId — TEXT — NOT NULL
  • isApproved — BOOLEAN
  • created — DATETIME
  • updated — DATETIME

users

  • id — TEXT — Primary key
  • email — TEXT — NOT NULL
  • emailVisibility — BOOLEAN
  • verified — BOOLEAN
  • name — TEXT
  • avatar — TEXT
  • bio — TEXT
  • created — DATETIME
  • updated — DATETIME
  • id (id2) — TEXT — Foreign key → users.id