kotra2

Tables (5)

inquiry_doc

  • doc_id — BIGINT
  • template_version_id — BIGINT — Foreign key → inquiry_template_version.template_version_id — 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)
  • created_at — DATETIME — NOT NULL

inquiry_doc_payload

  • doc_id — BIGINT — Foreign key → inquiry_doc.doc_id
  • 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
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

inquiry_template_field

  • field_id — BIGINT
  • template_version_id — BIGINT — Foreign key → inquiry_template_version.template_version_id — 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') — NOT NULL
  • required_yn — CHAR(1) — NOT NULL
  • sort_no — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

inquiry_template_version

  • template_version_id — BIGINT
  • template_id — BIGINT — Foreign key → inquiry_template.template_id — NOT NULL
  • version_no — INT — NOT NULL
  • status — ENUM('DRAFT','PUBLISHED','DEPRECATED') — NOT NULL
  • schema_json — JSON — NOT NULL
  • created_at — DATETIME — NOT NULL