ㅁㄴㅇㄹ
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