Table: AHL_MR_ROUTES

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores the associations of maintenance requirements to routes.
Implementation/DBA Data:	AHL.AHL_MR_ROUTES

Primary Key: AHL_MR_ROUTES_PK

1. MR_ROUTE_ID

Primary Key: AHL_MR_ROUTES_UK1

1. ROUTE_ID
2. MR_HEADER_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_MR_ROUTES		AHL_MR_HEADERS_B	AHL_MR_ROUTES.MR_HEADER_ID
AHL_MR_ROUTES		AHL_ROUTES_B	AHL_MR_ROUTES.ROUTE_ID
AHL_MR_ROUTE_SEQUENCES		AHL_MR_ROUTES	AHL_MR_ROUTE_SEQUENCES.MR_ROUTE_ID
AHL_MR_ROUTE_SEQUENCES		AHL_MR_ROUTES	AHL_MR_ROUTE_SEQUENCES.RELATED_MR_ROUTE_ID
AHL_VISIT_TASKS_B		AHL_MR_ROUTES	AHL_VISIT_TASKS_B.MR_ROUTE_ID