# `database/views/`

Read-only views. Use for reporting / admin dashboards that benefit from a stable shape independent of underlying schema churn.

| File                    | Shape                                                      |
| ----------------------- | ---------------------------------------------------------- |
| `v_user_with_roles.sql` | One row per non-deleted user with `roles_csv` (STRING_AGG) |

Avoid using views from app code unless absolutely necessary — EF Core projections are easier to evolve.
