I'm designing a system which is basically a booking engine. it uses separate table to store room data and separate table to store it's availability information (available date(s) ). I'm stuck in designing at the availability table.
This is the structure in my rooms table,
room_id room_type room_name etc...
This is my current availability table structure
room_id (int) week_id (int) date (datetime) availability (boolean)
is there any better way to achieve this?please help. even the tiniest advice will be greatly appreciated