Saturday, January 28, 2012

Re: jointable combined jointable

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.17 (MingW32)

iQEcBAEBAgAGBQJPI7Q5AAoJEBO4N45mnLn2LuIH/1PvCeS9zA0Hur+LzWijTbJi
o+SQ9+regMkuwA6ARmRD2fqgqRiK7bDW+p3iNC5gLuCLCaqV6kP/8ELVZu00xhQ/
qqeNLsMhpNZSebs+Cqhwy7HZEPLXLpGuEIaTVybEl4WhQF22uMg0UE+Dq7JBZfr4
aWaVY10uIsWuI/PNI3zWZREBPIFhH3XFNKi04QnK7e+9na/UAtzYjTHQ0l4AXYzh
oAasHMjmk9IjDxdfPmWhCWRyWBMFcX5ZumN/Xk+3xtKwE4JFibBw2/H01/Pc5Z+8
tWJ1HDBqIcrFjfC6vPLlwMyV2esTXaLmif/767FtOBDm6FJTsBA94JQgM/lAKlU=
=JD+w
-----END PGP SIGNATURE-----
Maybe i should rename the table users in employees.
For example:

A company has 20 employees. The company gets a job from his customer. So
i decied that 5 of my employees work on this job.
There we got the habtm jobs_users.
When the job is completed i will make a delivery note with positions for
every work, which has been done. Every position could be done by one or
more of the 5 teammembers from jobs_users.
So i tried to make a jointable between positions and jobs_users and name
this table jobs_users_positions. But it seems not to work.

Best regards

Dennis

Am 27.01.2012 19:31, schrieb Kaupo Vana:
> Hi,
>
> I'm don't know the background of this task so the users habtm jobs looks a
> bit strange to me but if you want to keep the position concept then you can
> create a model for this.
>
> Table positions with fileds id, user_id, job_id and give habtm relationship
> to deliverynotes.
>
> Best regards,
> Kaupo
>

No comments: