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