Visit
This category groups 6 relationships in the Ramco Aviation domain.
Edges
VISIT_HAS_CONFIG — VisitPackage → VisitConfig
Visit has configuration
- Source table: SWO_Visit_Lvl_Info
- Target table: SWO_Visit_Lvl_Cmp_config
- SQL join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvl_Cmp_config.VSC_unique_id - Inference:
parent_pk_in_child
VISIT_HAS_BASELINE — VisitPackage → VisitBaselineConfig
Visit has baseline configuration
- Source table: SWO_Visit_Lvl_Info
- Target table: SWO_Visit_Lvlb_Cmpb_config
- SQL join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_Lvlb_Cmpb_config.VSBC_unique_id - Inference:
parent_pk_in_child
VISIT_HAS_COMPLETION — VisitPackage → VisitCompletion
Visit has completion record
- Source table: SWO_Visit_Lvl_Info
- Target table: swo_visit_cmpl_dtl
- SQL join:
SWO_Visit_Lvl_Info.visit_id = swo_visit_cmpl_dtl.vcp_uniqueid - Inference:
parent_pk_in_child
VISIT_HAS_PLAN_EO — VisitPackage → VisitPlanEO (no automatic join)
Visit has planned EO
- Source table: SWO_Visit_Lvl_Info
- Target table: swo_visit_plan_eo_dtl
VISIT_HAS_LLP_INFO — VisitPackage → VisitLLPInfo
Visit has LLP information
- Source table: SWO_Visit_Lvl_Info
- Target table: SWO_Visit_LLP_Info
- SQL join:
SWO_Visit_Lvl_Info.visit_id = SWO_Visit_LLP_Info.VLLP_Component_ID - Inference:
parent_pk_in_child
CONFIG_HAS_DETAIL — VisitConfig → VisitConfigDetail
Config has detail records
- Source table: SWO_Visit_Lvl_Cmp_config
- Target table: SWO_Visit_Lvl_Cmp_cfg_dtl
- SQL join:
SWO_Visit_Lvl_Cmp_config.VSC_unique_id = SWO_Visit_Lvl_Cmp_cfg_dtl.VSD_unique_id - Inference:
suffix_match