todo

Tables (9)

categories

  • id — INT — Primary key
  • name — VARCHAR(100) — NOT NULL

followers

  • id — INT — Primary key
  • follower_id — INT — NOT NULL
  • followee_id — INT — NOT NULL

hashtags

  • id — INT — Primary key
  • tag — VARCHAR(100) — NOT NULL

likes

  • id — INT — Primary key
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL

posts

  • id — INT — Primary key
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • time — DATETIME — NOT NULL
  • like_count — INT — NOT NULL
  • view_count — INT — NOT NULL
  • author_id — INT — NOT NULL

posts_hashtags

  • id — INT — Primary key
  • post_id — INT — NOT NULL
  • hashtag_id — INT — NOT NULL

reports

  • id — INT — Primary key
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • reason — VARCHAR(500) — NOT NULL
  • created_at — DATETIME — NOT NULL

users

  • 사용자아이디 (id) — INT — Primary key
  • 이메일 (email) — VARCHAR(255) — NOT NULL
  • 패스워드 (password_hash) — VARCHAR(255) — NOT NULL
  • 이름 (name) — VARCHAR(100) — NOT NULL
  • 나이 (age) — TINYINT

views

  • id — INT — Primary key
  • post_id — INT — NOT NULL
  • user_id — INT