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

      Description Knowledge base categories with KB context, document statistics, feedback metrics, and hierarchy information Table Definition CREATE VIEW vwknowledgecategory AS ( SELECT cat.id AS category_id, cat.name AS category_name, cat.description AS ...

    • public.vwactivitycodedetails

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

    • public.vwknowledgedocument

      Description Comprehensive view of knowledge documents with knowledge base, category context, and feedback statistics Table Definition CREATE VIEW vwknowledgedocument AS ( SELECT doc.id, doc.title, doc.visible, doc.state, doc.datecreated AS ...

    • public.vwknowledgedocumentfeedback

      Description Comprehensive view of knowledge document feedback with user, document, version, and knowledge base context Table Definition CREATE VIEW vwknowledgedocumentfeedback AS ( SELECT fb.keyid, fb.feedbackid AS feedback_id, fb.datecreated AS ...