Jump to content

Archived

This topic is now archived and is closed to further replies.

Whoever

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

Recommended Posts

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

Share this post


Link to post
Share on other sites

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      |

==============================

Share this post


Link to post
Share on other sites

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

 

Thanks

:D

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.