[thelist] Representing tasks in the database

kasimir-k kasimir.k.lists at gmail.com
Thu Apr 26 10:59:49 CDT 2007


Bill Moseley scribeva in 26/04/2007 13:42:
> Here's where I'm looking for ideas:  a task can be dependent on one or
> more other tasks being completed.  That is, the task itself cannot be
> marked completed until the task or tasks it depends on are completed.
> 
> ... I know Joe Celko has written quite a bit about representing trees

One thing I noted here is that you don't actually have trees, as the 
dependencies are many-to-many relations. In a tree any item has exactly 
one parent (except the root item).

.k



More information about the thelist mailing list