First, let me explain the scenario and then I have several follow up questions.
I am trying to develop a solution where I am calculating water usage of every Tap in a Flat (normally a flat would have around 10 to 30 taps).
Taps have unique id (TapdID ).
Then I am trying to aggregate the Consumption of each Tap in a Flat which will be total Water usage of each Tap in a Flat . This value keeps on updating itself until next Where is saved on to Data table with Consumption of Water against Each Date.
ScreenShot of Properties of a Tap in A flat are as follows :
Data coming from Taps are stored in value Stream , Screenshot of Value of Stream is follows:
As we can see clearly , Currently , we have different TapIDs which have Water Consumption in one Flat (#802) which is in building (10 ) and the building is in Project (44).
So , For a Flat , TapID and Rate of Flow of Water through the tap may change and we have calculate the Water Consumption based on this .
Considering this would be used for many projects which could have several buildings and each building could have several flats and flat then could have several taps which are the end data points. What would be the best data modelling practice around this use case.
Comments and suggestion and explanation on this would be highly appreciated.
Thank you in Advance !