Ask HN: Design patterns for granting access to data scoped to blocks of time?
Here's the basic business problem I'm trying to solve:
Let's say I have a car rental company. I rent cars one week at a time. I have reports for things like mileage over time periods for my renters to use.
Here's a scenario:
Customer 1 rents Car 1 for 1 week, drives 100 miles. Customer 2 then rents Car 1 for 1 week, drives 200 miles. Customer 1 rents Car 1 again for a week, and another 100 miles.
In my mileage report, I want to give Customer 1 access to the mileage accrued in by Car 1, but only for the blocks of time that they were the renters of the Car (so week 1 and week 3). Likewise, Customer 2 should only be able to access their block of time of rental (week 3).
Setting the UX concerns aside of chunks of missing data in a report, are there any established patterns out there for this type of query situation?