[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