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