public.surveyquestionanswers

public.surveyquestionanswers

Columns

Name Type Default Nullable Children Parents Comment
surveyid varchar(50) false
conversationid varchar(50) false
surveyformid varchar(50) true
surveyname varchar(200) true
agentid varchar(50) true
agentteamid varchar(50) true
queueid varchar(50) true
questiongroupid varchar(50) true
questiongroupname varchar(200) true
questionid varchar(50) false
questiontext text true
questiontype varchar(50) true
questionanswerid varchar(50) true
questionanswertext text true
questionanswervalue numeric(20,2) true
questionscore numeric(20,2) true
questionmarkedna bit(1) true
updated timestamp without time zone true
questioncontextid varchar(50) true
questionnpsscore integer true
questionnpstextanswer text true
questionexplanationprompt text true

Constraints

Name Type Definition
surveyquestionanswers_pkey PRIMARY KEY PRIMARY KEY (surveyid, questionid)

Indexes

Name Definition
surveyquestionanswers_pkey CREATE UNIQUE INDEX surveyquestionanswers_pkey ON public.surveyquestionanswers USING btree (surveyid, questionid)