Filter
Top Products
B-3
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Configuration Data Schema
)
);
CREATE TABLE TestRoutes (
TestKey integer NOT NULL PRIMARY KEY,
TestTime time,
TestDate date,
DatasetID text DEFAULT '_1' CONSTRAINT DatasetIDInvalid
CHECK (
lower(DatasetID) = '_1' OR
lower(DatasetID) = '_2'
),
ANI varchar(64),
DNIS varchar(64),
SrcCarrierID varchar(64),
DstCarrierID varchar(64),
RunMe boolean NOT NULL DEFAULT FALSE,
HomeCarrierID varchar(64),
ResultCode text
);
CREATE TABLE TestOutputs (
TestKey integer NOT NULL,
SelectOrder integer NOT NULL,
DstCarrierID varchar(64) NOT NULL,
ListKey integer NOT NULL,
IsSelected boolean NOT NULL DEFAULT FALSE
);
CREATE TABLE LogEntries (
TestKey integer NOT NULL,
EntryOrder integer NOT NULL,
LogString varchar(1024)NOT NULL
);
CREATE TABLE StringResources (
ResourceKey integer NOT NULL PRIMARY KEY,
ResourceStringtext NOT NULL
);