setting up a table relationship
От | Mag Gam |
---|---|
Тема | setting up a table relationship |
Дата | |
Msg-id | AANLkTiksfCWcEoZoRkzT8VngWZDeFILqQIfCBA8NShes@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: setting up a table relationship
|
Список | pgsql-novice |
I have some data like this 2010/06/26 Task A:started at 5:30AM:ended 6:00AM Task B:started at 5:30AM:ended 7:00AM Task C:started at 5:45AM:ended 6:00AM Task D:started at 7:30AM:ended 11:00AM 2010/06/25 Task A:started at 1:30AM:ended 6:00AM Task B:started at 1:30AM:ended 7:00AM Task C:started at 2:45AM:ended 6:00AM Task D:started at 3:30AM:ended 11:00AM 2010/06/24 Task A:started at 3:30AM:ended 6:02AM Task B:started at 4:30AM:ended 7:04AM Task C:started at 8:45AM:ended 12:04PM Task D:started at 7:30AM:ended 11:01AM I would like to do metric such as, "On 2010/06/25 what was the longest task", "how does task B look for X number of days", etc.. I setup 2 tables, task and t. Task is for the task and t is for the time. Now, I am getting confused on how to setup this relationship. This should be a many-to-many relationship. Can anyone give me advise on how to better organize this data? TIA
В списке pgsql-novice по дате отправления: