MachineOperation

### 1. Overview
 The `MachineOperation` table serves as a functional mapping between physical machines (`mccode`) and the specific manufacturing operations (`oprcode`) they are capable of performing. This table is foundational for production planning and routing, ensuring that jobs are scheduled on equipment that possesses the necessary capabilities (e.g., a specific VMC machine assigned to a "VMC2" operation).
 
 ### 2. Column Dictionary
 
 | Column | Type | Nullable | Meaning | Allowed Values | SQL Usage |
 | :--- | :--- | :--- | :--- | :--- | :--- |
 | **compcode** | string | No | Unique identifier for the company or business unit. | e.g., "DAS" | Primary filter for multi-tenant data isolation. |
 | **mccode** | string | No | The physical Machine Code identifier. | e.g., "VMC191", "240", "ROLLING" | Used to join with the master machine registry. |
 | **oprcode** | string | Yes | The Operation Code representing a specific task or process step. | e.g., "VMC", "TRI", "IBH", "CNC" | Used to link machines to production routing and labor steps. |
 
 ### 3. Relationships & Join Map
 
 The `MachineOperation` table acts as a bridge between equipment assets and process definitions.
 
 #### Primary Joins (Validated by SCHEMA_MAP)
 * **dbo.machine**: Join via `mccode` and `compcode` to retrieve machine specifications, models, and locations.
 * **dbo.oprmas**: Join via `oprcode` and `compcode` to get detailed operation names and station codes.
 * **dbo.machineitem**: Join via `mccode`, `oprcode`, and `compcode` to find specific production rates or set times for an item on a specific machine/operation combination.
 
 #### Production & Execution Joins
 * **dbo.product2 / dbo.RMproduct1**: Join `MachineOperation.mccode` to `machine_cd` and `oprcode` to analyze production history or efficiency by machine capability.
 * **dbo.assemblyprodhdr**: Join via `mccode` and `compcode` to track assembly headers.
 * **dbo.DownTime100HDR**: Join via `mccode` and `compcode` to correlate machine downtime with its assigned operation types.
 
 #### Likely Joins (Inferred)
 * **dbo.itemopr**: Likely joins on `oprcode` and `compcode`. Note that `itemopr` uses `maccode` which is likely synonymous with `mccode`.
 
 ---