Project Design
Tables (6)
Application
- application_id — INT
- project_id — INT — NOT NULL
- applicant_id — INT — NOT NULL
- status — ENUM('지원 중', '수락됨', '거절됨') — NOT NULL
- submitted_date — DATE
- Field
Collaboration
- collaboration_id — INT
- project_id — INT — NOT NULL
- categories_involved — TEXT — NOT NULL
- details — TEXT
Collaboration_Request
- request_id — INT
- project_id — INT — NOT NULL
- requested_user_id — INT — NOT NULL
- status — ENUM('수락됨', '대기 중', '거절됨') — NOT NULL
- sent_date — DATE
Project
- project_id — INT
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- category — ENUM('개발', '영상/미디어', '문학', '음악') — NOT NULL
- created_by — INT — NOT NULL
- status — ENUM('모집 중', '진행 중', '완료') — NOT NULL
- created_date — DATE
Team
- team_id — INT
- team_name — VARCHAR(100) — NOT NULL
- created_by — INT — NOT NULL
- members — TEXT
User
- user_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile — TEXT
- skills — TEXT
- role — ENUM('개인', '팀장', '팀') — NOT NULL
- portfolio — TEXT
- portfolio_category — ENUM('개발', '영상/미디어', '문학', '음악') — NOT NULL