SWO Task
This category groups 13 relationships in the Ramco Aviation domain.
Edges
SWO_HAS_PARAM — SWOTask → TaskParam
SWO task has parameters
- Source table: swo_swostk_sub_task_details
- Target table: swo_swoprm_task_param_det
- SQL join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoprm_task_param_det.swoprm_swo_no - Inference:
child_fk_to_parent_pk
SWO_HAS_OBSERVATION — SWOTask → SWOObservation
SWO task has observations
- Source table: swo_swostk_sub_task_details
- Target table: swo_swoobs_observation_list
- SQL join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoobs_observation_list.swoobs_swo_no - Inference:
child_fk_to_parent_pk
SWO_HAS_CHILD_DISC — SWOTask → ChildDiscrepancy (no automatic join)
SWO task has child discrepancies
- Source table: swo_swostk_sub_task_details
- Target table: swo_chdis_chd_discrepancy_det
SWO_HAS_EO_RELATED — SWOTask → EORelatedTask (no automatic join)
SWO task has EO related tasks
- Source table: swo_swostk_sub_task_details
- Target table: swo_eo_reltsk_dtl
SWO_HAS_SUBTASK — SWOTask → SWOSubTask (no automatic join)
SWO task has subtasks
- Source table: swo_swostk_sub_task_details
- Target table: swo_swostk_sub_task_details
SWO_HAS_PART — SWOTask → SWOPartDetail
SWO task has part details
- Source table: swo_swostk_sub_task_details
- Target table: swo_swoprt_part_details
- SQL join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swoprt_part_details.swoprt_task_track_id - Inference:
child_fk_to_parent_pk
SWO_HAS_RESOURCE — SWOTask → SWOResourceDetail (no automatic join)
SWO task has resource details
- Source table: swo_swostk_sub_task_details
- Target table: swo_swores_swo_res_det
SWO_HAS_CHARGE — SWOTask → ChargeDetail
SWO task has charge details
- Source table: swo_swostk_sub_task_details
- Target table: swo_swocrg_charge_details
- SQL join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swocrg_charge_details.swocrg_task_track_id - Inference:
suffix_match
SWO_HAS_EMP_ACTUAL — SWOTask → SWOEmpActuals (no automatic join)
SWO task has employee actuals
- Source table: swo_swostk_sub_task_details
- Target table: TA_TD_TIMEBOOKING_DTL
SWO_TASK_ADDITIONAL — SWOTask → TaskAdditionalDtl
SWO task has additional details
- Source table: swo_swostk_sub_task_details
- Target table: swo_swotad_shop_wo_tsk_addl_dtl
- SQL join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swotad_shop_wo_tsk_addl_dtl.swotad_task_track_id - Inference:
child_fk_to_parent_pk
SWO_HAS_DISCREPANCY — SWOTask → SWODiscrepancy
SWO task has discrepancies
- Source table: swo_swostk_sub_task_details
- Target table: swo_swodes_discrepancy_list
- SQL join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swodes_discrepancy_list.swodes_swo_no - Inference:
child_fk_to_parent_pk
SWO_HAS_PART_TAG — SWOTask → PartTag
Task has part tags
- Source table: swo_swostk_sub_task_details
- Target table: swo_swoptg_part_tag_list
- SQL join:
swo_swostk_sub_task_details.swostk_swo_no = swo_swoptg_part_tag_list.swoptg_swo_no - Inference:
suffix_match
SWO_HAS_PREF_SERIAL — SWOTask → PrefSerialNo
Task has preferred serial numbers
- Source table: swo_swostk_sub_task_details
- Target table: swo_swopsl_prefserlno_dtl
- SQL join:
swo_swostk_sub_task_details.swostk_task_track_id = swo_swopsl_prefserlno_dtl.swopsl_task_track_id - Inference:
suffix_match