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