EWQ

Tables (16)

ai_jobs

  • ai_job_id — BIGINT — Primary key — NOT NULL
  • document_version_id — BIGINT — Foreign key → document_versions.document_version_id
  • parent_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id
  • requested_by — BIGINT — Foreign key → users.user_id
  • job_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • retry_count — INT — NOT NULL
  • failure_stage — VARCHAR(100)
  • failure_reason — TEXT
  • request_data — JSON
  • result_summary — JSON
  • requested_at — DATETIME — NOT NULL
  • started_at — DATETIME
  • completed_at — DATETIME

audit_logs

  • audit_log_id — BIGINT — Primary key — NOT NULL
  • actor_id — BIGINT — Foreign key → users.user_id
  • action_type — VARCHAR(50) — NOT NULL
  • target_type — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • before_data — JSON
  • after_data — JSON
  • request_ip — VARCHAR(45)
  • created_at — DATETIME — NOT NULL

departments

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

document_chunks

  • document_chunk_id — BIGINT — Primary key — NOT NULL
  • document_version_id — BIGINT — Foreign key → document_versions.document_version_id — NOT NULL
  • chunk_index — INT — NOT NULL
  • page_number — INT
  • section_title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • start_offset — INT
  • end_offset — INT
  • created_at — DATETIME — NOT NULL

document_classifications

  • classification_id — BIGINT — Primary key — NOT NULL
  • document_version_id — BIGINT — Foreign key → document_versions.document_version_id — NOT NULL
  • department_id — BIGINT — Foreign key → departments.department_id
  • job_position_name — VARCHAR(100)
  • document_type_code — VARCHAR(50)
  • tags_json — JSON
  • classification_source — VARCHAR(30) — NOT NULL
  • approval_status — VARCHAR(30) — NOT NULL
  • confidence_score — DECIMAL(5,4)
  • classified_at — DATETIME — NOT NULL
  • reviewed_by — BIGINT — Foreign key → users.user_id
  • reviewed_at — DATETIME
  • rejection_reason — VARCHAR(1000)

document_versions

  • document_version_id — BIGINT — Primary key — NOT NULL
  • document_id — BIGINT — Foreign key → documents.document_id — NOT NULL
  • version_number — INT — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • stored_filename — VARCHAR(255) — NOT NULL
  • storage_path — VARCHAR(1000) — NOT NULL
  • file_extension — VARCHAR(20) — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • checksum — VARCHAR(128)
  • parsing_status — VARCHAR(30) — NOT NULL
  • parsing_failure_reason — TEXT
  • extracted_text — LONGTEXT
  • uploaded_at — DATETIME — NOT NULL
  • parsed_at — DATETIME

documents

  • document_id — BIGINT — Primary key — NOT NULL
  • uploader_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • latest_version_number — INT — NOT NULL
  • visibility_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • restorable_until — DATETIME

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • recipient_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • notification_type — VARCHAR(50) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • message — VARCHAR(1000) — NOT NULL
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • read_status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • read_at — DATETIME

question_sources

  • question_source_id — BIGINT — Primary key — NOT NULL
  • question_id — BIGINT — Foreign key → questions.question_id — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • source_id — BIGINT — NOT NULL
  • source_title — VARCHAR(255)
  • source_location — VARCHAR(255)
  • source_quote — TEXT
  • source_order — INT — NOT NULL
  • relevance_score — DECIMAL(5,4)

questions

  • question_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • question_text — TEXT — NOT NULL
  • topic — VARCHAR(255)
  • answer_text — LONGTEXT
  • answer_status — VARCHAR(30) — NOT NULL
  • failure_reason — VARCHAR(1000)
  • feedback_type — VARCHAR(30)
  • feedback_comment — VARCHAR(1000)
  • feedback_at — DATETIME
  • asked_at — DATETIME — NOT NULL
  • answered_at — DATETIME

resource_permissions

  • resource_permission_id — BIGINT — Primary key — NOT NULL
  • resource_type — VARCHAR(30) — NOT NULL
  • resource_id — BIGINT — NOT NULL
  • department_id — BIGINT — Foreign key → departments.department_id
  • role_code — VARCHAR(30)
  • created_by — BIGINT — Foreign key → users.user_id — NOT NULL
  • created_at — DATETIME — NOT NULL

schedules

  • schedule_id — BIGINT — Primary key — NOT NULL
  • source_document_version_id — BIGINT — Foreign key → document_versions.document_version_id
  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id
  • created_by — BIGINT — Foreign key → users.user_id
  • reviewed_by — BIGINT — Foreign key → users.user_id
  • title — VARCHAR(255) — NOT NULL
  • description — TEXT
  • schedule_type — VARCHAR(30) — NOT NULL
  • approval_status — VARCHAR(30) — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME
  • application_deadline — DATETIME
  • target_departments_json — JSON
  • target_job_positions_json — JSON
  • target_joined_from — DATE
  • target_joined_to — DATE
  • reviewed_at — DATETIME
  • rejection_reason — VARCHAR(1000)
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • department_id — BIGINT — Foreign key → departments.department_id
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • employee_number — VARCHAR(50)
  • role_code — VARCHAR(30) — NOT NULL
  • job_position_name — VARCHAR(100)
  • status — VARCHAR(30) — NOT NULL
  • joined_at — DATE
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

wiki_sources

  • wiki_source_id — BIGINT — Primary key — NOT NULL
  • wiki_version_id — BIGINT — Foreign key → wiki_versions.wiki_version_id — NOT NULL
  • document_chunk_id — BIGINT — Foreign key → document_chunks.document_chunk_id — NOT NULL
  • section_index — INT — NOT NULL
  • source_quote — TEXT
  • relevance_score — DECIMAL(5,4)
  • created_at — DATETIME — NOT NULL

wiki_versions

  • wiki_version_id — BIGINT — Primary key — NOT NULL
  • wiki_id — BIGINT — Foreign key → wikis.wiki_id — NOT NULL
  • ai_job_id — BIGINT — Foreign key → ai_jobs.ai_job_id
  • version_number — INT — NOT NULL
  • version_type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • content_json — JSON — NOT NULL
  • approval_status — VARCHAR(30) — NOT NULL
  • change_instruction — TEXT
  • generated_at — DATETIME — NOT NULL
  • reviewed_by — BIGINT — Foreign key → users.user_id
  • reviewed_at — DATETIME
  • rejection_reason — VARCHAR(1000)
  • published_at — DATETIME

wikis

  • wiki_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • current_version_number — INT
  • visibility_status — VARCHAR(30) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME
  • restorable_until — DATETIME