[thelist] Representing tasks in the database

Joel D Canfield joel at streamliine.com
Thu Apr 26 09:33:00 CDT 2007


> I'm looking for general ideas at this point.  Or maybe someone that
> says "Hey, I just did this!"

I built an org chart by just including a field 'supervisor' and made it reference the employee id in the same table

you could have a field 'precedent' for each task, pointing to the unique identifier of the task on which it depends. self-creating chain.

unless you have two unrelated precedents to our task, in which case you'll need a linking table, and be creating two chains backwards from said task.

joel

No virus found in this outgoing message.
Checked by AVG Free Edition. 
Version: 7.5.463 / Virus Database: 269.6.1/776 - Release Date: 4/25/2007 12:19 PM
 



More information about the thelist mailing list