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