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 |