Cisco Systems PXM Version 1.1 Guide de l'utilisateur télécharger pdf (Page 95)

B-5

Cisco Carrier Sensitive Routing User Guide

AppendixB Data Schema

Dataset Schema

BEGIN WORK;

SET CONSTRAINTS ALL DEFERRED;

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

1 2 ... 90 91 92 93 94 95 96 97 98 99 100 ... 109 110

Pas de commentaire

Cisco Systems PXM Version 1.1 Guide de l'utilisateur Page 95