SWO-Certificate
This category groups 5 relationships in the Ramco Aviation domain.
Edges
SWO_HAS_CERTIFICATE — ShopWorkOrder → SWOCertificate
SWO has certificate of maintenance
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swoccm_com_certificate_dtl
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swoccm_com_certificate_dtl.swoccm_swo_no - Inference:
child_fk_to_parent_pk
SWO_HAS_CONFORMITY_CERT — ShopWorkOrder → SWOConformityCert
SWO has conformity certificate
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swococ_conformity_cert_list
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swococ_conformity_cert_list.swococ_swo_no - Inference:
parent_pk_in_child
SWO_HAS_CALIBRATION_CERT — ShopWorkOrder → CalibrationCert
SWO has calibration certificate
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swocol_calibration_cert_list
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocol_calibration_cert_list.swocol_swo_no - Inference:
parent_pk_in_child
SWO_HAS_MFG_CERT — ShopWorkOrder → MfgCertificate (no automatic join)
SWO has manufacturing certificate
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_prtmfg_certificate_dtl
SWO_HAS_COMLIST — ShopWorkOrder → COMList
SWO has COM list
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swocom_com_list
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocom_com_list.swocom_swo_no - Inference:
parent_pk_in_child