Cisco Systems PXM Version 1.1 Guía de usuario Pagina 95

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 110
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 94
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,
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);
Vista de pagina 94
1 2 ... 90 91 92 93 94 95 96 97 98 99 100 ... 109 110

Comentarios a estos manuales

Sin comentarios