온보딩논리적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