DB
Tables (9)
Activity (Untitled7)
- activity_id (활동 번호) — PK — Primary key — NOT NULL
- roadmap_id (로드맵 번호2) — FK — Foreign key → Roadmap.roadmap_id — NOT NULL
- report_id (리포트 번호2) — FK — Foreign key → Roadmap.report_id — NOT NULL
- job_id (Key) — FK — Foreign key → Roadmap.job_id — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → Roadmap.user_id — NOT NULL
- activity_name (활동명) — VARCHAR
- activity_type (활동 종류) — VARCHAR
- description (활동 설명) — TEXT
Comment (Untitled9)
- comment_id (댓글 번호) — PK — Primary key — NOT NULL
- post_id (게시글 번호2) — FK — Foreign key → CommunityPost.post_id — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → User.user_id — NOT NULL
- user_id (회원 고유번호2) — FK — Foreign key → CommunityPost.user_id — NOT NULL
- content (댓글 내용) — TEXT
- created_at (작성일) — DATETIME
CommunityPost (Untitled8)
- post_id (게시글 번호) — PK — Primary key — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → User.user_id — NOT NULL
- title (제목) — VARCHAR
- content (내용) — TEXT
- created_at (작성일) — DATETIME
Job (Untitled3)
- job_id (Key) — PK — Primary key — NOT NULL
- job_name (Field) — VARCHAR
- description (Field2) — TEXT
- required_skill (Field3) — TEXT
JobReport (Untitled4)
- report_id (리포트 번호) — PK — Primary key — NOT NULL
- job_id (직무 번호) — FK — Foreign key → Job.job_id — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → User.user_id — NOT NULL
- suitability_score (직무 적합도) — INT
- recommendation (추천 준비 방향) — TEXT
- created_at (생성일) — DATETIME
Roadmap (Untitled5)
- roadmap_id (로드맵 번호) — PK — Primary key — NOT NULL
- report_id (리포트 번호2) — FK — Foreign key → JobReport.report_id — NOT NULL
- job_id (Key) — FK — Foreign key → JobReport.job_id — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → JobReport.user_id — NOT NULL
- report_id (리포트 번호) — FK
- roadmap_title (로드맵 제목) — VARCHAR
- created_at (생성일) — DATETIME
RoadmapStep (Untitled6)
- step_id (단계 번호) — PK — Primary key — NOT NULL
- roadmap_id (로드맵 번호2) — FK — Foreign key → Roadmap.roadmap_id — NOT NULL
- report_id (리포트 번호2) — FK — Foreign key → Roadmap.report_id — NOT NULL
- job_id (직무 번호) — FK — Foreign key → Roadmap.job_id — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → Roadmap.user_id — NOT NULL
- step_order (단계 순서) — INT
- step_title (단계 제목) — VARCHAR
- step_content (단계 내용) — TEXT
User (Untitled)
- user_id (회원 고유번호) — PK — Primary key — NOT NULL
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- name (이름) — VARCHAR
- created_at (가입일) — DATETIME
UserProfile (Untitled2)
- profile_id (프로필 고유번호) — PK — Primary key — NOT NULL
- user_id (회원 고유번호) — FK — Foreign key → User.user_id — NOT NULL
- major (전공) — VARCHAR
- interest_field (관심 분야) — VARCHAR
- personality (성향) — VARCHAR
- strength (강점) — VARCHAR
- target_job (목표 직무) — VARCHAR