How do I implement some sort of reservation or booking in my mysql database?

How do I implement some sort of reservation or booking in my mysql database?

I'm currently doing a project that is a kind of booking or reservation
system and I would like to solicit ideas as to how to design a database
that has a profile of a specific item and that item should have timeslots
for a certain day in which a user can place a reservation or borrow the
equipment for example, 9-10am, aug. 19, 2013(that means the equipment will
be marked as unavailable for 9-10am, aug. 19, 2013 and available for the
other timeslots and the days in which it hasnt been reserved. So far, I've
designed a table(tbl_reserve) which contains a referenceID,
equipmentbCode(barcode of equipment), dateReserved, timeCode(this is used
to connect the tbl_reserve to another table named tbl_timeSlots where
there are the columns timeCode, timeIN, timeOUT).
Meaning to say a certain equipment has a different timeslot for another
day ranging from 7am-9pm.