I have a database named BusinessPass and a website that users can use to create Business Passes. Below is the web form.
Date | Time From | Time To | Location
The problem is the table design. Below is my proposed table design.
BusinessPassId, UserID, Date1, From1, To1, Location1, Date2, From2, To2, Location2.... and so on. There would be a maximum of up to 31 days. So I would have 126 columns total. Is there a better way to design this?