Skip to content

supply_chain

sqllocks_spindle.domains.supply_chain

Supply chain domain — warehouses, suppliers, purchasing, inventory, and logistics.

Classes

SupplyChainDomain

Bases: Domain

Supply chain and logistics domain.

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

Tables (3NF mode): - warehouse: Distribution centers with locations - supplier: Material and product suppliers - material: Raw materials and components - purchase_order: Purchase orders to suppliers - purchase_order_line: PO line items - inventory: Stock levels by warehouse and material - shipment: Inbound/outbound shipments - shipment_event: Shipment tracking events - quality_inspection: QA inspection results - demand_forecast: Forecasted demand by period

Methods:
star_schema_map()

Return the star schema mapping for the Supply Chain domain.

Produces
  • dim_supplier (from supplier)
  • dim_warehouse (from warehouse)
  • dim_material (from material)
  • dim_date (generated from order_date / ship_date / last_counted_date)
  • fact_po_line (from purchase_order_line + purchase_order)
  • fact_shipment (from shipment)
  • fact_inventory (from inventory)
cdm_map()

Return the CDM entity map for the Supply Chain domain.