실습과제#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