jj

Tables (3)

follows

  • following_user_id — INTEGER — Foreign key → users.id — NOT NULL
  • followed_user_id — INTEGER — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP

posts

  • id — INTEGER — Primary key — NOT NULL
  • title — VARCHAR(255)
  • body — TEXT
  • user_id — INTEGER — Foreign key → users.id — NOT NULL
  • status — VARCHAR(50)
  • created_at — TIMESTAMP

users

  • id — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(255)
  • role — VARCHAR(50)
  • created_at — TIMESTAMP