Jump to content


Photo

Design issues - help needed [warning noob@work here]


  • Please log in to reply
2 replies to this topic

#1 Whoever

Whoever
  • New Members
  • Pip
  • Newbie
  • 4 posts
  • LocationDenmark

Posted 24 August 2003 - 12:52 AM

Suppose I have a table TASKS, that contains, well, tasks and related information, such as name, startdate, enddate, infotext and such.

And I have another table USERS that contains user information, such as..well, what usually goes into a USER table. :P

Now Im trying to find some way of having a TASK have multiple users associated AS WELL as a USER having multiple tasks associated.

Any idea how to do that?

Thanks in advance
Whatever happened to sex, drugs and rock \'n\' roll [br]Now we just have AIDS, crack and techno.

#2 effigy

effigy
  • Staff Alumni
  • Advanced Member
  • 3,600 posts
  • LocationIL

Posted 24 August 2003 - 01:21 AM

something like this, i believe:

users:=====================| userid | username |=====================| 1      | bob      |=====================tasks:=====================| taskid | taskinfo |=====================| 1      | mop      |=====================| 2      | vacuum   |=====================assignments:==============================| assignid | taskid | userid |==============================| 1        | 1      | 1      |==============================| 2        | 2      | 1      |==============================

Regexp | Unicode Article | Letter Database
/\A(e)?((1)?ff(?:(?:ig)?y)?|f(?:ig)?)\z/

#3 Whoever

Whoever
  • New Members
  • Pip
  • Newbie
  • 4 posts
  • LocationDenmark

Posted 24 August 2003 - 01:54 AM

thanks effigy, I actually got the same answer from another person about 30 minutes ago, but its nice to see it validated!

Thanks
:D
Whatever happened to sex, drugs and rock \'n\' roll [br]Now we just have AIDS, crack and techno.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users