실습과제#3

테이블 (4)

APPLICATION

  • application_id — INT
  • post_id — INT — 외래 키 → POST.post_id — NOT NULL
  • user_id — INT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • applied_at — DATETIME — NOT NULL

COMMENT

  • comment_id — INT
  • post_id — INT — 외래 키 → POST.post_id — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL

PERFORMANCE

  • performance_id — INT
  • title — VARCHAR(50) — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • place — VARCHAR(50) — NOT NULL
  • performance_date — DATE — NOT NULL

POST

  • post_id — INT
  • user_id — INT — NOT NULL
  • performance_id — INT — 외래 키 → PERFORMANCE.performance_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • content — TEXT — NOT NULL
  • recruit_count — INT — NOT NULL
  • created_at — DATETIME — NOT NULL