Looks confusing, sorry :) Trying to transform your tables into a workable ER model (not CakePHP model):
A user may have one or more phone numbers A user may have one or more addresses Each phone number belongs to one user Each address belongs to one user An address may have one or more details A detail belongs to one address Tables: users - id (primary key, auto number) - other necessary columns that you may require. - created - modified phonenumbers - id (primary key, auto number) - user_id (foreign key to table users) - other necessary columns that you may require. - created - modified addresses - id (primary key, auto number) - user_id (foreign key to table users) - other necessary columns that you may require. - created - modified addressdetails - id (primary key, auto number) - address_id (foreign key to table addresses) - other necessary columns that you may require. - created - modified Do I understand your schema correctly? John On Dec 2, 11:11 am, anand angadi <[email protected]> wrote: > Hi John, > > Sorry here its attached now... > > Cheers: > Anand > > shcema.bmp > 1299KViewDownload Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions. You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
