> ## Documentation Index
> Fetch the complete documentation index at: https://offthepace.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# dim_constructors

> One row per constructor (team).

<Note>Part of the [Reference](/transform/families/reference) family.</Note>

One row per constructor (team). Derived from stg\_laps with a manually maintained power-unit family mapping. pu\_family conditions constructor\_pace\_index on similar-engine teams in Layer 04 (e.g. Mercedes PU customers share base drag); update the mapping when customer relationships change.

## Lineage

```mermaid theme={null}
flowchart LR
  stg_laps --> dim_constructors
  dim_constructors --> fct_driver_skill_features
  dim_constructors --> fct_lap_residuals
  style dim_constructors fill:#e40404,stroke:#e40404,color:#fff
```

## Overview

| Property          | Value                                      |
| ----------------- | ------------------------------------------ |
| Layer             | `reference`                                |
| Family            | [Reference](/transform/families/reference) |
| Contract enforced | No                                         |
| Upstream          | [`stg_laps`](../stg/stg_laps)              |

**3 tests** [guard](/transform/ci/overview) this model  -  3 generic, 0 singular.

## Columns

| Column           | Type      | Nullable | Tests                                                                        | Description                                                                                                       |
| ---------------- | --------- | -------- | ---------------------------------------------------------------------------- | ----------------------------------------------------------------------------------------------------------------- |
| `constructor_id` | `varchar` | Yes      | [`not_null`](/transform/ci/structural), [`unique`](/transform/ci/structural) | Team name as reported by FastF1 (e.g. 'Mercedes', 'Red Bull Racing').                                             |
| `pu_family`      | `varchar` | Yes      | [`not_null`](/transform/ci/structural)                                       | Power-unit family grouping (e.g. mercedes\_pu, honda\_pu, ferrari\_pu, renault\_pu); 'unknown\_pu' when unmapped. |
