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