Table: AHL_MEL_CDL_RELATIONSHIPS

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This table stores relationships between a pair of ATA sequences across the same MEL/CDL
Implementation/DBA Data:	AHL.AHL_MEL_CDL_RELATIONSHIPS

Primary Key: AHL_MEL_CDL_RELATIONSHIPS_PK

1. MEL_CDL_RELATIONSHIP_ID

Primary Key: AHL_MEL_CDL_RELATIONSHIPS_UK1

1. ATA_SEQUENCE_ID
2. RELATED_ATA_SEQUENCE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_MEL_CDL_RELATIONSHIPS		AHL_MEL_CDL_ATA_SEQUENCES	AHL_MEL_CDL_RELATIONSHIPS.ATA_SEQUENCE_ID
AHL_MEL_CDL_RELATIONSHIPS		AHL_MEL_CDL_ATA_SEQUENCES	AHL_MEL_CDL_RELATIONSHIPS.RELATED_ATA_SEQUENCE_ID