0506test1

Tables (4)

Comments

  • comment_id — INT
  • post_id — INT — Foreign key → Posts.post_id — NOT NULL
  • user_id — VARCHAR(20) — Foreign key → Users.user_id
  • content — TEXT — NOT NULL
  • created_at — DATETIME

Post_Likes

  • like_id — INT
  • post_id — INT — Foreign key → Posts.post_id — NOT NULL
  • user_id — VARCHAR(20) — Foreign key → Users.user_id — NOT NULL
  • created_at — DATETIME

Posts

  • post_id — INT
  • user_id — VARCHAR(20) — Foreign key → Users.user_id
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME

Users

  • user_id — VARCHAR(20)
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • created_at — DATETIME