Filter
Top Products
B-13
Cisco Carrier Sensitive Routing User Guide
AppendixB Data Schema
Dataset Schema
ALTER TABLE EgressRouteAttributes_2 ADD FOREIGN KEY (CarrierKey)
REFERENCES Carriers_2 (CarrierKey) DEFERRABLE;
ALTER TABLE EgressRouteAttributes_2 ADD FOREIGN KEY (ListKey)
REFERENCES Lists_2 (ListKey) DEFERRABLE;
ALTER TABLE QoS_1 ADD FOREIGN KEY (IngressCarrierKey)REFERENCES
Carriers_1 (CarrierKey) DEFERRABLE;
ALTER TABLE QoS_1 ADD FOREIGN KEY (EgressCarrierKey)REFERENCES
Carriers_1 (CarrierKey) DEFERRABLE;
ALTER TABLE QoS_1 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_1
(RouteKey) DEFERRABLE;
ALTER TABLE QoS_2 ADD FOREIGN KEY (IngressCarrierKey)REFERENCES
Carriers_2 (CarrierKey) DEFERRABLE;
ALTER TABLE QoS_2 ADD FOREIGN KEY (EgressCarrierKey)REFERENCES
Carriers_2 (CarrierKey) DEFERRABLE;
ALTER TABLE QoS_2 ADD FOREIGN KEY (RouteKey) REFERENCES Routes_2
(RouteKey) DEFERRABLE;
ALTER TABLE IngressRoutes_1 ADD FOREIGN KEY (RouteKey)REFERENCES
Routes_1 (RouteKey) DEFERRABLE;
ALTER TABLE IngressRoutes_1 ADD FOREIGN KEY (AttributeKey)REFERENCES
IngressRouteAttributes_1 (AttributeKey) DEFERRABLE;
ALTER TABLE IngressRoutes_2 ADD FOREIGN KEY (RouteKey)REFERENCES
Routes_2 (RouteKey) DEFERRABLE;
ALTER TABLE IngressRoutes_2 ADD FOREIGN KEY (AttributeKey)REFERENCES
IngressRouteAttributes_2 (AttributeKey) DEFERRABLE;
ALTER TABLE EgressRoutes_1 ADD FOREIGN KEY (RouteKey) REFERENCES
Routes_1 (RouteKey) DEFERRABLE;
ALTER TABLE EgressRoutes_1 ADD FOREIGN KEY (AttributeKey) REFERENCES
EgressRouteAttributes_1 (AttributeKey) DEFERRABLE;
ALTER TABLE EgressRoutes_2 ADD FOREIGN KEY (RouteKey) REFERENCES
Routes_2 (RouteKey) DEFERRABLE;
ALTER TABLE EgressRoutes_2 ADD FOREIGN KEY (AttributeKey) REFERENCES
EgressRouteAttributes_2 (AttributeKey) DEFERRABLE;
\echo Foreign Keys done...
COMMIT;