Posted by J.O. Aho on 10/01/11 11:37

Thoren wrote:
> Hi,
>
> I need to do a planning (monday - sunday) with some jobs during 1 hour.
>
> How could I build the tables ?

I think I would make a table with at least the following columns

start_time (int(unixtime)) | end_time (int(unixtime)) | description (varchar)


Why use unixtime?
php has quite good function to convert those easily to other formats like day
name, week, hour. It's enough to fetch the data from one column in the table
for many things to display.


//Aho

[Back to original message]