Table: AHL_ROUTE_OPERATIONS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the association between Routes and Operations.
Implementation/DBA Data:	AHL.AHL_ROUTE_OPERATIONS

Primary Key: AHL_ROUTE_OPERATIONS_PK

1. ROUTE_OPERATION_ID

Primary Key: AHL_ROUTE_OPERATIONS_UK1

1. ROUTE_ID
2. OPERATION_ID
3. STEP

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_ROUTE_OPERATIONS		AHL_ROUTES_B	AHL_ROUTE_OPERATIONS.ROUTE_ID
AHL_ROUTE_OPERATIONS		AHL_OPERATIONS_B	AHL_ROUTE_OPERATIONS.OPERATION_ID
AHL_ROUTE_OPERATIONS_H		AHL_ROUTE_OPERATIONS	AHL_ROUTE_OPERATIONS_H.ROUTE_OPERATION_ID