Cisco PXM Version 1.1, Руководство пользователя, Страница: 95 / 110

B-5
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Dataset 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,
MaxIngressUnits integer 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);