certification-platflom

Tables (11)

certification

  • id — BIGINT — Primary key — NOT NULL
  • certification_category_id (자격증 카테고리 ID) — BIGINT — Foreign key → certification_category.id — NOT NULL
  • name (자격증 이름.) — VARCHAR(100) — NOT NULL
  • issuer (발급 기관) — VARCHAR(100) — NOT NULL
  • level (자격증 등급) — VARCHAR(50)
  • description (자격증 설명) — TEXT
  • passing_criteria (합격 기준) — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

certification_category

  • id — BIGINT — Primary key — NOT NULL
  • name (카테고리 이름) — VARCHAR(50) — NOT NULL
  • description (카테고리 설명) — TEXT
  • display_order (화면 표시 순서) — INT — NOT NULL
  • active (활성화 여부) — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

certification_subject

  • id — BIGINT — Primary key — NOT NULL
  • certification_id (자격증 ID) — BIGINT — Foreign key → certification.id — NOT NULL
  • name (과목 이름) — VARCHAR(100) — NOT NULL
  • sequence (과목 순서) — INT — NOT NULL
  • description (과목 설명) — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

exam_round

  • id — BIGINT — Primary key — NOT NULL
  • certification_id (자격증 ID) — BIGINT — Foreign key → certification.id — NOT NULL
  • round_name (시험 회차 이름) — VARCHAR(100) — NOT NULL
  • exam_type (시험 유형) — ENUM('WRITTEN',PRACTICAL') — NOT NULL
  • application_start_date (원서 접수 시작일) — DATE — NOT NULL
  • application_end_date (원서 접수 종료일) — DATE — NOT NULL
  • exam_date (시험일) — DATE — NOT NULL
  • result_announcement_date (합격 발표일) — DATE
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

post_comments

  • id — BIGINT — Primary key — NOT NULL
  • post_id (게시글 ID) — BIGINT — Foreign key → posts.id — NOT NULL
  • user_id (작성자 사용자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • content (댓글 내용) — TEXT — NOT NULL
  • status (댓글 상태) — ENUM('ACTIVE 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

posts

  • id — BIGINT — Primary key — NOT NULL
  • user_id (작성자 사용자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • certification_id (자격증 ID) — BIGINT — Foreign key → certification.id — NOT NULL
  • title (게시글 제목) — VARCHAR(100) — NOT NULL
  • content (게시글 내용) — TEXT — NOT NULL
  • planned_study_minutes (계획 학습 시간(분)) — INT — NOT NULL
  • comment_count (댓글 수) — INT — NOT NULL
  • status (게시글 상태) — ENUM('ACTIVE 'DELETED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_plan

  • id — BIGINT — Primary key — NOT NULL
  • user_certification_goal_id (사용자 자격증 목표 ID) — BIGINT — Foreign key → user_certification_goal.id — NOT NULL
  • title (학습 계획 제목) — VARCHAR(100) — NOT NULL
  • start_date (학습 시작일) — DATE — NOT NULL
  • end_date (학습 종료일) — DATE — NOT NULL
  • status (학습 계획 상태) — ENUM('ACTIVE 'COMPLETED','CANCELED') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_plan_item

  • id — BIGINT — Primary key — NOT NULL
  • study_plan_id (학습 계획 ID) — BIGINT — Foreign key → study_plan.id — NOT NULL
  • certification_subject_id (자격증 과목 ID) — BIGINT — Foreign key → certification_subject.id — NOT NULL
  • plan_date (학습 예정일) — DATE — NOT NULL
  • title (학습 항목 제목) — VARCHAR(100) — NOT NULL
  • planned_minutes (계획 학습 시간(분)) — INT — NOT NULL
  • completed_minutes (완료 학습 시간(분)) — INT — NOT NULL
  • completed (완료 여부) — BOOLEAN — NOT NULL
  • satisfaction_score (만족도 점수) — INT
  • content (학습 내용) — TEXT
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

study_statistics

  • id — BIGINT — Primary key — NOT NULL
  • user_id (사용자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • user_certification_goal_id (사용자 자격증 목표 ID) — BIGINT — Foreign key → user_certification_goal.id — NOT NULL
  • certification_subject_id (자격증 과목 ID) — BIGINT — Foreign key → certification_subject.id — NOT NULL
  • total_study_minutes (총 학습 시간(분)) — INT — NOT NULL
  • completed_plan_count (완료한 계획 수) — INT — NOT NULL
  • total_plan_count (전체 계획 수) — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_certification_goal

  • id — BIGINT — Primary key — NOT NULL
  • user_id (사용자 ID) — BIGINT — Foreign key → users.id — NOT NULL
  • certification_id (자격증 ID) — BIGINT — Foreign key → certification.id — NOT NULL
  • exam_round_id (시험 회차 ID) — BIGINT — Foreign key → exam_round.id — NOT NULL
  • status (목표 상태) — ENUM('PREPARING', 'TAKEN', 'PASSED', 'FAILED', 'CANCELED') — NOT NULL
  • target_score — INT
  • daily_study_minutes — INT — NOT NULL
  • started_at — DATETIME — NOT NULL
  • completed_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email (사용자 이메일) — VARCHAR(100) — NOT NULL
  • password (사용자 비밀번호) — VARCHAR(255) — NOT NULL
  • name (사용자 이름) — VARCHAR(50) — NOT NULL
  • role (사용자 권한) — ENUM('USER', 'ADMIN') — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL