public.kq_analysis_question

public.kq_analysis_question

Columns

Name Type Default Nullable Children Parents Comment
kq_analysisquestionid varchar(50) false Primary key for the question analysis record
kq_analysisid varchar(50) true References the parent kq_analysis record
question text true The question text extracted from the interaction
answer text true The answer text provided for the question
taxonomy varchar(200) true Legacy taxonomy string (may be deprecated in favor of taxonomyid/taxonomypath)
knowledgeid varchar(50) true ID referencing the knowledge base entry used for this question
knowledge_confidence numeric(5,2) true Confidence score for the knowledge match (0.00 - 1.00 typical)
taxonomyid varchar(50) true Canonical taxonomy ID assigned to the question (nullable)
taxonomypath varchar(512) true Hierarchical taxonomy path for the question (nullable)
updated timestamp without time zone true

Constraints

Name Type Definition
kq_analysis_question_pkey PRIMARY KEY PRIMARY KEY (kq_analysisquestionid)

Indexes

Name Definition
kq_analysis_question_pkey CREATE UNIQUE INDEX kq_analysis_question_pkey ON public.kq_analysis_question USING btree (kq_analysisquestionid)
idx_kq_analysis_question_kq_analysisid CREATE INDEX idx_kq_analysis_question_kq_analysisid ON public.kq_analysis_question USING btree (kq_analysisid)