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