PD

Tables (4)

Application

  • application_id — INT
  • project_id — INT — NOT NULL
  • applicant_id — INT — NOT NULL
  • status — ENUM('지원 중', '수락됨', '거절됨') — NOT NULL
  • submitted_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