kotra-migration
Tables (5)
document
- id — BIGINT
- current_version_id — BIGINT — Foreign key → document_version.id
- created_by — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
document_ai_evaluation
- id — BIGINT
- document_version_id — BIGINT — Foreign key → document_version.id — NOT NULL
- ai_policy_version_no — INT — NOT NULL
- evaluation_no — INT — NOT NULL
- job_id — VARCHAR(100)
- status — VARCHAR(30) — NOT NULL
- result — VARCHAR(30)
- reason — TEXT
- values_json — LONGTEXT
- risk_score — DECIMAL(5, 2)
- risk_severity — VARCHAR(30)
- evaluated_by — VARCHAR(20) — NOT NULL
- started_at — DATETIME
- completed_at — DATETIME
- duration_ms — INT
- attempt_count — INT — NOT NULL
- last_error — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
document_evaluation
- id — BIGINT
- document_version_id — BIGINT — Foreign key → document_version.id — NOT NULL
- revision_no — INT — NOT NULL
- result — VARCHAR(30) — NOT NULL
- reason — TEXT — NOT NULL
- values_json — LONGTEXT — NOT NULL
- evaluated_by — VARCHAR(20) — NOT NULL
- evaluated_at — DATETIME — NOT NULL
document_version
- id — BIGINT
- document_id — BIGINT — Foreign key → document.id — NOT NULL
- version_no — INT — NOT NULL
- template_id — BIGINT — Foreign key → template.id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- source_system — VARCHAR(30) — NOT NULL
- template_name — VARCHAR(255)
- content_json — LONGTEXT — NOT NULL
- edited_by — VARCHAR(20) — NOT NULL
- edit_reason — VARCHAR(500) — NOT NULL
- current_evaluation_id — BIGINT — Foreign key → document_evaluation.id
- current_ai_evaluation_id — BIGINT — Foreign key → document_ai_evaluation.id
- human_result — VARCHAR(30)
- human_evaluated_by — VARCHAR(20)
- human_evaluated_at — DATETIME
- ai_status — VARCHAR(30)
- ai_result — VARCHAR(30)
- ai_risk_score — DECIMAL(5, 2)
- ai_risk_severity — VARCHAR(30)
- ai_policy_version_no — INT
- ai_evaluated_at — DATETIME
- created_at — DATETIME — NOT NULL
template
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- status — VARCHAR(30) — NOT NULL
- form_signature — VARCHAR(64)
- fields_json — LONGTEXT — NOT NULL
- evaluation_criteria_json — LONGTEXT — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL