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 <[email protected]>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 [email protected]
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
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
