실습과제#3

테이블 (5)

APPLICATION

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

MEMBER

  • member_id — INT
  • login_id — VARCHAR(30) — NOT NULL
  • password — VARCHAR(30) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • preference — VARCHAR(50)
  • 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
  • member_id — INT — 외래 키 → MEMBER.member_id — 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

POST_COMMENT

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