Schema — Tables

One page per SQLite table (152 total). Each page documents the columns with descriptions from Ramco's own DDL, the primary key, relationships to other tables, and 3 sample rows pulled from the live database.

By process

COMPMAINTENANCE / BasMAK (3 tables)

• swo_Kit_DemCov_SrcBas_Info — 82,007 rows
• swo_Kit_Ref_Dtl — 82,253 rows
• swo_Kit_Spec_Src_Price_Info — 361 rows

COMPMAINTENANCE / BasSWO (82 tables)

• SWO_CMP_RNGCON_USAGE_BREAKUP — 740 rows
• SWO_Config_review_record — 787 rows
• SWO_DES_ERROR — 2,842 rows
• SWO_Error_Map — 0 rows
• SWO_Swoisu_Issue_dtl — 10,157 rows
• SWO_VISIT_CFG_DTL_REV_BASELINE — 50,000 rows
• SWO_Visit_DFT_COMP_Draft_DTL — 44,855 rows
• SWO_Visit_LLP_Info — 675 rows
• SWO_Visit_Lvl_Cmp_cfg_dtl — 50,000 rows
• SWO_Visit_Lvl_Cmp_config — 4,988 rows
• SWO_Visit_Lvl_Info — 3,567 rows
• SWO_Visit_Lvlb_Cmpb_cfg_dtl — 42,116 rows
• SWO_Visit_Lvlb_Cmpb_config — 920 rows
• SWO_WO_MR_Coverage_dtl — 1,812 rows
• SWO_visit_Target_Cmp_cfg_dtl — 10,897 rows
• Swo_SwoMR_Mat_Req_Dtl — 13,296 rows
• Swo_direct_part_cons_dtl — 224 rows
• Swo_exedw_engg_drawing — 40 rows
• Swo_sgnof_authentication — 8 rows
• swo_adlsoff_tsk_dtl — 262 rows
• swo_chdis_chd_discrepancy_det — 738 rows
• swo_core_status_metadata — 10 rows
• swo_eo_reltsk_dtl — 1,982 rows
• swo_hdr_core_status_metadata — 9 rows
• swo_msgprt_upd_dtl — 0 rows
• swo_pln_upgrade_ws_dtl — 179 rows
• swo_prtmfg_certificate_dtl — 25,091 rows
• swo_separated_tsk_maint_lvl_dtl — 12 rows
• swo_separated_tsk_swoprt_part_details — 75 rows
• swo_separatedtsk_sub_task_details — 520 rows
• swo_swoah_shop_wo_addl_hdr — 25,075 rows
• swo_swoassoc_main_core_dtl — 25,933 rows
• swo_swoccm_com_certificate_dtl — 1,594 rows
• swo_swocds_core_disassm_assemble_det — 5,033 rows
• swo_swoclk_emp_clock_dtl — 20,810 rows
• swo_swococ_conformity_cert_list — 22 rows
• swo_swocol_calibration_cert_list — 6 rows
• swo_swocolf_calibration_fac_dtl — 6 rows
• swo_swocom_certtype_apr_att — 100 rows
• swo_swocom_com_list — 939 rows
• swo_swocpl_certficate_print_log — 957 rows
• swo_swocrg_charge_details — 4 rows
• swo_swocrgh_charge_details_his — 0 rows
• swo_swocst_cost_summary — 19,365 rows
• swo_swodes_discrepancy_list — 1,760 rows
• swo_swoeid_emp_indirect_work_det — 147 rows
• swo_swoema_emp_actuals_dtl — 25,085 rows
• swo_swoerr_rout_message_dtl — 20 rows
• swo_swoh_shop_wo_hdr — 25,147 rows
• swo_swomt_Rout_metadata_dtl — 44 rows
• swo_swoobs_observation_list — 317 rows
• swo_swopm_param_upd_dtl — 0 rows
• swo_swoprm_task_param_det — 621 rows
• swo_swoprt_part_details — 64,659 rows
• swo_swoprth_part_details_his — 0 rows
• swo_swopsl_prefserlno_dtl — 19,091 rows
• swo_swoptg_part_tag_list — 67 rows
• swo_swoqcd_quick_code_dtl — 1,368 rows
• swo_sworc_res_consump_dtl — 2,646 rows
• swo_swores_swo_res_det — 0 rows
• swo_swortng_routing_dtl — 23,412 rows
• swo_swostk_sub_task_details — 17,249 rows
• swo_swosts_status_control_metadata — 16 rows
• swo_swotad_separated_tsk_addl_dtl — 521 rows
• swo_swotad_shop_wo_tsk_addl_dtl — 13,160 rows
• swo_swp_parameter_dtl — 1,341 rows
• swo_visit_cmpl_dtl — 1,163 rows
• swo_visit_dft_cmpl_dtl — 2,178 rows
• swo_visit_dft_plan_eo_dtl — 3,233 rows
• swo_visit_dft_pln_eotsk_dtl — 5,247 rows
• swo_visit_eo_cmpl_pos_dtl — 614 rows
• swo_visit_plan_eo_dtl — 0 rows
• swo_visit_pln_eotsk_dtl — 5,113 rows
• swo_wobsl_baseline_wo_hdr — 66 rows
• swo_wotskbsl_baseline_task_detail — 924 rows
• swo_wsa_amend_hdr — 388 rows
• swo_wsacg_amend_config_dtl — 137 rows
• swo_wsaref_reference_dtl — 15 rows
• swo_wsati_amend_maint_lvl_dtl — 1 rows
• swo_wsati_amend_task_pos_dtl — 24 rows
• swo_wsatsk_amend_task_impacted_dtl — 326 rows
• swo_wsatsk_task_amend_dtl — 1 rows

INVENTORY / BasPartAdmn (1 tables)

• PRT_PRCRL_CENTRALREFLIST_INFO — 50,000 rows

INVENTORY / BasStockAdmn (1 tables)

• SA_WRHSE_MSTR — 1,381 rows

LINEMAINTENANCE / BasDP (11 tables)

• DP_CFWDDTL_MEL_PART_CF_DTL — 0 rows
• DP_DEFHST_DISC_DEFERRAL_HST — 2,196 rows
• DP_DISCP_DISCREPANCY_DTL — 7,166 rows
• DP_DPDEF_DISC_DEFERRAL_DTL — 850 rows
• DP_DPMRDA_DOC_ATTACH_DTL — 0 rows
• DP_DPPRM_PARAMETER_DETAILS — 146 rows
• DP_MRUSG_USAGE_DEF_PARAM_VAL — 867 rows
• DP_PRMSCH_PARAM_SCHEDULE_DTL — 0 rows
• DP_RESLHST_DISC_RESOL_HIST — 20,591 rows
• DP_WUHST_RESL_WORKUNIT_HST — 9,367 rows
• Dp_DisCat_category_Dtl — 1 rows

LINEMAINTENANCE / BasFltLog (26 tables)

• FLOG_DFDPRSL_DEF_DISC_RESOL — 0 rows
• FLOG_FLMR_MAT_REQ_DTL — 4,534 rows
• FLOG_TLGCOM_TECH_COM_DTL — 52 rows
• FLOG_TLGCR_TECH_LOG_CR_DTL — 0 rows
• FLOG_TLGDA_DOC_ATTACH_DTL — 0 rows
• FLOG_TLGEA_EMP_ACTUALS_DTL — 4,487 rows
• FLOG_TLGEC_EXCOMM_HIST — 2,242 rows
• FLOG_TLGFIN_FINANCE_INFO — 0 rows
• FLOG_TLGMN_TECH_LOG_HDR — 5,736 rows
• FLOG_TLGPC_PART_CONSUMP_DTL — 14,441 rows
• FLOG_TLGRC_RES_CONSUMP_DTL — 43,718 rows
• FLOG_TLGSC_SOCOMM_HIST — 44,530 rows
• FLOG_TLGSKL_COM_SKILL_DTL — 2 rows
• FLOG_TLGSL_SERIAL_LOT_DTL — 45 rows
• FLOG_TLGSNG_TECH_LOG_SNAG_DTL — 7,021 rows
• FLOG_TLGSTSO_SUBTSK_SNOFF — 311,113 rows
• FLOG_TLGTSO_TSK_SNOFF — 189,289 rows
• FLOG_TLGWU_SUBTSK_DTL — 98,251 rows
• FLOG_TLGWU_WORK_UNIT_DTL — 0 rows
• FLOG_WORK_ASSIGN_DTL — 3,142 rows
• FL_TLISSRET_ISSUE_DTL — 1,317 rows
• Flog_TLgITM_Emp_Idir_Work_Hrs — 145 rows
• Flog_TlgPm_Param_Upd_Dtl — 388 rows
• flog_adlsoff_tsk_dtl — 843 rows
• flog_rbsc_bench_stk_cons_dtl — 118 rows
• flog_tlget_tsk_eliminate — 3,263 rows

MAINTPLANNING / BASAircraft (3 tables)

• AC_ACI_AIRCRAFT_INFO — 1,025 rows
• AC_ACPRT_AIRCRAFT_PART_INFO — 50,000 rows
• AC_CMPID_COMPONENT_ID_INFO — 50,000 rows

MAINTPLANNING / BASCm (6 tables)

• BAS_CM_DOC_CLASSI_ATT_DET — 18,699 rows
• BAS_CM_PRI_PRIORITY_NUMBER — 18 rows
• CM_RMVRSN_REMOVAL_REASONS — 18 rows
• CM_STNDTL_STATION_DTL — 113 rows
• CM_TZDLS_DAYLIGHTSAVING_DTL — 35 rows
• CM_TZDTL_TIMEZONE_DTL — 59 rows

MAINTPLANNING / BASConfig (2 tables)

• CFG_CFGMELC_MEL_CATEGORY — 19 rows
• CFG_CFGMEL_MDL_CONFIG_MEL — 68 rows

MAINTPLANNING / BASTask (7 tables)

• BAS_TSK_TRSO_RES_SIGNOFF — 10,284 rows
• BAS_TSK_TSKD_TASK_DETAILS — 50,000 rows
• BAS_TSK_TSKME_MDL_EFFECT — 57,907 rows
• BAS_TSK_TSKP_SPARE_PART — 20,643 rows
• BAS_TSK_TSKWZ_TSK_WRK_AREA — 6,912 rows
• BAS_TSK_TSK_TASK_MASTER — 50,000 rows
• TSK_TSKPRM_PARAM_READINGS — 44,852 rows

MAINTPLANNING / BASWc (7 tables)

• BAS_WCLOG_WC_LOGICAL_WC_DTL — 1,352 rows
• BAS_WC_FAC_FACILITY — 46,388 rows
• BAS_WC_WCCERA_WC_CERT_APPL — 2,917 rows
• BAS_WC_WCOUDT_OU_LEV_WCDET — 840 rows
• BAS_WC_WCUSR_WC_USER_MAP — 50,000 rows
• BAS_WC_WCWHM_WH_MAP — 1,585 rows
• wc_wccap_capacity — 21 rows

SSU / BasCu (1 tables)

• Cu_CMH_Cust_Master_Hdr — 684 rows

maintexecution / BasAMPlan (2 tables)

• swo_job_lvl_exe_phase — 3 rows
• swo_job_lvl_mile_stones — 43 rows