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