The foreign keys were to the same table... I ended up breaking up each row into multiple rows.
On Jan 21, 3:16 pm, Steve <step...@foundfamily.co.uk> wrote: > Presumably the foreign keys are all keys to different tables ? > > If this is the case then it is usual to name the key after the table it > references. > > So table foo may contain... > > bar_id ( reference to id field of table bar ) > baz_id I reference to id field of table baz ) > > etc > > > > On Fri, 2011-01-21 at 12:42 -0800, opike wrote: > > 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?- Hide quoted text - > > - Show quoted text - -- 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
