AME
This category groups 4 relationships in the Ramco Aviation domain.
Edges
CONTAINS_TASK — AMEPackage → Task (no automatic join)
Package contains task work units
- Source table: FLOG_TLGMN_TECH_LOG_HDR
- Target table: FLOG_TLGWU_WORK_UNIT_DTL
HAS_CERTIFICATE — AMEPackage → CertificateOfMaintenance
Package has certificate of maintenance
- Source table: FLOG_TLGMN_TECH_LOG_HDR
- Target table: FLOG_TLGCOM_TECH_COM_DTL
- SQL join:
FLOG_TLGMN_TECH_LOG_HDR.TLGMN_TECHLOG_NO = FLOG_TLGCOM_TECH_COM_DTL.TLgCOM_TechLog_No - Inference:
parent_pk_in_child
BELONGS_TO_OU — AMEPackage → OrganizationUnit (virtual target)
Package belongs to organization unit
- Source table: FLOG_TLGMN_TECH_LOG_HDR
- Target table: —
HAS_COMPONENT_REPLACEMENT — AMEPackage → COMPONENT_REPLACEMENT (no automatic join)
Package has component replacement records
- Source table: FLOG_TLGMN_TECH_LOG_HDR
- Target table: BAS_CR_CRD_COMP_REPL_DTL