Cisco Systems Version 1.1 manual Dataset Schema

BEGIN WORK;

SET CONSTRAINTS ALL DEFERRED;

AppendixB Data Schema

Dataset Schema

Dataset Schema

CREATE TABLE Carriers (
CarrierKey	integer	NOT NULL PRIMARY KEY CONSTRAINT
		CarrierKeyNotZero
		CHECK (CarrierKey <> 0),
CarrierName	varchar(64) NOT NULL,
CarrierType	text	NOT NULL
	CONSTRAINT	CarrierTypeInvalid CHECK (

	lower(CarrierType) = 'home' OR
	lower(CarrierType) = 'itsp' OR
	lower(CarrierType) = 'tdm'
	),
CarrierID	varchar(64) NOT NULL UNIQUE,
MaxIngressUnitsinteger		CONSTRAINT MaxIngressUnitsInvalid
		CHECK (MaxIngressUnits >= 0),
MaxEgressUnitsinteger		CONSTRAINT MaxEgressUnitsInvalid
		CHECK (MaxEgressUnits >= 0),
RuleKey	integer,
ListKey	integer	NOT NULL,
isActive	boolean	NOT NULL DEFAULT TRUE

);

CREATE TABLE Carriers_1 () INHERITS (Carriers);

CREATE TABLE Carriers_2 () INHERITS (Carriers);

CREATE TABLE MatchPatterns (
PatternKey	integer	NOT NULL PRIMARY KEY CONSTRAINT
		PatternKeyNotZero
		CHECK (PatternKey <> 0),
Pattern	varchar(64) NOT NULL UNIQUE,
RouteKey	integer

);

CREATE TABLE MatchPatterns_1 () INHERITS (MatchPatterns);

CREATE TABLE MatchPatterns_2 () INHERITS (MatchPatterns);

Cisco Carrier Sensitive Routing User Guide

B-5