SQL representation

Hi,

I need to do a planning (monday - sunday) with some jobs during 1 hour.

How could I build the tables ?

Please help me.

Re: SQL representation

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