Forum Discussion
top 5 VALUES by month
Hi,
Thank you for sharing.
However, it is difficult for me to understand the data model.
- Where can I find consumers information?
- Items table consists of item and each item has a ID
- Audit consists of the audit history of that item such as which operations they do to that item, (view it, edit it, export it etc), it also contains the ID of the item and the date that audit of that item took place.
- Activities is seperate table i created to define if an operation is a consumer activity or a admin activity. It connected to the audit table, so if the audit history table says the item was viewed, then i can state that was a consumer activity. If the audit table says that item was exported, then i know it was an admin activity.
The consumer is the operation they did from the audit history table labeled as a role.
Hope that makes sense