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