Table: AHL_MC_HEADERS_B

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	Stores Master Configuration Header details
Implementation/DBA Data:	AHL.AHL_MC_HEADERS_B

Primary Key: AHL_MC_HEADERS_B_PK

1. MC_HEADER_ID

Primary Key: AHL_MC_HEADERS_B_UK1

1. MC_ID
2. VERSION_NUMBER

Primary Key: AHL_MC_HEADERS_B_UK2

1. NAME
2. REVISION

Primary Key: AHL_MC_HEADERS_B_UK3

1. VERSION_NUMBER
2. NAME

Primary Key: AHL_MC_HEADERS_B_UK4

1. MC_ID
2. REVISION

Foreign Keys

Table		Foreign Table	Foreign Key Column
AHL_MC_CONFIG_RELATIONS		AHL_MC_HEADERS_B	AHL_MC_CONFIG_RELATIONS.MC_HEADER_ID
AHL_MC_HEADERS_TL		AHL_MC_HEADERS_B	AHL_MC_HEADERS_TL.MC_HEADER_ID
AHL_MC_RELATIONSHIPS		AHL_MC_HEADERS_B	AHL_MC_RELATIONSHIPS.MC_HEADER_ID
AHL_MC_RULES_B		AHL_MC_HEADERS_B	AHL_MC_RULES_B.MC_HEADER_ID
AHL_ROUTE_EFFECTIVITIES		AHL_MC_HEADERS_B	AHL_ROUTE_EFFECTIVITIES.MC_HEADER_ID
AHL_UC_HEADERS_H		AHL_MC_HEADERS_B	AHL_UC_HEADERS_H.MASTER_CONFIG_ID
AHL_UNIT_CONFIG_HEADERS		AHL_MC_HEADERS_B	AHL_UNIT_CONFIG_HEADERS.MASTER_CONFIG_ID