Room availability

I was wondering what would the best way to manage availability for rooms or beds like in a hostel (Saas). I was thinking about using MySQL and Elasticsearch. What would be the best schema for the rooms/bed table and availability table? Thanks a lot.