Looks to me that you're over complicating things. Whty not have:
Table "country" - primary key: (country_id) Table "state" - primary key: (state_id) - foreign key: (country_id) Table "city" - primary key: (city_id) - foreign key: (state_id) Tom CaioHC wrote: > Doubt: > > I have a schema in pgsql with composite foreign keys. > > Table "country" > - primary key: (country_id) > Table "state" > - primary key: (state_id, country_id) > - foreign key: (country_id) > Table "city" > - primary key: (city_id, state_id, country_id) > - foreign key: (state_id, country_id) > > I'm building the schema.xml from the already done schema in > postgresql. > > But propel doesn't represents the composite key in the city table, ii > just > point for country_id, instead country_id and state_id!!! > > I need help!!!!!!!! > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" 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/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
