Timeline for Best way to put date range in a table in mySQL
Current License: CC BY-SA 4.0
6 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Aug 8, 2019 at 5:18 | vote | accept | Van Dyke | ||
Aug 6, 2019 at 18:46 | answer | added | John Herbert | timeline score: 3 | |
Aug 6, 2019 at 3:59 | comment | added | Van Dyke | It should be fairly simple. each resource (Eg: Room) is reservable on per date basis. and yes whole 365 days per year, I'm sorry i'm quite new to this and I don't know about Boolean arithmetic nor about scaling. I just want to store availability status for certain room on certain date. how can I do that? I'm open to even completely abandon my current table design and go into a new one | |
Aug 6, 2019 at 3:56 | comment | added | Van Dyke | I just want to store availability information for certain resource(Eg: Room) for certain date.(1 reservation is for whole day). I thought of having a row for weeks and then duplicate weeks with each day of the week. but i understand it's not good. if certain room is booked for certain date availability for that room should be false, so it can be skipped in searches. any idea how to accomplish that? | |
Aug 5, 2019 at 10:40 | review | First posts | |||
Aug 5, 2019 at 10:40 | |||||
Aug 5, 2019 at 10:35 | history | asked | Van Dyke | CC BY-SA 4.0 |