Filter
Top Products
B-6
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Dataset Schema
CREATE TABLE Routes (
RouteKey integer NOT NULL PRIMARY KEY CONSTRAINT
RouteKeyNotZero
CHECK (RouteKey <> 0),
RouteName text,
RuleKey integer
);
CREATE TABLE Routes_1 () INHERITS (Routes);
CREATE TABLE Routes_2 () INHERITS (Routes);
CREATE TABLE Rules (
RuleKey integer NOT NULL PRIMARY KEY CONSTRAINT
RuleKeyNotZero
CHECK (RuleKey <> 0),
RuleName text,
IsDefaultRule boolean NOT NULL DEFAULT FALSE,
MinQoS integer CONSTRAINT MinQoSInvalid
CHECK (MinQoS >= 1 AND MinQoS <= 9),
PreferredCarrierKey integer,
RejectMaxOriginationPercentageboolean NOT NULL DEFAULT FALSE,
RejectMaxIngressUnits boolean NOT NULL DEFAULT FALSE,
RejectMaxIngressUnitsPerRouteboolean NOT NULL DEFAULT FALSE,
RejectEgressCostMoreThanIngressbooleanNOT NULL DEFAULT FALSE,
RejectInsufficientQoS boolean NOT NULL DEFAULT FALSE,
RejectMaxEgressUnits boolean NOT NULL DEFAULT FALSE,
RejectMaxEgressUnitsPerRouteboolean NOT NULL DEFAULT FALSE,
PreventITSPtoITSP boolean NOT NULL DEFAULT FALSE,
SelectMinCostPerEgressRouteinteger NOT NULL DEFAULT 0 CONSTRAINT
SelMinCostInvalid
CHECK (
SelectMinCostPerEgressRoute >= 0 AND
SelectMinCostPerEgressRoute <= 5
),
SelectBestQoS integer NOT NULL DEFAULT 0 CONSTRAINT
SelBestQoSInvalid