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