Data Model Overview

The Ramco Aviation data model ships as 152 tables organised across four business processes, each with sub-components. This page gives you the aerial view.

The four processes

Domain maps

Line maintenance (FLOG_* + DP_*)

FLOG_TLGMN_TECH_LOG_HDR  (AMEPackage header, key: TLGMN_TECHLOG_NO)
    ├─ FLOG_TLGSNG_TECH_LOG_SNAG_DTL    (snags reported)
    ├─ FLOG_TLGWU_WORK_UNIT_DTL         (tasks — empty in this drop, children still exist by TECHLOG_NO)
    ├─ FLOG_TLGWU_SUBTSK_DTL            (sub-tasks)
    ├─ FLOG_TLGTSO_TSK_SNOFF            (task sign-offs)
    ├─ FLOG_TLGSTSO_SUBTSK_SNOFF        (sub-task sign-offs)
    ├─ FLOG_TLGPC_PART_CONSUMP_DTL      (part consumption)
    ├─ FLOG_TLGRC_RES_CONSUMP_DTL       (resource/labour consumption)
    ├─ FLOG_TLGEA_EMP_ACTUALS_DTL       (employee actuals)
    ├─ FLOG_TLGEC_EXCOMM_HIST           (execution comments)
    ├─ FLOG_TLGSC_SOCOMM_HIST           (sign-off comments)
    ├─ FLOG_TLGSL_SERIAL_LOT_DTL        (serial/lot trace)
    ├─ FLOG_TLGCOM_TECH_COM_DTL         (certificate of maintenance)
    ├─ FLOG_FLMR_MAT_REQ_DTL            (material requests)
    ├─ fl_tlissret_issue_dtl            (issue/return)
    ├─ flog_rbsc_bench_stk_cons_dtl     (bench stock)
    ├─ flog_adlsoff_tsk_dtl             (additional sign-offs)
    ├─ flog_tlgpm_param_upd_dtl         (parameter updates)
    └─ FLOG_WORK_ASSIGN_DTL             (work assignments)

DP_DISCP_DISCREPANCY_DTL  (Discrepancy header)
    ├─ DP_DPDEF_DISC_DEFERRAL_DTL       (deferrals)
    ├─ DP_DEFHST_DISC_DEFERRAL_HST      (deferral history)
    ├─ DP_RESLHST_DISC_RESOL_HIST       (resolution history)
    ├─ DP_WUHST_RESL_WORKUNIT_HST       (workunit history)
    ├─ DP_DPPRM_PARAMETER_DETAILS       (parameter detail)
    ├─ DP_MRUSG_USAGE_DEF_PARAM_VAL     (usage parameters)
    └─ Dp_DisCat_category_Dtl            (categories)

Walkthrough: AME Package Flow + Discrepancy Lifecycle.

Shop WO (the big one — 82 SWO_* tables)

The SWO domain is by far the largest. Groupings:

• Header + additional — swo_swoh_shop_wo_hdr, swo_swoah_shop_wo_addl_hdr, swo_swotad_shop_wo_tsk_addl_dtl, swo_swotad_separated_tsk_addl_dtl
• Task + sub-task — swo_swostk_sub_task_details, swo_swoprm_task_param_det, swo_swp_parameter_dtl, swo_separatedtsk_sub_task_details
• Parts — swo_swoprt_part_details (3.87M rows — the monster), swo_swoprth_part_details_his, swo_separated_tsk_swoprt_part_details
• Labour — swo_swoema_emp_actuals_dtl, swo_swoclk_emp_clock_dtl, swo_swoeid_emp_indirect_work_det, swo_sworc_res_consump_dtl
• Routing + core — swo_swortng_routing_dtl, swo_swoassoc_main_core_dtl, swo_swocds_core_disassm_assemble_det
• Certificates — swo_swococ_conformity_cert_list, swo_swoccm_com_certificate_dtl, swo_prtmfg_certificate_dtl, swo_swocpl_certficate_print_log, swo_swocom_com_list, swo_swocom_certtype_apr_att
• Cost + charging — swo_swocst_cost_summary, swo_swocrg_charge_details, swo_swocrgh_charge_details_his
• Messaging + errors — swo_swoerr_rout_message_dtl, SWO_DES_ERROR, SWO_Error_Map, SWO_Swoisu_Issue_dtl
• Observations + discrepancies (shop-side) — swo_swoobs_observation_list, swo_swodes_discrepancy_list, swo_chdis_chd_discrepancy_det
• Kits + engineering drawings — swo_Kit_* (3 tables), Swo_exedw_engg_drawing
• Milestones + status + config — swo_job_lvl_mile_stones, swo_job_lvl_exe_phase, swo_swosts_status_control_metadata, swo_core_status_metadata, swo_hdr_core_status_metadata, swo_swomt_Rout_metadata_dtl
• Amendments — swo_wsa_amend_hdr, swo_wsacg_amend_config_dtl, swo_wsaref_reference_dtl, swo_wsati_* (2 tables), swo_wsatsk_* (2 tables)
• Separated-task variants — swo_separated_* (4 tables) and parallel separated_* variants
• Baselines — swo_wobsl_baseline_wo_hdr, swo_wotskbsl_baseline_task_detail, SWO_VISIT_CFG_DTL_REV_BASELINE
• Observation/prefserl/tag — swo_swoptg_part_tag_list, swo_swopsl_prefserlno_dtl, Swo_sgnof_authentication, Swo_direct_part_cons_dtl, Swo_SwoMR_Mat_Req_Dtl
• Engineering/upgrade — swo_eo_reltsk_dtl, swo_pln_upgrade_ws_dtl, swo_msgprt_upd_dtl, swo_swopm_param_upd_dtl, swo_swores_swo_res_det
• Conformity — swo_Config_review_record, SWO_CMP_RNGCON_USAGE_BREAKUP

Visit planning (SWO_Visit_*)

• Visit info — SWO_Visit_Lvl_Info, SWO_Visit_LLP_Info
• Configs — SWO_Visit_Lvl_Cmp_config, SWO_Visit_Lvl_Cmp_cfg_dtl, SWO_VISIT_CFG_DTL_REV_BASELINE, SWO_Visit_Lvlb_Cmpb_config, SWO_Visit_Lvlb_Cmpb_cfg_dtl, SWO_Visit_DFT_COMP_Draft_DTL, SWO_visit_Target_Cmp_cfg_dtl
• EOs — swo_visit_plan_eo_dtl, swo_visit_pln_eotsk_dtl, swo_visit_eo_cmpl_pos_dtl, swo_visit_dft_plan_eo_dtl, swo_visit_dft_pln_eotsk_dtl
• Completion — swo_visit_cmpl_dtl, swo_visit_dft_cmpl_dtl
• Material coverage — SWO_WO_MR_Coverage_dtl

Masters

• Aircraft / parts / components — AC_ACI_AIRCRAFT_INFO, AC_ACPRT_AIRCRAFT_PART_INFO, AC_CMPID_COMPONENT_ID_INFO
• Tasks — BAS_TSK_TSK_TASK_MASTER, bas_tsk_tskd_task_details, bas_tsk_tskme_mdl_effect, bas_tsk_tskp_spare_part, BAS_TSK_TSKWZ_TSK_WRK_AREA, bas_tsk_trso_res_signoff
• Work centers / facilities — see Work Center and Facility
• Customers — Cu_CMH_Cust_Master_Hdr
• MEL — CFG_CFGMEL_MDL_CONFIG_MEL, CFG_CFGMELC_MEL_CATEGORY, DP_CFWDDTL_MEL_PART_CF_DTL
• Reference — PRT_PRCRL_CENTRALREFLIST_INFO, BAS_CM_PRI_PRIORITY_NUMBER, CM_RMVRSN_REMOVAL_REASONS, BAS_CM_DOC_CLASSI_ATT_DET, CM_STNDTL_STATION_DTL, CM_TZDTL_TIMEZONE_DTL, CM_TZDLS_DAYLIGHTSAVING_DTL, SA_WRHSE_MSTR, wc_wccap_capacity, tsk_tskprm_param_readings

The 92 named relationships

The graph at brain/graph.json captures 92 semantic relationships across the model. Browse them by category: AME · AME Task · AME-Aircraft · Discrepancy · SWO · SWO Task · Visit · Master Data · and more at Relationships.

Empty tables (expected / noted)

15 tables have zero rows in this drop:

• DP_CFWDDTL_MEL_PART_CF_DTL, DP_DPMRDA_DOC_ATTACH_DTL, DP_PRMSCH_PARAM_SCHEDULE_DTL
• FLOG_DFDPRSL_DEF_DISC_RESOL, FLOG_TLGCR_TECH_LOG_CR_DTL, FLOG_TLGDA_DOC_ATTACH_DTL, FLOG_TLGFIN_FINANCE_INFO, FLOG_TLGWU_WORK_UNIT_DTL (the Task header — downstream tables still functional via TECHLOG_NO)
• SWO_Error_Map, swo_msgprt_upd_dtl, swo_swocrgh_charge_details_his, swo_swopm_param_upd_dtl, swo_swoprth_part_details_his, swo_swores_swo_res_det, swo_visit_plan_eo_dtl

Most of these are audit / history tables that the operator either doesn't use or didn't export. The schemas are still loaded so the Brain knows they exist.

See also

• Schema (auto-generated, one page per table)
• Ontology (entity types)
• Relationships (semantic graph)
• Masters Map · Aviation MRO Overview