th

Tables (4)

comments

  • id — INTEGER — Primary key — NOT NULL
  • post_id — INTEGER — Foreign key → posts.id — NOT NULL
  • parent_id — INTEGER — Foreign key → comments.id
  • author_id — INTEGER — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

posts

  • id — INTEGER — Primary key — NOT NULL
  • author_id — INTEGER — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • shared_post_id — INTEGER — Foreign key → posts.id
  • created_at — DATETIME
  • updated_at — DATETIME

reactions

  • id — INTEGER — Primary key — NOT NULL
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • post_id — INTEGER — Foreign key → posts.id
  • comment_id — INTEGER — Foreign key → comments.id
  • reaction_type — VARCHAR(50) — NOT NULL

users

  • id — INTEGER — Primary key — NOT NULL
  • birth_year — INTEGER
  • user_type — VARCHAR(50) — NOT NULL
  • country — VARCHAR(100)
  • email — VARCHAR(255) — NOT NULL
  • hashed_password — VARCHAR(255)
  • nickname — VARCHAR(100)
  • provider — VARCHAR(50) — NOT NULL
  • social_id — VARCHAR(128)
  • is_active — BOOLEAN — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • last_login_at — DATETIME
  • last_logout_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME