Study

Tables (5)

Position

  • position_id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL

ProjectPosition

  • id — BIGINT — Primary key
  • project_id — BIGINT — Foreign key → ProjectStudy.project_id
  • position_id (position_id2) — BIGINT — Foreign key → Position.position_id

ProjectStudy

  • project_id — BIGINT — Primary key
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • recruit_type — ENUM('스터디', '프로젝트') — NOT NULL
  • recruit_number — INT — NOT NULL
  • progress_method — ENUM('온라인', '오프라인', '온오프라인') — NOT NULL
  • period — VARCHAR(100)
  • deadline — DATE
  • status — ENUM('모집중', '모집마감', '진행중', '완료') — NOT NULL
  • created_at — TIMESTAMP

ProjectTechStack

  • id — BIGINT — Primary key
  • project_id — BIGINT — Foreign key → ProjectStudy.project_id
  • tech_id (tech_id2) — BIGINT — Foreign key → TechStack.tech_id

TechStack

  • tech_id — BIGINT — Primary key
  • name — VARCHAR(100) — NOT NULL