public.kq_analysis_question
Description
Columns
| kq_analysisquestionid |
uuid |
|
false |
|
|
|
| kq_analysisid |
uuid |
|
true |
|
|
|
| question |
text |
|
true |
|
|
|
| answer |
text |
|
true |
|
|
|
| taxonomy |
varchar(200) |
|
true |
|
|
|
| knowledgeid |
uuid |
|
true |
|
|
|
| knowledge_confidence |
numeric(5,2) |
|
true |
|
|
|
Constraints
| kq_analysis_question_pkey |
PRIMARY KEY |
PRIMARY KEY (kq_analysisquestionid) |
Indexes
| 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) |
Related Articles
public.kq_analysis_taxonomy
Description Columns Name Type Default Nullable Children Parents Comment kq_analysistaxonomyid uuid false kq_analysisid uuid true taxonomy varchar(200) true Constraints Name Type Definition kq_analysis_taxonomy_pkey PRIMARY KEY PRIMARY KEY ...
public.kq_analysis
Description Columns Name Type Default Nullable Children Parents Comment kq_analysisid uuid false conversationid uuid true communicationid uuid true callsummary text true callresolution text true callbackrequired boolean true selfserviceattempted ...
public.evaldetails
Description Evaluation Lookup Data Columns Name Type Default Nullable Children Parents Comment id varchar(200) false Primary Key evaluationid varchar(50) true Evaluation Form GUID (Historical column name - this actually contains the form ID, not the ...
public.vwevaldetails
Description See EvalDetails- Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwevaldetails AS ( SELECT evaldetails.id, evaldetails.evaluationid, evaldetails.evaluationformid, evaldetails.evaluationname, ...
public.evalquestiongroupdata
Description Evaluation Question Group Detailed Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(50) false Primary Key evaluationid varchar(50) false Evaluation GUID evaluationformid varchar(50) false Evaluation Form GUID ...