Kotra

Tables (5)

inquiry_doc

  • doc_id — BIGINT
  • template_id — BIGINT — NOT NULL
  • template_version_id — BIGINT — NOT NULL
  • source_system — VARCHAR(50) — NOT NULL
  • source_ref — VARCHAR(200)
  • received_at — DATETIME — NOT NULL
  • status — ENUM('COLLECTED','PROCESSING','DONE','ERROR') — NOT NULL
  • verdict — ENUM('UNKNOWN','NORMAL','SUSPICIOUS','SPAM') — NOT NULL
  • risk_score — DECIMAL(6,3)
  • verdict_reason — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL

inquiry_doc_payload

  • doc_id — BIGINT
  • payload_json — JSON — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry_template

  • template_id — BIGINT
  • template_key — VARCHAR(100) — NOT NULL
  • template_name — VARCHAR(200) — NOT NULL
  • description — TEXT
  • status — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • latest_version_id — BIGINT
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT
  • updated_at — DATETIME — NOT NULL

inquiry_template_field

  • field_id — BIGINT
  • template_version_id — BIGINT — NOT NULL
  • field_key — VARCHAR(100) — NOT NULL
  • field_label — VARCHAR(200) — NOT NULL
  • field_type — ENUM('TEXT','TEXTAREA','NUMBER','DATE','DATETIME','BOOLEAN', 'SELECT','MULTISELECT','FILE','OBJECT','ARRAY') — NOT NULL
  • required_yn — CHAR(1) — NOT NULL
  • sort_no — INT — NOT NULL
  • regex_pattern — VARCHAR(500)
  • min_val — DECIMAL(30,10)
  • max_val — DECIMAL(30,10)
  • min_len — INT
  • max_len — INT
  • pii_type — ENUM('NONE','EMAIL','PHONE','NAME','ADDRESS','COMPANY','URL','CUSTOM') — NOT NULL
  • normalize_rule — VARCHAR(100)
  • extra_json — JSON
  • created_at — DATETIME — NOT NULL

inquiry_template_version

  • template_version_id — BIGINT
  • template_id — BIGINT — NOT NULL
  • version_no — INT — NOT NULL
  • status — ENUM('DRAFT','PUBLISHED','DEPRECATED') — NOT NULL
  • schema_json — JSON — NOT NULL
  • published_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • created_by — BIGINT