Filter
Top Products
2-12
Cisco Carrier Sensitive Routing User Guide
Chapter2 PostgreSQL Database Operations and Functionalities
Database Functionalities
Note Tables MatchPatterns_1 and MatchPatterns_2 can inherit from this table.
Note Tables Routes_1 and Routes_2 can inherit from the Routes table.
Table2-10 Routes Table
Name Type
Allow
Null Default Constraints Comments
RouteKey integer NO <> 0 Primary key. Key of the route.
RouteName text Name of the route.
RuleKey integer Foreign key. Rule associated
with this route.
Table2-11 Rules Table
Name Type
Allow
Null Default Constraints Comments
RuleKey integer NO <> 0 Primary key.
Key of the
rule.
RuleName text Optional name
to describe
this rule.
IsDefaultRule boolean NO FALSE Indicates if
this is the
default rule.
One default
rule must
exist.
MinQoS integer >= 1 and <=9 Minimum
quality of
service. This
is used with
RejectInsuffic
ientQoS rule.
PreferredCarrierKey integer Foreign key.
Key to a
carrier. Used
only when
SelectPreferr
edCarrier
rule is used.