Master Data
This category groups 8 relationships in the Ramco Aviation domain.
Edges
STATION_HAS_TIMEZONE — Station → Timezone
Station has timezone
- Source table: CM_STNDTL_STATION_DTL
- Target table: CM_TZDTL_TIMEZONE_DTL
- SQL join:
CM_STNDTL_STATION_DTL.created_area_code = CM_TZDTL_TIMEZONE_DTL.created_area_code - Inference:
suffix_match
TIMEZONE_HAS_DST — Timezone → DaylightSaving
Timezone has daylight saving rules
- Source table: CM_TZDTL_TIMEZONE_DTL
- Target table: CM_TZDLS_DAYLIGHTSAVING_DTL
- SQL join:
CM_TZDTL_TIMEZONE_DTL.TZDTL_TIMEZONE_NO = CM_TZDLS_DAYLIGHTSAVING_DTL.TZDLS_TIMEZONE_NO - Inference:
suffix_match
MEL_HAS_CONFIG — MELCategory → MELConfig
MEL category has configuration
- Source table: CFG_CFGMELC_MEL_CATEGORY
- Target table: CFG_CFGMEL_MDL_CONFIG_MEL
- SQL join:
CFG_CFGMELC_MEL_CATEGORY.CFGMELC_CATEGORY = CFG_CFGMEL_MDL_CONFIG_MEL.CFGMEL_CATEGORY - Inference:
parent_pk_in_child
TASK_HAS_SPARE — TaskMaster → TaskSparePart
Task master has spare parts
- Source table: BAS_TSK_TSK_TASK_MASTER
- Target table: bas_tsk_tskp_spare_part
- SQL join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskp_spare_part.TSKP_TASK_NO - Inference:
parent_pk_in_child
TASK_HAS_MODEL_EFFECT — TaskMaster → TaskModelEffect
Task has model effectivity
- Source table: BAS_TSK_TSK_TASK_MASTER
- Target table: bas_tsk_tskme_mdl_effect
- SQL join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskme_mdl_effect.TSKME_TASK_NO - Inference:
parent_pk_in_child
CUSTOMER_IN_OU — Customer → OrganizationUnit (virtual target)
Customer belongs to OU
- Source table: Cu_CMH_Cust_Master_Hdr
- Target table: —
TASK_HAS_SUBTASK — TaskMaster → TaskDetails
Task master has details
- Source table: BAS_TSK_TSK_TASK_MASTER
- Target table: bas_tsk_tskd_task_details
- SQL join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = bas_tsk_tskd_task_details.TSKD_TASK_NO - Inference:
parent_pk_in_child
TASK_AT_WORKAREA — TaskMaster → TaskWorkArea
Task master has work area
- Source table: BAS_TSK_TSK_TASK_MASTER
- Target table: BAS_TSK_TSKWZ_TSK_WRK_AREA
- SQL join:
BAS_TSK_TSK_TASK_MASTER.TSK_TASK_NO = BAS_TSK_TSKWZ_TSK_WRK_AREA.TSKWZ_TASK_NO - Inference:
parent_pk_in_child