Filter
Top Products
B-4
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Configuration Data Schema
CREATE TABLE Filters (
FilterKey integer NOT NULL PRIMARY KEY,
GKID varchar(64) NOT NULL,
MsgType text NOT NULL CONSTRAINT MsgTypeInvalid
CHECK (
lower(MsgType) = 'arq' OR
lower(MsgType) = 'lrq' OR
lower(MsgType) = 'rrq' OR
lower(MsgType) = 'urq' OR
lower(MsgType) = 'lcf' OR
lower(MsgType) = 'lrj' OR
lower(MsgType) = 'drq' OR
lower(MsgType) = 'brq' OR
lower(MsgType) = 'irr' OR
lower(MsgType) = 'rai'
),
FilterType text NOT NULL CONSTRAINT FilterTypeInvalid
CHECK (
lower(FilterType) = 'endpoint'OR
lower(FilterType) = 'supportedprefix'OR
lower(FilterType) =
'destinationinformation' OR
lower(FilterType) =
'remoteextensionaddress' OR
lower(FilterType) = 'redirectreason'OR
lower(FilterType) = 'answercall'OR
lower(FilterType) = 'notificationonly'
),
Value text NOT NULL
);
ALTER TABLE TestOutputs ADD FOREIGN KEY (TestKey) REFERENCES TestRoutes
(TestKey) DEFERRABLE;
ALTER TABLE LogEntries ADD FOREIGN KEY (TestKey) REFERENCES TestRoutes
(TestKey) DEFERRABLE;
ALTER TABLE Filters ADD FOREIGN KEY (GKID) REFERENCES GateKeepers
(GKID) DEFERRABLE;
COMMIT;