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