Re: jointable combined jointable

Usually cakePHP will complain when you have incorrectly formatted table names and foreign keys.

if you have

• users
• jobs

and made habtm

• jobs_users { id, job_id, user_id }

then those two tables will be baked properly.  Assuming that you have FK named properly.

You mentioned 

• Delivery Note
• Positions

I am not clear if you need deliverynotepositions or deliverynote and deliverynote_positions

meaning,

you can have either

• deliverynotepositions

or

• deliverynote_positions

and you could add user_id to the table and create FK

hope I did not misunderstand your question...

On Sat, Jan 28, 2012 at 12:39 AM, Dennis Reinert-Frerich <drf77@gmx.net> wrote:

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
>

--

Richard Joo

Director of Innovation

Telelanguage, Inc.

Support Options:

Email your problem or question to tickets@telelanguage.com

Submit a ticket to http://ticket.telelanguage.com 

Call 1.888.983.5352 and press 3

For best support please submit a ticket using the email or website method first and write down your ticket ID.  You can track the progress of the ticket by using the ticket website.   

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php