public.knowledgedocumentfeedbackdata

public.knowledgedocumentfeedbackdata

Columns

Name Type Default Nullable Children Parents Comment
keyid varchar(200) false
feedbackid varchar(50) false
knowledgebaseid varchar(50) false
documentid varchar(50) false
rating varchar(20) true
reason varchar(50) true
comment text true
userid varchar(50) true
documentversionid varchar(50) true
documentvariationid varchar(50) true
sessionid varchar(50) true
querytype varchar(50) true
searchid varchar(50) true
datecreated timestamp without time zone true
updated timestamp without time zone true

Constraints

Name Type Definition
knowledgedocumentfeedbackdata_pkey PRIMARY KEY PRIMARY KEY (keyid)

Indexes

Name Definition
knowledgedocumentfeedbackdata_pkey CREATE UNIQUE INDEX knowledgedocumentfeedbackdata_pkey ON public.knowledgedocumentfeedbackdata USING btree (keyid)
idx_knowledgedocumentfeedbackdata_knowledgebaseid CREATE INDEX idx_knowledgedocumentfeedbackdata_knowledgebaseid ON public.knowledgedocumentfeedbackdata USING btree (knowledgebaseid)
idx_knowledgedocumentfeedbackdata_documentid CREATE INDEX idx_knowledgedocumentfeedbackdata_documentid ON public.knowledgedocumentfeedbackdata USING btree (documentid)
idx_knowledgedocumentfeedbackdata_rating CREATE INDEX idx_knowledgedocumentfeedbackdata_rating ON public.knowledgedocumentfeedbackdata USING btree (rating)
idx_knowledgedocumentfeedbackdata_datecreated CREATE INDEX idx_knowledgedocumentfeedbackdata_datecreated ON public.knowledgedocumentfeedbackdata USING btree (datecreated)