public.surveyquestiongroupscores

public.surveyquestiongroupscores

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) false
questiongroupname varchar(200) true
questiongrouptotalscore numeric(20,2) true
questiongroupmaxtotalscore numeric(20,2) true
questiongroupmarkedna bit(1) true
updated timestamp without time zone true

Constraints

Name Type Definition
surveyquestiongroupscores_pkey PRIMARY KEY PRIMARY KEY (surveyid, questiongroupid)

Indexes

Name Definition
surveyquestiongroupscores_pkey CREATE UNIQUE INDEX surveyquestiongroupscores_pkey ON public.surveyquestiongroupscores USING btree (surveyid, questiongroupid)