ㅁㄴㅇㄹ

Tables (28)

ai_job_documents

  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • input_order — INT
  • created_at — DATETIME(6) — NOT NULL

ai_job_wikis

  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id — NOT NULL
  • wiki_id — BIGINT — Foreign key → wikis.wiki_id — NOT NULL
  • operation_type — ENUM( 'CREATED', 'UPDATED' ) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

ai_jobs

  • ai_job_id — BIGINT — Primary key — NOT NULL
  • requested_by — BIGINT — Foreign key → users.user_id
  • job_type — ENUM( 'DOCUMENT_CLASSIFICATION', 'DOCUMENT_SUMMARY', 'WIKI_GENERATION', 'WIKI_UPDATE', 'DERIVED_CONTENT_GENERATION', 'ROADMAP_GENERATION', 'SCHEDULE_EXTRACTION', 'REPORT_GENERATION', 'IMPROVEMENT_SUGGESTION', 'EMBEDDING', 'OTHER' ) — NOT NULL
  • status — ENUM( 'PENDING', 'QUEUED', 'RUNNING', 'SUCCEEDED', 'FAILED', 'CANCELLED' ) — NOT NULL
  • request_payload — JSON
  • result_payload — JSON
  • error_code — VARCHAR(100)
  • error_message — TEXT
  • model_name — VARCHAR(255)
  • retry_count — INT — NOT NULL
  • requested_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL

audit_logs

  • audit_log_id — BIGINT — Primary key — NOT NULL
  • actor_user_id — BIGINT — Foreign key → users.user_id
  • action — VARCHAR(100) — NOT NULL
  • target_type — VARCHAR(100) — NOT NULL
  • target_id — BIGINT
  • request_id — VARCHAR(100)
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(1000)
  • before_data — JSON
  • after_data — JSON
  • additional_data — JSON
  • occurred_at — DATETIME(6) — NOT NULL

departments

  • department_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

derived_content_document_sources

  • derived_content_id — BIGINT — Foreign key → derived_contents.derived_content_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

derived_content_wiki_sources

  • derived_content_id — BIGINT — Foreign key → derived_contents.derived_content_id — NOT NULL
  • wiki_id — BIGINT — Foreign key → wikis.wiki_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

derived_contents

  • derived_content_id — BIGINT — Primary key — NOT NULL
  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id — NOT NULL
  • content_type — ENUM( 'SUMMARY', 'QUIZ', 'CHECKLIST', 'FLASHCARD', 'GUIDE', 'FAQ', 'BRIEFING', 'OTHER' ) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — JSON — NOT NULL
  • status — ENUM( 'DRAFT', 'REVIEW_REQUESTED', 'PUBLISHED', 'REJECTED', 'ARCHIVED' ) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

documents

  • document_id — BIGINT — Primary key — NOT NULL
  • uploaded_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • storage_key — VARCHAR(500) — NOT NULL
  • content_type — VARCHAR(100)
  • file_size — BIGINT
  • checksum — VARCHAR(128)
  • status — ENUM( 'UPLOADED', 'PROCESSING', 'AVAILABLE', 'FAILED', 'ARCHIVED', 'DELETED' ) — NOT NULL
  • visibility — ENUM( 'PRIVATE', 'DEPARTMENT', 'COMPANY' ) — NOT NULL
  • version — INT — NOT NULL
  • uploaded_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

improvement_suggestions

  • improvement_suggestion_id — BIGINT — Primary key — NOT NULL
  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id
  • wiki_id — BIGINT — Foreign key → wikis.wiki_id
  • suggestion_type — ENUM( 'CONTENT_UPDATE', 'MISSING_INFORMATION', 'DUPLICATE_CONTENT', 'OUTDATED_CONTENT', 'QUALITY_IMPROVEMENT', 'STRUCTURE_IMPROVEMENT', 'OTHER' ) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT — NOT NULL
  • reason — TEXT
  • priority — ENUM( 'LOW', 'MEDIUM', 'HIGH', 'CRITICAL' ) — NOT NULL
  • status — ENUM( 'OPEN', 'ACCEPTED', 'REJECTED', 'APPLIED', 'CANCELLED' ) — NOT NULL
  • reviewed_by — BIGINT — Foreign key → users.user_id
  • reviewed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

learning_items

  • learning_item_id — BIGINT — Primary key — NOT NULL
  • roadmap_id — BIGINT — Foreign key → roadmaps.roadmap_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id
  • derived_content_id — BIGINT — Foreign key → derived_contents.derived_content_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • item_type — ENUM( 'DOCUMENT', 'DERIVED_CONTENT', 'EXTERNAL_LINK', 'TASK', 'QUIZ', 'OTHER' ) — NOT NULL
  • external_url — VARCHAR(1000)
  • sequence_number — INT — NOT NULL
  • required — BOOLEAN — NOT NULL
  • estimated_minutes — INT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

learning_progress

  • learning_progress_id — BIGINT — Primary key — NOT NULL
  • roadmap_assignment_id — BIGINT — Foreign key → roadmap_assignments.roadmap_assignment_id — NOT NULL
  • learning_item_id — BIGINT — Foreign key → learning_items.learning_item_id — NOT NULL
  • trainee_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — ENUM( 'NOT_STARTED', 'IN_PROGRESS', 'COMPLETED', 'SKIPPED', 'FAILED' ) — NOT NULL
  • progress_percent — DECIMAL(5, 2) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • last_accessed_at — DATETIME(6)
  • score — DECIMAL(7, 2)
  • attempt_count — INT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

mentor_assignments

  • mentor_assignment_id — BIGINT — Primary key — NOT NULL
  • mentor_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • trainee_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — ENUM( 'ACTIVE', 'COMPLETED', 'CANCELLED' ) — NOT NULL
  • started_at — DATE — NOT NULL
  • ended_at — DATE
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • notification_type — ENUM( 'ROADMAP_ASSIGNED', 'LEARNING_REMINDER', 'SCHEDULE_CREATED', 'DOCUMENT_PROCESSED', 'WIKI_REVIEW_REQUESTED', 'REPORT_CREATED', 'SYSTEM', 'OTHER' ) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — TEXT — NOT NULL
  • reference_type — VARCHAR(50)
  • reference_id — BIGINT
  • channel — ENUM( 'IN_APP', 'EMAIL', 'PUSH' ) — NOT NULL
  • status — ENUM( 'PENDING', 'SENT', 'FAILED' ) — NOT NULL
  • read_at — DATETIME(6)
  • sent_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL

question_document_references

  • question_history_id — BIGINT — Foreign key → question_histories.question_history_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • relevance_score — DECIMAL(6, 5)
  • chunk_reference — VARCHAR(500)
  • citation_order — INT

question_histories

  • question_history_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • question_text — TEXT — NOT NULL
  • answer_text — LONGTEXT
  • status — ENUM( 'PENDING', 'ANSWERED', 'FAILED', 'BLOCKED' ) — NOT NULL
  • model_name — VARCHAR(255)
  • response_time_ms — INT
  • token_usage — JSON
  • created_at — DATETIME(6) — NOT NULL
  • answered_at — DATETIME(6)

question_wiki_references

  • question_history_id — BIGINT — Foreign key → question_histories.question_history_id — NOT NULL
  • wiki_id — BIGINT — Foreign key → wikis.wiki_id — NOT NULL
  • relevance_score — DECIMAL(6, 5)
  • chunk_reference — VARCHAR(500)
  • citation_order — INT

report_learning_progress

  • report_id — BIGINT — Foreign key → reports.report_id — NOT NULL
  • learning_progress_id — BIGINT — Foreign key → learning_progress.learning_progress_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

report_question_histories

  • report_id — BIGINT — Foreign key → reports.report_id — NOT NULL
  • question_history_id — BIGINT — Foreign key → question_histories.question_history_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

reports

  • report_id — BIGINT — Primary key — NOT NULL
  • trainee_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id — NOT NULL
  • report_type — ENUM( 'DAILY', 'WEEKLY', 'MONTHLY', 'FINAL', 'CUSTOM' ) — NOT NULL
  • period_start — DATE — NOT NULL
  • period_end — DATE — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • summary — LONGTEXT — NOT NULL
  • metrics — JSON
  • status — ENUM( 'GENERATING', 'GENERATED', 'REVIEWED', 'PUBLISHED', 'FAILED' ) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

roadmap_assignments

  • roadmap_assignment_id — BIGINT — Primary key — NOT NULL
  • roadmap_id — BIGINT — Foreign key → roadmaps.roadmap_id — NOT NULL
  • trainee_user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • assigned_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • status — ENUM( 'ASSIGNED', 'IN_PROGRESS', 'COMPLETED', 'CANCELLED', 'EXPIRED' ) — NOT NULL
  • assigned_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • due_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

roadmaps

  • roadmap_id — BIGINT — Primary key — NOT NULL
  • managed_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • generated_by_ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — ENUM( 'DRAFT', 'ACTIVE', 'INACTIVE', 'ARCHIVED' ) — NOT NULL
  • version — INT — NOT NULL
  • estimated_days — INT
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

roles

  • role_id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(500)
  • created_at — DATETIME(6) — NOT NULL

schedules

  • schedule_id — BIGINT — Primary key — NOT NULL
  • source_document_id — BIGINT — Foreign key → documents.document_id
  • created_by_admin_id — BIGINT — Foreign key → users.user_id
  • generated_by_ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • location — VARCHAR(255)
  • start_at — DATETIME(6) — NOT NULL
  • end_at — DATETIME(6)
  • all_day — BOOLEAN — NOT NULL
  • status — ENUM( 'DRAFT', 'CONFIRMED', 'CANCELLED', 'COMPLETED' ) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

user_roles

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • role_id — BIGINT — Foreign key → roles.role_id — NOT NULL
  • granted_by — BIGINT — Foreign key → users.user_id
  • granted_at — DATETIME(6) — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • department_id — BIGINT — Foreign key → departments.department_id — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • employee_number — VARCHAR(50)
  • status — ENUM( 'INVITED', 'ACTIVE', 'INACTIVE', 'SUSPENDED', 'WITHDRAWN' ) — NOT NULL
  • joined_at — DATE
  • last_login_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

wiki_document_sources

  • wiki_id — BIGINT — Foreign key → wikis.wiki_id — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • source_order — INT
  • created_at — DATETIME(6) — NOT NULL

wikis

  • wiki_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • slug — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • status — ENUM( 'DRAFT', 'REVIEW_REQUESTED', 'PUBLISHED', 'REJECTED', 'ARCHIVED' ) — NOT NULL
  • version — INT — NOT NULL
  • created_by — BIGINT — Foreign key → users.user_id
  • reviewed_by — BIGINT — Foreign key → users.user_id
  • reviewed_at — DATETIME(6)
  • published_at — DATETIME(6)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL