온보딩논리적erd
테이블 (20)
ai_processing_jobs
- ai_processing_job_id — BIGINT — 기본 키 — NOT NULL
- job_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- requested_by_user_id — BIGINT — 외래 키 → users.user_id
- document_id — BIGINT — 외래 키 → documents.document_id
- question_id — BIGINT — 외래 키 → questions.question_id
- wiki_draft_id — BIGINT — 외래 키 → wiki_drafts.wiki_draft_id
- started_at — DATETIME
- finished_at — DATETIME
- error_code — VARCHAR(100)
- error_message — VARCHAR(1000)
- created_at — DATETIME — NOT NULL
ai_tag_suggestions
- ai_tag_suggestion_id — BIGINT — 기본 키 — NOT NULL
- ai_processing_job_id — BIGINT — 외래 키 → ai_processing_jobs.ai_processing_job_id — NOT NULL
- document_id — BIGINT — 외래 키 → documents.document_id — NOT NULL
- tag_id — BIGINT — 외래 키 → tags.tag_id — NOT NULL
- confidence — DECIMAL(5,4)
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
answer_sources
- answer_id — BIGINT — 외래 키 → answers.answer_id — NOT NULL
- wiki_id — BIGINT — 외래 키 → wikis.wiki_id — NOT NULL
- rank_no — INT
- created_at — DATETIME — NOT NULL
answers
- answer_id — BIGINT — 기본 키 — NOT NULL
- question_id — BIGINT — 외래 키 → questions.question_id — NOT NULL
- ai_processing_job_id — BIGINT — 외래 키 → ai_processing_jobs.ai_processing_job_id
- content — TEXT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
change_histories
- change_history_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id
- target_entity_name — VARCHAR(100) — NOT NULL
- target_id — BIGINT — NOT NULL
- action_type — VARCHAR(30) — NOT NULL
- before_content — TEXT
- after_content — TEXT
- created_at — DATETIME — NOT NULL
departments
- department_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_department_id — BIGINT — 외래 키 → departments.department_id
- is_active — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
document_public_departments
- document_id — BIGINT — 외래 키 → documents.document_id — NOT NULL
- department_id — BIGINT — 외래 키 → departments.department_id — NOT NULL
- created_at — DATETIME — NOT NULL
document_tags
- document_id — BIGINT — 외래 키 → documents.document_id — NOT NULL
- tag_id — BIGINT — 외래 키 → tags.tag_id — NOT NULL
- approved_by_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- approved_at — DATETIME — NOT NULL
documents
- document_id — BIGINT — 기본 키 — NOT NULL
- registered_by_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content_uri — VARCHAR(500)
- file_name — VARCHAR(255)
- mime_type — VARCHAR(100)
- visibility_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
questions
- question_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
roles
- role_id — BIGINT — 기본 키 — NOT NULL
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(500)
- is_active — BOOLEAN — NOT NULL
schedule_target_departments
- schedule_id — BIGINT — 외래 키 → schedules.schedule_id — NOT NULL
- department_id — BIGINT — 외래 키 → departments.department_id — NOT NULL
- created_at — DATETIME — NOT NULL
schedules
- schedule_id — BIGINT — 기본 키 — NOT NULL
- registered_by_user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- document_id — BIGINT — 외래 키 → documents.document_id
- ai_processing_job_id — BIGINT — 외래 키 → ai_processing_jobs.ai_processing_job_id
- schedule_type — VARCHAR(30) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(1000)
- start_at — DATETIME — NOT NULL
- end_at — DATETIME
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tags
- tag_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- normalized_name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
user_roles
- user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
- role_id — BIGINT — 외래 키 → roles.role_id — NOT NULL
- assigned_at — DATETIME — NOT NULL
- assigned_by_user_id — BIGINT — 외래 키 → users.user_id
users
- user_id — BIGINT — 기본 키 — NOT NULL
- department_id — BIGINT — 외래 키 → departments.department_id — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
wiki_drafts
- wiki_draft_id — BIGINT — 기본 키 — NOT NULL
- wiki_id — BIGINT — 외래 키 → wikis.wiki_id — NOT NULL
- version_no — INT — NOT NULL
- content — TEXT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_by_ai_processing_job_id — BIGINT — 외래 키 → ai_processing_jobs.ai_processing_job_id
- created_at — DATETIME — NOT NULL
wiki_public_departments
- wiki_id — BIGINT — 외래 키 → wikis.wiki_id — NOT NULL
- department_id — BIGINT — 외래 키 → departments.department_id — NOT NULL
- created_at — DATETIME — NOT NULL
wiki_sources
- wiki_draft_id — BIGINT — 외래 키 → wiki_drafts.wiki_draft_id — NOT NULL
- document_id — BIGINT — 외래 키 → documents.document_id — NOT NULL
- created_at — DATETIME — NOT NULL
wikis
- wiki_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- visibility_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL