Database Schema Handbook for Cisco Unified ICM/Contact Center Enterprise & Hosted, Release 10.0(1)
Tables by Group
Downloads: This chapterpdf (PDF - 2.41MB) The complete bookPDF (PDF - 8.15MB) | The complete bookePub (ePub - 1.85MB) | Feedback

Tables by Group

Tables by Group

Overview

This section explains major areas of the schema. Tables are arranged in logical groups based on their domains and interrelationships.

For each section, you can find:

  • an illustration that maps the connections among tables in that group
  • links to detailed information on each individual table in the group
  • a link to the database rules for the group

For details on the columns in each table, see All Tables.

Blended Agent (Outbound Option)

This figure depicts the tables in the Blended Agent (Outbound Option) category and their connections.

In this graphic:

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 1. Blended Agent



To see database rules for tables in the Blended Agent group, see Blended Agent Tables (Outbound Option).

Tables that hold Blended Agent (Outbound Option) data are listed below.

Device

This figure depicts the tables in this category and their connections.

In this graphic:

  • A single box represents a single table.
  • A box with a + plus sign represents a subcategory of table with related detail: Peripheral and Trunk Group.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 2. Device



To see database rules for these tables, see Device Tables.

Tables in the Device category include the following:

Peripheral Detail

The figure below illustrates the tables in the Peripheral Detail subcategory.

Figure 3. Peripheral Detail



These tables are:

Trunk Group Detail

The figure below illustrates the tables in the Trunk Detail subcategory.

Figure 4. Trunk Details



These tables are:

Enterprise

The figure below shows the relationships among tables in the Enterprise category.

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 5. Enterprise



To see database rules for these tables, see Enterprise Tables.

Tables that hold Enterprise data are listed below.

Media Routing

The figure below shows the relationships among the tables in the Media Routing category.

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 6. Media Routing Tables



To see Database rules for the Media Routing tables, see Media Routing Tables.

Media Routing Tables are listed below:

Route

This figure depicts the tables in this category and their connections.

In this graphic:

  • A single box represents a single table.
  • A box with a + plus sign represents a subcategory of table with related detail: Route Detail.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 7. Route Tables



To see Database Rules for Route Tables, see Route Tables.

Tables that hold Route data are listed below.

Route Detail Tables

The figure below illustrates the tables in the Route Details subcategory.

Figure 8. Route Details Tables



Route Detail Tables are:

Schedule

This figure depicts the tables in this category.

In this graphic:

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 9. Schedule Tables



To see Database Rules for Schedule Tables, see Schedule Tables.

Tables that hold Schedule data are listed below.

Script

This figure depicts the tables in this category.

In this graphic:

  • A single box represents a single table.
  • A box with a + plus sign represents a subcategory of table with related detail: Call Type, Region, and Script.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 10. Script Tables



To see database rules for these tables, see Script Tables.

Script Tables are listed below

Call Type Detail

The figure below illustrates the tables in the Call Type subcategory.

Figure 11. Call Type Tables



These tables are:

Region Detail

The figure below illustrates the tables in the Region Detail subcategory.

Figure 12. Region Detail Tables



Region Detail Tables are listed below:

Script Detail

The figure below illustrates the tables in the Script Detail subcategory.

Figure 13. Script Detail



Script Detail Tables are listed below:

Security

The figure below shows the relationships among tables in the Security category.

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 14. Security Tables



To see database rules for these tables, see Security Tables.

Tables that hold Security data are listed below.

Skill Target

This figure shows the relationships among tables in the Skill Target category. The Agent, Service, Skill Group, and Skill Group Member tables each have related tables, as indicated by the + (plus signs) in the illustration.

In this graphic:

  • A single box represents a single table.
  • A box with a + plus sign represents a subcategory of table with related detail: Agent, Service, Skill Group, and Skill Group Member.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 15. Skill Target Tables



To see database rules for Skill Target tables, see Skill Target Tables.

Skill Target tables include the following:

Agent Detail

The figure below illustrates tables in the Agent subcategory.

Figure 16. Agent Tables



Agent Detail tables are listed below:

Service Detail

The figure below illustrates tables in the Service subcategory.

Figure 17. Service Tables



Service tables include:

Skill Group Detail

The figures below illustrate tables in the Skill Group and Skill Group Member subcategories.

Figure 18. Skill Group Tables



Figure 19. Skill Group Member Tables



Skill Group and Skill Group Member Tables include the following:

System

The figure below illustrates tables in the System category. To see database rules for these tables, see System Tables.

Figure 20. System Tables



To see database rules for these tables, see System Tables.

System Tables are listed below

User Preferences

The figure below illustrates the relationships among the Uesr Preferences tables.

  • A single box represents a single table.
  • A stack of boxes represents several tables in another category of the schema.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 21. User Preferences Tables



To see database rules for these tables, see User Preferences Tables.

User Preferences Tables include the following:

VRU Micro-application

The figure below illustrates the relationships among the VRU Micro-Application tables.

  • A single box represents a single table.
  • A single arrowhead indicates a one-to-one relationship, and a double arrowhead indicates a one-to-many relationship.
Figure 22. VRU Micro-application Tables



For database rules, see VRU Micro-applications Tables.

VRU MicroApplication Tables are listed below:

Tables Reserved for Future Use

Although the following tables have been added to the Unified ICM/Unified CCE Schema, they are reserved for future use:

  • Application_Gateway_License
  • Campaign_Half_Hour
  • Campaign_Real_Time
  • Dialer Skill Group Half Hour
  • Dialer Skill Group Real Time
  • ECC_Payload
  • ECC_Payload_Member
  • License_Definition
  • License_Real_Time
  • Phone_Strategy
  • Phone_Strategy_Node