Design Problem

Hi everyone,

I have this problem.

Bascially i have 13 rooms that can be rented out in hour slots
from 9am till 8pm
this only needs to last from 6 days monday to saturday

so bscially i can have all 13 rooms rented out for each our of each day.

but i am wondering how i can create this kind of structure in a database using postgresql.

i would like to use Arrays, compisite types and inheritence where ever possible to solve the solution.

Thanks everyone