Cisco PXM Version 1.1, User Manual, Page: 97 / 110

B-7
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Dataset Schema
CHECK (
SelectBestQoS >= 0 AND
SelectBestQoS <= 5
),
SelectSameCarrier integer NOT NULL DEFAULT 0 CONSTRAINT
SelSameCarrierInvalid
CHECK (
SelectSameCarrier >= 0 AND
SelectSameCarrier <= 5
),
SelectPreferredCarrier integer NOT NULL DEFAULT 0 CONSTRAINT
SelPreferredCarrierInvalid
CHECK (
SelectPreferredCarrier >= 0 AND
SelectPreferredCarrier <= 5
),
SelectPercentageEgress integer NOT NULL DEFAULT 0 CONSTRAINT
SelPercentageEgressInvalid
CHECK (
SelectPercentageEgress >= 0 AND
SelectPercentageEgress <= 5
)
);
CREATE TABLE Rules_1 () INHERITS (Rules);
CREATE TABLE Rules_2 () INHERITS (Rules);
CREATE TABLE Contacts (
ContactKey integer NOT NULL PRIMARY KEY CONSTRAINT
ContactKeyNotZero
CHECK (ContactKey <> 0),
RASAddress varchar(64) NOT NULL,
AddressType text NOT NULL CONSTRAINT
ContactAddressTypeInvalid
CHECK (
lower(AddressType) = 'ipv4' OR
lower(AddressType) = 'gkid' OR
lower(AddressType) = 'dnsname'
),