I have a database with multiple companies - just like multi-tenant software.
Each company can have a list of items - say cars, buildings etc
I want to push meter data into a table in the database and marry it to the item. For example, I want to record the car mileage in the meter table:
Company A - VW Golf
Company B - Building A
Company A - Aston Martin
Company C - Airplane
Company A - VW Golf - 12000 - KMs - Today’s date
Company B - Building A - 24 - Degrees Celsius - Today’s date
Is that possible? If so, any resources you could point me to so I can achieve that?