Cisco Systems Version 1.1 manual Commit Begin Work

AppendixB Data Schema

Dataset Schema

CREATE TABLE QoS (
IngressCarrierKeyinteger			NOT	NULL,
EgressCarrierKeyinteger			NOT	NULL,
RouteKey	integer		NOT	NULL,
RelativeQoS	integer		NOT NULL CONSTRAINT RelativeQoSInvalid
			CHECK (RelativeQoS >= 1 AND RelativeQoS <=
			9)
);
CREATE TABLE QoS_1		() INHERITS (QoS);
CREATE TABLE QoS_2		() INHERITS (QoS);
CREATE TABLE RouteParent (
RouteKey	integer		NOT	NULL,
AttributeKey	integer		NOT	NULL

);

CREATE TABLE IngressRoutes_1 () INHERITS (RouteParent);

CREATE TABLE IngressRoutes_2 () INHERITS (RouteParent);

CREATE TABLE EgressRoutes_1 () INHERITS (RouteParent);

CREATE TABLE EgressRoutes_2 () INHERITS (RouteParent);

COMMIT;

BEGIN WORK;

CREATE UNIQUE INDEX Carriers_1_PKey ON Carriers_1 (CarrierKey); CREATE UNIQUE INDEX Carriers_2_PKey ON Carriers_2 (CarrierKey);

CREATE UNIQUE INDEX Carriers_1_ID ON Carriers_1 (CarrierID);

CREATE UNIQUE INDEX Carriers_2_ID ON Carriers_2 (CarrierID);

CREATE UNIQUE INDEX Patterns_1_PKey ON MatchPatterns_1 (PatternKey); CREATE UNIQUE INDEX Patterns_2_PKey ON MatchPatterns_2 (PatternKey);

CREATE UNIQUE INDEX Routes_1_PKey ON Routes_1 (RouteKey);

CREATE UNIQUE INDEX Routes_2_PKey ON Routes_2 (RouteKey);

CREATE UNIQUE INDEX Rules_1_PKey ON Rules_1 (RuleKey);

CREATE UNIQUE INDEX Rules_2_PKey ON Rules_2 (RuleKey);

Cisco Carrier Sensitive Routing User Guide

B-10