Cisco Systems PXM Version 1.1 Guida Utente Pagina 103

  • Scaricare
  • Aggiungi ai miei manuali
  • Stampa
  • Pagina
    / 110
  • Indice
  • SEGNALIBRI
  • Valutato. / 5. Basato su recensioni clienti
Vedere la pagina 102
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;
Vedere la pagina 102

Commenti su questo manuale

Nessun commento