SWO
This category groups 5 relationships in the Ramco Aviation domain.
Edges
SWO_HAS_ADDITIONAL_HDR — ShopWorkOrder → SWOAdditionalHeader
SWO has additional header info
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swoah_shop_wo_addl_hdr
- SQL join:
swo_swoh_shop_wo_hdr.swoh_unique_id = swo_swoah_shop_wo_addl_hdr.swoad_unique_id - Inference:
suffix_match
SWO_HAS_COST_SUMMARY — ShopWorkOrder → CostSummary
SWO has cost summary
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swocst_cost_summary
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swocst_cost_summary.swocst_swo_no - Inference:
parent_pk_in_child
FOR_AIRCRAFT — ShopWorkOrder → Aircraft
SWO is for aircraft
- Source table: swo_swoh_shop_wo_hdr
- Target table: AC_ACI_AIRCRAFT_INFO
- SQL join:
swo_swoh_shop_wo_hdr.swoh_rem_aircraft_reg_no = AC_ACI_AIRCRAFT_INFO.ACI_AIRCRAFT_REG_NO - Inference:
manual_override
FOR_COMPONENT — ShopWorkOrder → ComponentID
SWO is for component
- Source table: swo_swoh_shop_wo_hdr
- Target table: AC_CMPID_COMPONENT_ID_INFO
- SQL join:
swo_swoh_shop_wo_hdr.swoh_component_id = AC_CMPID_COMPONENT_ID_INFO.CMPID_COMPONENT_ID - Inference:
child_fk_to_parent_pk
SWO_CONTAINS_TASK — ShopWorkOrder → SWOTask
Shop work order contains tasks
- Source table: swo_swoh_shop_wo_hdr
- Target table: swo_swostk_sub_task_details
- SQL join:
swo_swoh_shop_wo_hdr.swoh_swo_no = swo_swostk_sub_task_details.swostk_swo_no - Inference:
parent_pk_in_child