EFACS Browser

Read-only structure and broad data-source overview from efacdb_full.
This screen must never write to EFACS. Hide/show preferences are stored locally in Monolith only; the EFACS data and structure are not changed.
Objects
438
Showing
158
Hidden by default/rule
228
Database
efacdb_full
Reset

Tables and Views

Schema-first broad sweep; open a table for columns/indexes/status counts.
ObjectCategoryRows est.SizeUpdatedNotesVisibility
zAR-BIP-model-step-runs
BASE TABLE · InnoDB
Custom/model/helper tables172433.05 MB2026-05-28 18:07:16-
zCRT_retained_CalcCostHistory
BASE TABLE · InnoDB
Custom/model/helper tables934,006253.70 MB2026-04-03 14:25:29-
zAR-BIP-model-step-events
BASE TABLE · InnoDB
Custom/model/helper tables257,178137.80 MB2026-05-28 18:07:16-
zAR-BIP-template-steps
BASE TABLE · InnoDB
Custom/model/helper tables539,43084.17 MB2026-05-17 16:31:47-
zAR-BIP-paramset-bom
BASE TABLE · InnoDB
Custom/model/helper tables380,90779.13 MB2026-05-17 16:30:10-
zBSC_inputs_BOM
BASE TABLE · InnoDB
Custom/model/helper tables382,09248.59 MB--
zCRU_PartWorkcentres
BASE TABLE · InnoDB
Custom/model/helper tables213,61337.61 MB2026-04-03 13:50:28-
ztmpCostrollupCleanbom
BASE TABLE · InnoDB
Custom/model/helper tables385,82537.59 MB--
zAR-BIP-paramset-routings
BASE TABLE · InnoDB
Custom/model/helper tables95,38532.08 MB2026-05-17 16:30:10-
zAR-BIP-model-run-purchases
BASE TABLE · InnoDB
Custom/model/helper tables166,79731.84 MB2026-05-20 07:36:37-
zCRU_CleanBOM
BASE TABLE · InnoDB
Custom/model/helper tables360,66931.58 MB--
zCRU_PartWorkcentreSummary
BASE TABLE · InnoDB
Custom/model/helper tables289,44330.06 MB2026-04-03 13:52:16-
zCRU_output_CleanBOM_ExPhantom
BASE TABLE · InnoDB
Custom/model/helper tables442,96426.58 MB--
zBSC_workings_02_stepcosts
BASE TABLE · InnoDB
Custom/model/helper tables96,00226.56 MB--
zCRU_CostRollup_20251101
BASE TABLE · InnoDB
Custom/model/helper tables92,08920.06 MB--
ztmpCostrollupParts
BASE TABLE · InnoDB
Custom/model/helper tables91,91317.55 MB--
zCRU_Rollup
BASE TABLE · InnoDB
Custom/model/helper tables92,66016.03 MB2026-04-03 13:52:10-
zBSC_inputs_Parts
BASE TABLE · InnoDB
Custom/model/helper tables91,91915.03 MB--
zAR-BIP-stateset-stockedparts
BASE TABLE · InnoDB
Custom/model/helper tables35,84914.08 MB2026-05-17 16:31:08-
zCSA_order_prices
BASE TABLE · InnoDB
Custom/model/helper tables36,00312.58 MB--
zCMP_CostRollup_toMatchCRU
BASE TABLE · InnoDB
Custom/model/helper tables92,71712.55 MB2026-04-03 14:26:44-
zBSC_workings_01_demand
BASE TABLE · InnoDB
Custom/model/helper tables82,31912.52 MB--
zBSC_inputs_Routing
BASE TABLE · InnoDB
Custom/model/helper tables95,44512.03 MB--
zCRT_output_PricesForAPI
BASE TABLE · InnoDB
Custom/model/helper tables92,96310.52 MB2026-04-03 14:25:41-
ztmpCostrollupRoutings
BASE TABLE · InnoDB
Custom/model/helper tables98,86010.52 MB--
zAR-BIP-template-headers
BASE TABLE · InnoDB
Custom/model/helper tables69,64210.03 MB2026-05-17 16:31:47-
zCRU_RoutingUnit
BASE TABLE · InnoDB
Custom/model/helper tables90,65510.03 MB2026-04-03 13:49:45-
zCRU_RoutingUnitCapped
BASE TABLE · InnoDB
Custom/model/helper tables90,51310.03 MB2026-04-03 13:49:47-
zCMP_output_PricesForAPI_20251203
BASE TABLE · InnoDB
Custom/model/helper tables92,6559.52 MB--
zCRT_outputs_CurrentCleanCost
BASE TABLE · InnoDB
Custom/model/helper tables93,3729.03 MB2026-04-03 14:25:31-
zAR-BIP-model-run-stock-movements
BASE TABLE · InnoDB
Custom/model/helper tables29,1678.55 MB2026-05-20 07:31:10-
zCRU_Parts
BASE TABLE · InnoDB
Custom/model/helper tables93,6588.52 MB2026-04-03 13:50:32-
zBSC_workings_rtg_agg
BASE TABLE · InnoDB
Custom/model/helper tables58,8587.52 MB--
zCRU_PartOwnStepCost
BASE TABLE · InnoDB
Custom/model/helper tables93,0067.52 MB--
zCMP_output_ExtensiontoCRU
BASE TABLE · InnoDB
Custom/model/helper tables93,5186.52 MB--
zCRU_PartChecks
BASE TABLE · InnoDB
Custom/model/helper tables92,8916.52 MB--
zCRU_output_CleanRouting_ExPhantom
BASE TABLE · InnoDB
Custom/model/helper tables89,7666.52 MB--
zAR-BIP-model-run-demand-orders
BASE TABLE · InnoDB
Custom/model/helper tables16,5576.11 MB--
zHCAssembly_Parts
BASE TABLE · InnoDB
Custom/model/helper tables1,2245.70 MB2026-06-06 21:58:18-
zBSC_results_summary
BASE TABLE · InnoDB
Custom/model/helper tables92,4175.52 MB--
zCMP_inputs_YearOfOrderItems
BASE TABLE · InnoDB
Custom/model/helper tables36,6113.52 MB2026-04-03 14:25:49-
zCRU_PartStepRoutingCost
BASE TABLE · InnoDB
Custom/model/helper tables58,5633.52 MB--
zHCK_classifyAsUsedOrShipped
BASE TABLE · InnoDB
Custom/model/helper tables53,4553.52 MB--
zHCK_monthlyTally_ByRawPart
BASE TABLE · InnoDB
Custom/model/helper tables19,5853.52 MB--
zAR-BIP-model-run-completions
BASE TABLE · InnoDB
Custom/model/helper tables5,1622.63 MB2026-05-20 07:31:10-
zAR-BIP-paramset-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables3,7212.63 MB2026-05-17 16:30:10-
zCMP_workings_YearOfOrderItems_WithPeriod
BASE TABLE · InnoDB
Custom/model/helper tables24,3472.52 MB2026-04-03 14:25:49-
zt2
BASE TABLE · InnoDB
Custom/model/helper tables68,7752.52 MB--
zAR-BIP-stateset-stock-by-location
BASE TABLE · InnoDB
Custom/model/helper tables8,8652.22 MB2026-05-17 16:31:08-
zAR-BIP-stateset-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables9251.59 MB2026-05-17 16:31:08-
zAR-BIP-stateset-purchase-orderitems
BASE TABLE · InnoDB
Custom/model/helper tables8711.56 MB2026-05-17 17:09:07-
zCMP_results_AllForecasts
BASE TABLE · InnoDB
Custom/model/helper tables6,1601.52 MB2026-04-03 14:25:50-
zCMP_results_ExtrapolateFromLast
BASE TABLE · InnoDB
Custom/model/helper tables5,9841.52 MB2026-04-03 14:25:50-
zCMP_results_ExtrapolateFromLine
BASE TABLE · InnoDB
Custom/model/helper tables6,0621.52 MB2026-04-03 14:25:50-
zCMP_results_PurchaseCostLimits
BASE TABLE · InnoDB
Custom/model/helper tables5,7271.52 MB2026-04-03 14:25:50-
zCMP_workings_LinearRegression
BASE TABLE · InnoDB
Custom/model/helper tables6,1631.52 MB2026-04-03 14:25:50-
zCMP_workings_MonthsSinceOrder
BASE TABLE · InnoDB
Custom/model/helper tables13,5581.52 MB2026-04-03 14:26:26-
zCMP_workings_YearOfOrderItems_Averages
BASE TABLE · InnoDB
Custom/model/helper tables6,0071.52 MB2026-04-03 14:25:49-
zHCK_classificationofsteps
BASE TABLE · InnoDB
Custom/model/helper tables12,4161.52 MB--
zt3
BASE TABLE · InnoDB
Custom/model/helper tables11,3031.52 MB--
zAR-BIP-stateset-wo-stocktransactions-summary
BASE TABLE · InnoDB
Custom/model/helper tables2,2621.28 MB2026-05-17 16:31:08-
zAR-BIP-stateset-wip
BASE TABLE · InnoDB
Custom/model/helper tables1,2821.17 MB2026-05-17 16:31:08-
zCRT_inputs_VolumeSetLines
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:27:15-
zCRT_inputs_VolumeSetLines_ord
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSetLines_ship
BASE TABLE · InnoDB
Custom/model/helper tables7,0790.69 MB2026-04-02 21:31:36-
zAR-BIP-model-run-allocations
BASE TABLE · InnoDB
Custom/model/helper tables1,9740.63 MB2026-05-20 07:31:10-
zCMP_output_LeadTimesEstimate
BASE TABLE · InnoDB
Custom/model/helper tables6,4400.50 MB--
zAR-BIP-model-run-day-summary
BASE TABLE · InnoDB
Custom/model/helper tables1,5220.45 MB2026-05-20 07:31:10-
zAR-BIP-stateset-worksorders
BASE TABLE · InnoDB
Custom/model/helper tables5500.42 MB2026-05-17 16:31:08-
zFCS_product_stats_latest
BASE TABLE · InnoDB
Custom/model/helper tables3,4460.42 MB--
zCMP_workings_LastTradedPrice
BASE TABLE · InnoDB
Custom/model/helper tables6,0440.36 MB2026-04-03 14:25:50-
zCMP_workings_LastTradedPeriod
BASE TABLE · InnoDB
Custom/model/helper tables6,0950.31 MB2026-04-03 14:25:50-
zAR-BIP-paramset-orders
BASE TABLE · InnoDB
Custom/model/helper tables6970.28 MB--
zHCAssembly_TargetList
BASE TABLE · InnoDB
Custom/model/helper tables30.25 MB2026-06-07 06:53:30-
zAR-BIP-stateset-orders
BASE TABLE · InnoDB
Custom/model/helper tables2240.20 MB--
zHKU_AnnualDemandV1
BASE TABLE · InnoDB
Custom/model/helper tables2,1150.19 MB--
zBSC_inputs_Demand
BASE TABLE · InnoDB
Custom/model/helper tables2,2900.17 MB--
zFCS_master_products
BASE TABLE · InnoDB
Custom/model/helper tables3,2830.17 MB--
zCRT_log
BASE TABLE · InnoDB
Custom/model/helper tables4450.16 MB2026-04-03 14:25:46-
zAR-BIP-stateset-purchase-orders
BASE TABLE · InnoDB
Custom/model/helper tables2250.13 MB--
zAR-HRA-workings-user-audit
BASE TABLE · InnoDB
Custom/model/helper tables940.13 MB2026-05-11 09:48:40-
zCRT_retained_LastAppliedPriceChange
BASE TABLE · InnoDB
Custom/model/helper tables3050.13 MB2026-04-03 14:25:41-
ztmpAnnualDemandModel
BASE TABLE · InnoDB
Custom/model/helper tables1,0390.13 MB--
zAR-BIPI-instance-headers
BASE TABLE · InnoDB
Custom/model/helper tables5690.11 MB2026-05-17 16:31:49-
zBSC_reports_OrphanManufactured
BASE TABLE · InnoDB
Custom/model/helper tables1,4450.11 MB--
zCRT_retained_PriceHistory
BASE TABLE · InnoDB
Custom/model/helper tables3050.11 MB2026-04-03 14:25:41-
zCRU_ArbitraryStepCost
BASE TABLE · InnoDB
Custom/model/helper tables1,4730.09 MB2026-04-03 13:50:32-
zAR-BIP-model-run-week-summary
BASE TABLE · InnoDB
Custom/model/helper tables2110.08 MB2026-05-20 07:31:10-
zAR-HRA-workings-user-profiles
BASE TABLE · InnoDB
Custom/model/helper tables40.08 MB2026-05-11 07:40:21-
zSOE_picklist_uom_learning
BASE TABLE · InnoDB
Custom/model/helper tables1250.08 MB2026-05-26 11:27:05-
zAR-BIP-model-runs
BASE TABLE · InnoDB
Custom/model/helper tables30.06 MB2026-05-20 07:36:37-
zAR-BIP-paramsets
BASE TABLE · InnoDB
Custom/model/helper tables10.06 MB2026-05-17 16:31:16-
zAR-BIP-statesets
BASE TABLE · InnoDB
Custom/model/helper tables20.06 MB2026-05-17 17:09:07-
zAR-HRA-workings-activity-blocks
BASE TABLE · InnoDB
Custom/model/helper tables50.06 MB2026-05-11 07:47:34-
zAR-HRA-workings-day-change-requests
BASE TABLE · InnoDB
Custom/model/helper tables20.06 MB2026-05-11 09:48:40-
zAR-HRA-workings-holiday-requests
BASE TABLE · InnoDB
Custom/model/helper tables60.06 MB2026-05-11 07:33:13-
zAR_DRR_executions
BASE TABLE · InnoDB
Custom/model/helper tables00.06 MB--
zAR_DRR_procedures
BASE TABLE · InnoDB
Custom/model/helper tables30.06 MB--
zCRT_mgr_Run
BASE TABLE · InnoDB
Custom/model/helper tables300.06 MB2026-04-03 14:25:46-
zHSP_output_pricestoupdate
BASE TABLE · InnoDB
Custom/model/helper tables2840.06 MB--
zPipeline_SP_Log
BASE TABLE · InnoDB
Custom/model/helper tables390.06 MB2026-04-03 14:26:47-
zAR-BIP-staffing-set-days
BASE TABLE · InnoDB
Custom/model/helper tables130.05 MB--
zAR-BIP-staffing-sets
BASE TABLE · InnoDB
Custom/model/helper tables10.05 MB--
zAR-HRA-workings-actual-hours-submissions
BASE TABLE · InnoDB
Custom/model/helper tables310.05 MB2026-05-11 07:42:38-
zAR-HRA-workings-hour-entries
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zAR-HRA-workings-people
BASE TABLE · InnoDB
Custom/model/helper tables30.05 MB2026-05-09 13:07:41-
zAR-HRA-workings-sickness-events
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zAR-HRA-workings-team-leader-change-requests
BASE TABLE · InnoDB
Custom/model/helper tables40.05 MB2026-05-11 07:40:23-
zAR-HRA-workings-team-links
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_inputs_TractrixConfig
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_TractrixHistory
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_TractrixState
BASE TABLE · InnoDB
Custom/model/helper tables00.05 MB--
zCRT_retained_VolumeSetSummary
BASE TABLE · InnoDB
Custom/model/helper tables60.05 MB2026-04-03 14:25:41-
zCRT_workings_MinSalesFloorTargets_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables3030.05 MB--
zCSA_bounds
BASE TABLE · InnoDB
Custom/model/helper tables80.05 MB--
zAR-BIP-labour-capacity-recruitment
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-labour-capacity-sets
BASE TABLE · InnoDB
Custom/model/helper tables30.03 MB--
zAR-BIP-labour-capacity-staff
BASE TABLE · InnoDB
Custom/model/helper tables400.03 MB--
zAR-BIP-paramset-stock-by-location
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-paramset-wo-stocktransactions-summary
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zAR-BIP-workcentre-set-items
BASE TABLE · InnoDB
Custom/model/helper tables950.03 MB--
zAR-BIP-workcentre-sets
BASE TABLE · InnoDB
Custom/model/helper tables10.03 MB--
zAR-HRA-workings-admin-leave-events
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-10 10:06:26-
zAR-HRA-workings-user-hour-templates
BASE TABLE · InnoDB
Custom/model/helper tables70.03 MB2026-05-09 20:49:29-
zBIPmodel3_ai_requests
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-29 16:06:51-
zBIPmodel3_instruction_packs
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB2026-05-29 16:06:51-
zBIPmodel3_model_summaries
BASE TABLE · InnoDB
Custom/model/helper tables00.03 MB--
zCRT_inputs_VolumeSets
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:27:14-
zCRT_inputs_VolumeSets_ord
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSets_ship
BASE TABLE · InnoDB
Custom/model/helper tables60.03 MB2026-04-02 21:31:35-
zAR-BIP-paramset-stockedparts
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-paramset-wip
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-paramset-worksorders
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zAR-BIP-workcentre-settings
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB2026-05-28 17:42:43-
zBSC_inputs_Workcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB--
zBSC_params
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB--
zCRT_inputs_VolumeSetTargets
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:27:14-
zCRT_inputs_VolumeSetTargets_ord
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:30:40-
zCRT_inputs_VolumeSetTargets_ship
BASE TABLE · InnoDB
Custom/model/helper tables60.02 MB2026-04-02 21:31:35-
zCRT_workings_FamilyDiscountApplied_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables1010.02 MB--
zCRT_workings_FamilyDiscountPartids_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables1010.02 MB2026-04-03 14:25:41-
zCRT_workings_MinSalesFloorApplied_zz_tmp
BASE TABLE · InnoDB
Custom/model/helper tables2040.02 MB--
zCRU_Workcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB2026-04-03 13:49:39-
zFCS_baseline_params
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_calc_jobs
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_calc_lock
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zFCS_demand_view_daily
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zHCAssembly_Config
BASE TABLE · InnoDB
Custom/model/helper tables40.02 MB2026-06-07 06:53:30-
zHCK_datesfor4weeks
BASE TABLE · InnoDB
Custom/model/helper tables280.02 MB--
zHCK_months
BASE TABLE · InnoDB
Custom/model/helper tables120.02 MB--
zHCK_parentparts
BASE TABLE · InnoDB
Custom/model/helper tables870.02 MB--
zHCK_timesbychildanddateandworkcentre
BASE TABLE · InnoDB
Custom/model/helper tables930.02 MB--
zMSP_todays_pricing_table
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zSOE_receiving_sessions
BASE TABLE · InnoDB
Custom/model/helper tables170.02 MB2026-04-30 14:49:59-
zSOE_shipment_quantity_received
BASE TABLE · InnoDB
Custom/model/helper tables40.02 MB--
zUMP_modified_pos_processing
BASE TABLE · InnoDB
Custom/model/helper tables00.02 MB--
zUMP_updating_modified_pos
BASE TABLE · InnoDB
Custom/model/helper tables560.02 MB--
ztmpCostrollupWorkcentres
BASE TABLE · InnoDB
Custom/model/helper tables950.02 MB--