---
title: Stock & Services Tables
slug: redshift/stock-and-services-tables
icon: {"lucideIcon":"Database"}
docTags: 
createdAt: 2026-10-01T12:37:49.892Z
---

```mermaid
%%{init: {'theme':'base', 'themeVariables': {'primaryColor':'#4CD0E2','primaryTextColor':'#002A32','primaryBorderColor':'#00778F','lineColor':'#00778F','secondaryColor':'#EDF8FA','tertiaryColor':'#FFFFFF','fontFamily':'DM Sans, sans-serif'}}}%%
erDiagram
    products ||--o{ product_stocks : product_id
    products }o--|| product_categories : category
    products ||--o{ product_reminders : product_id
    products ||--o{ treatments : product_id

    service_packages }o--|| available_services : service_id
    service_packages ||--o{ sold_service_packages : service_package_id
    service_packages }o--|| service_categories : "(via available_services)"

    reception_notes ||--o{ "reception_notes_products (internal only)" : nir_number
    "reception_notes_products (internal only)" ||--o| treatments : "nir_product_id"
```

**Note:** the box in quotes is not an exposed view — it's shown to make clear where `treatments.nir_product_id` actually points, even though you can't query that table directly. See [Stock & Services](docId\:up9_3heKVh32jzLj4BwZH) for what this means in practice.