Cisco Systems Version 1.1 manual

CREATE TABLE Rules (

RuleKey integer

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);

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

Cisco Carrier Sensitive Routing User Guide

B-6