| 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 | ||||
| status | varchar(20) | true | ||||
| totalscore | numeric(20,2) | true | ||||
| completeddate | timestamp without time zone | true | ||||
| completeddateltc | timestamp without time zone | true | ||||
| updated | timestamp without time zone | true | ||||
| lastpoll | timestamp without time zone | true |
| Name | Type | Definition |
|---|---|---|
| surveydata_pkey | PRIMARY KEY | PRIMARY KEY (surveyid) |
| Name | Definition |
|---|---|
| surveydata_pkey | CREATE UNIQUE INDEX surveydata_pkey ON public.surveydata USING btree (surveyid) |
| surveydata_conversationid | CREATE INDEX surveydata_conversationid ON public.surveydata USING btree (conversationid) |