...
Field name | data | example | relationship |
|---|---|---|---|
id | internal unique id | dash_alias_staff.alias_id | |
data_hub | data hub it belongs to | ||
name | name of person | ||
email address | |||
normalisation | ???? | ||
role | role in the business | primary, support, auto, inactive |
public.dash_alias_staff
This is the staff ID as they appear in the source system.
Field name | data | example | relationship |
|---|---|---|---|
id | internal unique id | ||
data_hub | data hub it belongs to | ||
staff | user login name as per source system | ||
alias_id | join to id in alias table | dash_alias.id |
public.dash_dashboard
The header entry for each dashboard
public.dash_dashrow
Each row or item in a dashboard. Essentially each visualisation you see in the dashboard and its configuration wrt. which chart, its position etc.
public.dash_report
Each report that is designed
public.dash_row
Each row or item in a Report (as opposed to a dashboard).