# aspcodenet/dbt architecture

> Architecture diagram of the GitHub repository aspcodenet/dbt, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-18). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/aspcodenet/dbt
- Repository: https://github.com/aspcodenet/dbt

## Overview

The repository appears to be a dbt analytics project for OrderSystem data, organized into staging, intermediate, and mart models. The README is empty and no source excerpts are available, so the model dependencies and source definitions cannot be verified; the graph shows the distinct transformation areas without asserting unsupported relationships.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_staging["Staging"]
  node_stg_customers["Staged customers"]
  node_stg_order_items["Staged order items"]
  node_stg_orders["Staged orders"]
  node_stg_products["Staged products"]
end

subgraph group_intermediate["Intermediate"]
  node_enriched_items["Enriched order items"]
end

subgraph group_marts["Marts"]
  node_dim_customers["Customer dimension<br/>[dim_customers.sql]"]
  node_dim_products["Product dimension<br/>[dim_products.sql]"]
  node_fct_order_items["Order-item facts"]
  node_fct_orders["Order facts<br/>[fct_orders.sql]"]
end

click node_stg_customers "https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_customers.sql"
click node_stg_order_items "https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_order_items.sql"
click node_stg_orders "https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_orders.sql"
click node_stg_products "https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_products.sql"
click node_enriched_items "https://github.com/aspcodenet/dbt/blob/main/myproject/models/intermediate/int_order_items_enriched.sql"
click node_dim_customers "https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/dim_customers.sql"
click node_dim_products "https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/dim_products.sql"
click node_fct_order_items "https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/fct_order_items.sql"
click node_fct_orders "https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/fct_orders.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_stg_customers,node_stg_order_items,node_stg_orders,node_stg_products toneBlue
class node_enriched_items toneAmber
class node_dim_customers,node_dim_products,node_fct_order_items,node_fct_orders toneMint
```

## Components

### Staging

- [Staged customers](https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_customers.sql): `myproject/models/staging/stg_ordersystem_customers.sql`
- [Staged order items](https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_order_items.sql): `myproject/models/staging/stg_ordersystem_order_items.sql`
- [Staged orders](https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_orders.sql): `myproject/models/staging/stg_ordersystem_orders.sql`
- [Staged products](https://github.com/aspcodenet/dbt/blob/main/myproject/models/staging/stg_ordersystem_products.sql): `myproject/models/staging/stg_ordersystem_products.sql`

### Intermediate

- [Enriched order items](https://github.com/aspcodenet/dbt/blob/main/myproject/models/intermediate/int_order_items_enriched.sql): `myproject/models/intermediate/int_order_items_enriched.sql`

### Marts

- [Customer dimension](https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/dim_customers.sql): `myproject/models/marts/dim_customers.sql`
- [Product dimension](https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/dim_products.sql): `myproject/models/marts/dim_products.sql`
- [Order-item facts](https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/fct_order_items.sql): `myproject/models/marts/fct_order_items.sql`
- [Order facts](https://github.com/aspcodenet/dbt/blob/main/myproject/models/marts/fct_orders.sql): `myproject/models/marts/fct_orders.sql`
