public.wrapupdetails

public.wrapupdetails

Description

Wrap Up Code Details Lookup Up Data

Columns

Name Type Default Nullable Children Parents Comment
id varchar(50) false Primary Key / Wrap Up GUID
name varchar(255) true Wrap Up Name
updated timestamp without time zone true Date Row Updated (UTC)

Constraints

Name Type Definition
wrapupdetails_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
wrapupdetails_pkey CREATE UNIQUE INDEX wrapupdetails_pkey ON public.wrapupdetails USING btree (id)

    • Related Articles

    • public.vwwrapupdetails

      Description WrapUpDetails Table Definition CREATE VIEW vwwrapupdetails AS ( SELECT wrapupdetails.id, wrapupdetails.name, wrapupdetails.updated FROM wrapupdetails ) Columns Name Type Default Nullable Children Parents Comment id varchar(50) true ...

    • public.vwconvsummarydata

      Description See ConvSummaryData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwconvsummarydata AS ( SELECT cs.conversationid, cs.conversationstartdate, cs.conversationstartdateltc, cs.conversationenddate AS ...

    • public.vwuserinteractiondata

      Description See UserInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwuserinteractiondata AS ( SELECT userinteractiondata.keyid, userinteractiondata.startdate AS startdateutc, userinteractiondata.startdateltc, ...

    • public.vwdetailedinteractiondata

      Description See DetailedInteractionData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwdetailedinteractiondata AS ( SELECT di.keyid, di.conversationid, di.conversationstartdate, di.conversationstartdateltc, ...

    • public.vwqueueinteractiondata

      Description Queue Interaction Data Interval Data - Interval is from (15-60) Min(s) Table Definition CREATE VIEW vwqueueinteractiondata AS ( SELECT queueinteractiondata.keyid, queueinteractiondata.startdate, queueinteractiondata.startdateltc, ...