Skip to content

manufacturing

sqllocks_spindle.domains.manufacturing

Manufacturing domain — production, quality control, and material management.

Classes

ManufacturingDomain

Bases: Domain

Manufacturing domain — production lines, work orders, quality, and equipment.

Available schema modes
  • 3nf: Normalized schema with proper 3NF relationships

Tables (3NF mode): - production_line: Manufacturing lines - product: Products - bom: Bill of materials - work_order: Production work orders - quality_check: QC inspections - defect: Defect records - equipment: Machines and tools - downtime_event: Downtime tracking - production_metric: Production KPIs

Methods:
star_schema_map()

Return the star schema mapping for the Manufacturing domain.

Produces
  • dim_product (from product)
  • dim_production_line (from production_line)
  • dim_equipment (from equipment)
  • dim_date (generated from start_date / check_date / start_time)
  • fact_work_order (from work_order)
  • fact_quality (from quality_check + work_order)
  • fact_downtime (from downtime_event)
cdm_map()

Return the CDM entity map for the Manufacturing domain.