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.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 ...

    • 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.adherenceexcdata

      Description Adherence Detailed Exception 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 ...