kotra-migration2
Tables (5)
document
- id — BIGINT — Primary key — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
document_ai_evaluation
- id — BIGINT — Primary key — NOT NULL
- document_version_id — BIGINT — Foreign key → document_version.id — NOT NULL
- ai_policy_version_no — INT — NOT NULL
- version_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(6)
- completed_at — DATETIME(6)
- duration_ms — INT
- attempt_count — INT — NOT NULL
- last_error — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
document_evaluation
- id — BIGINT — Primary key — NOT NULL
- document_version_id — BIGINT — Foreign key → document_version.id — NOT NULL
- version_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(6) — NOT NULL
document_version
- id — BIGINT — Primary key — NOT NULL
- 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
- created_at — DATETIME(6) — NOT NULL
template
- id — BIGINT — Primary key — NOT NULL
- 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(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL