Cisco Systems Version 1.1 manual Inherits

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
AND		(StartTime	NOTNULL AND	EndTime NOTNULL
		(StartTime	< EndTime)	OR
		(
(StartDate <		lower(DaypartType) = 'absolute' AND
		EndDate) AND
WeekDay NOTNULL)		(lower(DaypartType) != 'weekly' OR
		)
		)),
StartDate	date,
EndDate	date,
Cost	integer	CONSTRAINT	CostInvalid
		CHECK (Cost >= 1),
MaxUnits	integer	CONSTRAINT	MaxUnitsInvalid
		CHECK (MaxUnits >= 0),
MaxPercentage	integer	CONSTRAINT	MaxPercentageInvalid
MaxPercentage <=		CHECK (MaxPercentage >= 1 AND
		100)

);

CREATE TABLE IngressRouteAttributes_1 () INHERITS (RouteAttributes); CREATE TABLE IngressRouteAttributes_2 () INHERITS (RouteAttributes);

CREATE TABLE EgressRouteAttributes (
QoS	integer	CONSTRAINT QoSInvalid
ListKey integer		CHECK (QoS >= 1 and QoS <= 9),
) INHERITS (RouteAttributes);
CREATE TABLE EgressRouteAttributes_1			() INHERITS
(EgressRouteAttributes);
CREATE TABLE EgressRouteAttributes_2			() INHERITS
(EgressRouteAttributes);

Cisco Carrier Sensitive Routing User Guide

B-9