Stock & Services Tables

1 min

%%{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 for what this means in practice.