Filter
Top Products
B-9
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Dataset Schema
CHECK (Weekday >=0 AND Weekday <= 6),
StartTime time,
EndTime time CONSTRAINT TimeRangeInvalid
CHECK (
(StartTime ISNULL AND EndTime ISNULL AND
lower(DaypartType) = 'always') OR
(StartTime NOTNULL AND EndTime NOTNULL
AND
(StartTime < EndTime) OR
(
lower(DaypartType) = 'absolute' AND
(StartDate <
EndDate) AND
(lower(DaypartType) != 'weekly' OR
WeekDay NOTNULL)
)
)),
StartDate date,
EndDate date,
Cost integer CONSTRAINT CostInvalid
CHECK (Cost >= 1),
MaxUnits integer CONSTRAINT MaxUnitsInvalid
CHECK (MaxUnits >= 0),
MaxPercentage integer CONSTRAINT MaxPercentageInvalid
CHECK (MaxPercentage >= 1 AND
MaxPercentage <=
100)
);
CREATE TABLE IngressRouteAttributes_1 () INHERITS (RouteAttributes);
CREATE TABLE IngressRouteAttributes_2 () INHERITS (RouteAttributes);
CREATE TABLE EgressRouteAttributes (
QoS integer CONSTRAINT QoSInvalid
CHECK (QoS >= 1 and QoS <= 9),
ListKey integer
) INHERITS (RouteAttributes);
CREATE TABLE EgressRouteAttributes_1 () INHERITS
(EgressRouteAttributes);
CREATE TABLE EgressRouteAttributes_2 () INHERITS
(EgressRouteAttributes);