Matched Category

Matched Category

contactcentredb.matched_category

Description

Columns

Name Type Default Nullable Children Parents Comment
contact_id varchar(255) false
category varchar(255) false
db_last_updated timestamp without time zone true

Constraints

Name Type Definition
pk_matched_category PRIMARY KEY PRIMARY KEY (contact_id, category)

Indexes

Name Definition
pk_matched_category CREATE UNIQUE INDEX pk_matched_category ON contactcentredb.matched_category USING btree (contact_id, category)

Generated by tbls


    • Related Articles

    • README

      Logo Amazon Connect Data Dictionary Tables Name Columns Comment Type contactcentredb.queueobservations 13 BASE TABLE contactcentredb.queuemetrics 42 BASE TABLE contactcentredb.usergroups 15 BASE TABLE contactcentredb.agentstatus 12 BASE TABLE ...

    • public.vwactivitycodedetails

      Description See activitycodes table Table Definition CREATE VIEW vwactivitycodedetails AS ( SELECT activitycodedetails.keyid, activitycodedetails.id, activitycodedetails.businessunitid, activitycodedetails.name, activitycodedetails.active, ...

    • public.activitycodedetails

      Description Activity Code Lookup Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false id varchar(50) true businessunitid varchar(50) true name varchar(50) true active bit(1) true defaultcode bit(1) true category ...

    • public.vwadherenceexcdata

      Description See AdherenceExcData - Expands all the GUIDs with their lookups Table Definition CREATE VIEW vwadherenceexcdata AS ( SELECT ad.userid, ad.startdate, ad.enddate, ad.startdateltc, ad.enddateltc, ad.durationsecs, ((ad.durationsecs)::numeric ...

    • public.adherenceactdata

      Description Adherence Actual Activity Data Columns Name Type Default Nullable Children Parents Comment keyid varchar(100) false Primary Key userid varchar(50) true User GUID startdate timestamp without time zone true Start Time (UTC) startdateltc ...