Support User Manuals

Cisco Systems Version 1.1 Network Router User Manual

Open as PDF

of 110

B-12

Cisco Carrier Sensitive Routing User Guide

AppendixB Data Schema

Dataset Schema

ALTER TABLE Carriers_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1

(RuleKey) DEFERRABLE;

ALTER TABLE Carriers_1 ADD FOREIGN KEY (ListKey)REFERENCES Lists_1

(ListKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2

(RuleKey) DEFERRABLE;

ALTER TABLE Carriers_2 ADD FOREIGN KEY (ListKey)REFERENCES Lists_2

(ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_1 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_1 ADD FOREIGN KEY (ContactKey)REFERENCES

Contacts_1 (ContactKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ListKey)REFERENCES

Lists_2 (ListKey) DEFERRABLE;

ALTER TABLE ContactLists_2 ADD FOREIGN KEY (ContactKey)REFERENCES

Contacts_2 (ContactKey) DEFERRABLE;

ALTER TABLE Routes_1 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_1

(RuleKey) DEFERRABLE;

ALTER TABLE Routes_2 ADD FOREIGN KEY (RuleKey) REFERENCES Rules_2

(RuleKey) DEFERRABLE;

ALTER TABLE MatchPatterns_1 ADD FOREIGN KEY (RouteKey) REFERENCES

Routes_1 (RouteKey) DEFERRABLE;

ALTER TABLE MatchPatterns_2 ADD FOREIGN KEY (RouteKey) REFERENCES

Routes_2 (RouteKey) DEFERRABLE;

ALTER TABLE Rules_1 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES

Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE Rules_2 ADD FOREIGN KEY (PreferredCarrierKey) REFERENCES

Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey)

REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE IngressRouteAttributes_2 ADD FOREIGN KEY (CarrierKey)

REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (CarrierKey)

REFERENCES Carriers_1 (CarrierKey) DEFERRABLE;

ALTER TABLE EgressRouteAttributes_1 ADD FOREIGN KEY (ListKey)

REFERENCES Lists_1 (ListKey) DEFERRABLE;

previous next