PD
Tables (10)
Application
- application_id — INT — Primary key
- status — ENUM('지원 중', '수락됨', '거절됨') — NOT NULL
- user_id — INT — Foreign key → User.user_id
- project_id — INT — Foreign key → Project.project_id
- message — VARCHAR(255)
Category
- category_id — INT — Primary key
- category — ENUM('개발', '영상/미디어', '문학', '음악')
CollabSuggest
- collabsuggest_id — INT — Primary key — NOT NULL
- status — ENUM('지원 중', '수락됨', '거절됨')
- project_id — INT — Foreign key → Project.project_id
- portfolio_id — INT — Foreign key → Portfolio.portfolio_id — NOT NULL
- message — VARCHAR(255)
Collaboration_Request (Collaboration)
- collaborationrequest_id — INT — Primary key
- project_id — INT — Foreign key → Project.project_id
- user_id — INT — Foreign key → User.user_id
- status — ENUM('지원 중', '수락됨', '거절됨')
Portfolio
- portfolio_id — INT — Primary key — NOT NULL
- title — VARCHAR(30)
- description — VARCHAR(255)
- part — VARCHAR(10)
- duration — VARCHAR(100)
- category_id — INT — Foreign key → Category.category_id
- user_id — INT — Foreign key → User.user_id
Project
- project_id — INT — Primary key
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- status — ENUM('모집 중', '진행 중', '완료') — NOT NULL
- created_date — DATE
- user_id — INT — Foreign key → User.user_id
ProjectCategory
- projectcategory_id — int — Primary key — NOT NULL
- project_id — INT — Foreign key → Project.project_id
- category_id — INT — Foreign key → Category.category_id
Team
- team_id — INT — Primary key
- team_name — VARCHAR(100) — NOT NULL
- created_by — INT — NOT NULL
- project_id — INT — Foreign key → Project.project_id
TeamMember
- TeamMember_id — int — Primary key
- role — VARCHAR(100)
- joined_date — DATE
- user_id — INT — Foreign key → User.user_id
- team_id — INT — Foreign key → Team.team_id
User
- user_id — INT — Primary key
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile — TEXT
- skills — TEXT
- role — ENUM('개인', '팀장', '팀') — NOT NULL