ad

Tables (4)

comments

  • id — INTEGER
  • post_id — INTEGER — Foreign key → posts.id — NOT NULL
  • user_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • is_deleted — INTEGER
  • created_at — TEXT
  • updated_at — TEXT

messages

  • id — INTEGER
  • sender_id — INTEGER — NOT NULL
  • receiver_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — INTEGER
  • is_sender_deleted — INTEGER
  • is_receiver_deleted — INTEGER
  • created_at — TEXT

one_liners

  • id — INTEGER
  • owner_id — INTEGER — NOT NULL
  • writer_id — INTEGER — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — TEXT

posts

  • id — INTEGER
  • user_id — INTEGER — NOT NULL
  • title — TEXT — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INTEGER
  • is_notice — INTEGER
  • is_deleted — INTEGER
  • created_at — TEXT
  • updated_at — TEXT