타이틀

테이블 (3)

comments

  • comment_id — INT
  • post_id — INT — 외래 키 → posts.post_id
  • user_id — INT — 외래 키 → users.user_id
  • content — TEXT
  • created_at — TIMESTAMP

posts

  • post_id — INT
  • user_id — INT — 외래 키 → users.user_id
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT
  • created_at — TIMESTAMP

users

  • user_id — INT
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — VARCHAR(10)
  • created_at — TIMESTAMP