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 varchar(400) true
questiontype varchar(50) true
questionanswerid varchar(50) true
questionanswertext varchar(200) true
questionanswervalue numeric(20,2) true
questionscore numeric(20,2) true
questionmarkedna bit(1) true
updated timestamp without time zone 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)