Cisco Systems PXM Version 1.1 Podręcznik Użytkownika Strona 98

  • Pobierz
  • Dodaj do moich podręczników
  • Drukuj
  • Strona
    / 110
  • Spis treści
  • BOOKMARKI
  • Oceniono. / 5. Na podstawie oceny klientów
Przeglądanie stron 97
B-8
Cisco Carrier Sensitive Routing User Guide
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
Przeglądanie stron 97
1 2 ... 93 94 95 96 97 98 99 100 101 102 103 ... 109 110

Komentarze do niniejszej Instrukcji

Brak uwag