public.kq_analysis_taxonomy

public.kq_analysis_taxonomy

Columns

Name Type Default Nullable Children Parents Comment
kq_analysistaxonomyid varchar(50) false Primary key for the taxonomy analysis record
kq_analysisid varchar(50) true References the parent kq_analysis record
taxonomy varchar(200) true Legacy taxonomy string assigned to this analysis segment
taxonomyid varchar(50) true Canonical taxonomy ID (nullable)
taxonomypath varchar(512) true Hierarchical taxonomy path string (nullable)
taxonomyconfidence numeric(5,4) true Confidence score for taxonomy assignment (0.0000 - 1.0000 typical)
taxonomydecisionsource varchar(32) true Short identifier describing decision source (e.g. model, human)
updated timestamp without time zone true

Constraints

Name Type Definition
kq_analysis_taxonomy_pkey PRIMARY KEY PRIMARY KEY (kq_analysistaxonomyid)

Indexes

Name Definition
kq_analysis_taxonomy_pkey CREATE UNIQUE INDEX kq_analysis_taxonomy_pkey ON public.kq_analysis_taxonomy USING btree (kq_analysistaxonomyid)
idx_kq_analysis_taxonomy_kq_analysisid CREATE INDEX idx_kq_analysis_taxonomy_kq_analysisid ON public.kq_analysis_taxonomy USING btree (kq_analysisid)