Cisco Systems PXM Version 1.1 Guía de usuario Pagina 103

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 110
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de 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;
Vista de pagina 102

Comentarios a estos manuales

Sin comentarios