Cisco Systems Version 1.1 manual ContactKey Integer

AppendixB Data Schema

Dataset Schema

Cost	integer	CONSTRAINT CostInvalid
	CHECK (Cost >= 0),
Priority	integer	CONSTRAINT PriorityInvalid
	CHECK (Priority >= 0)

);

CREATE TABLE Contacts_1 () INHERITS (Contacts);

CREATE TABLE Contacts_2 () INHERITS (Contacts);

CREATE TABLE Lists (
ListKey	integer	NOT NULL PRIMARY KEY CONSTRAINT

ListKeyNotZero

CHECK (ListKey <> 0),

ListName text

);

CREATE TABLE Lists_1 () INHERITS (Lists);

CREATE TABLE Lists_2 () INHERITS (Lists);

CREATE TABLE ContactLists (
ListKey	integer	NOT	NULL,
ContactKey	integer	NOT	NULL

);

CREATE TABLE ContactLists_1 () INHERITS (ContactLists);

CREATE TABLE ContactLists_2 () INHERITS (ContactLists);

CREATE TABLE RouteAttributes (

AttributeKey	integer	NOT NULL PRIMARY KEY CONSTRAINT
		AttributeKeyNotZero
		CHECK (AttributeKey <> 0),
AttributeName	text,
CarrierKey	integer	NOT NULL,
DaypartType	text	NOT NULL CONSTRAINT DaypartInvalid
	CHECK (

lower(DaypartType) = 'absolute'OR lower(DaypartType) = 'weekly'OR lower(DaypartType) = 'daily'OR lower(DaypartType) = 'always'

	),
WeekDay	integer	CONSTRAINT WeekdayInvalid
Cisco Carrier Sensitive Routing User Guide

B-8