- Cisco Sensitive Routing User Guide

2-11
Cisco Carrier Sensitive Routing User Guide
Chapter2 PostgreSQL Database Operations and Functionalities
Database Functionalities
Note Tables Carriers_1 and Carriers_2 can inherit from the Carriers table.
Table2-8 Carriers Table
Name Type
Allow
Null Default Constraints Comments
CarrierKey integer NO <>0 Primary key. Key
of the carrier.
CarrierName varchar(64) NO Name of carrier.
CarrierType text NO Valid values:
• home
• itsp
• tdm
Type of carrier.
CarrierID varchar(64) NO ID of carrier.
Must be unique.
MaxIngressUnits integer >=0 Maximum
ingress units.
MaxEgressUnits integer >=0 Maximum egress
units.
RuleKey integer Foreign key. Rule
associated with
this specific
carrier.
ListKey integer NO Foreign key. Key
of the list.
isActive boolean NO TRUE Indicates whether
carrier is active.
Table2-9 MatchPatterns Table
Name Type
Allow
Null Default Constraints Comments
PatternKey integer NO <> 0 Primary key. Key of the
pattern.
Pattern varchar(64) NO Unique. Valid values
are 0 to 9, a to f, A to F,
*, and “.”
RouteKey integer Foreign key. Route that
this pattern is associated
with.