week06_hw-spring-mapping

Tables (3)

AUTHOR (author)

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME

COMMENT (comment)

  • id — BIGINT — Primary key — NOT NULL
  • content — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME
  • post_id — BIGINT — Foreign key → AUTHOR.id — NOT NULL
  • author_id — BIGINT — Foreign key → POST.id — NOT NULL

POST (post)

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR
  • content — VARCHAR
  • created_at — DATETIME
  • updated_at — DATETIME
  • author_id — BIGINT — Foreign key → AUTHOR.id — NOT NULL