Materialized view to obtain the information of the user responsible for each device
Fields
| Field | Type | Description |
|---|---|---|
| device_id* | INT | Unique device identifier |
| user_email | NVARCHAR (510) | Email from the user responsible for the device |
| user_id* | INT | Unique identifier of the user responsible for the device |
| user_name* | NVARCHAR (510) | Name of the user responsible for the device |