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