how data should be structured for desk reservation app
I was starting to build a desk reservation app but scratching my head how should I structure my data on the Sharepoint.
Per day I have only 50 desks available and user can select any date for the month. I am not sure how many Sharepoint list I should create to have 50 desks available per day basis calendar selection. User should also be able to see slots available for that day.
Any guidance on how many list I should create or how to source all the data in 1 list to cater to above requirement?