I have a table 'foo' that contains foreign key pointers to a table 'bar' in a 1 to many relationship, but the foreign keys are listed as columns:
Table Foo: primary_key name bar_FK_1 bar_FK_2 bar_FK_3 bar_FK_4 ------------------------------------------------------------------------------------------------------ 1 A 10 11 12 13 2 B 20 21 22 23 etc.etc. I want to restructure this table so that it best fits cakephp's default conventions. Should I redesign the table with 3 columns and break up each row into multiple rows? And if so, should I then call the foreign key column bar_id? -- 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+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php