I need the user to select the minimum appointment lead time, to ensure that we receive adequate notice of new appointments before the client arrives. It can range from 4 hours to 2 days.
So in the drop-down menu I will include:
- 2 days
- 1 day
- 8 hours
- 4 hours
- 2 hours
- 1 hour
What is the best way to store that information on the database? What data type?