cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <>
Subject Re: Relationships without FK constraints?
Date Mon, 30 Mar 2009 07:19:17 GMT
I may have missed it being discussed already in this thread, but it  
occurs to me that inferring relationships based on the key naming  
convention is actually independent from reverse engineering, and can  
be a useful shortcut even if the model is built manually in the  
Modeler. So maybe we can have a separate menu item for that.


On Mar 27, 2009, at 6:30 PM, Joseph Schmidt wrote:

> Can Cayenne work (consistently) with relationships where the  
> underlying foreign key constraint is missing? (e.g. when the fields  
> for foreign key are there and respect the standard naming convention  
> - artist_id for the relationship pointing to artists but the  
> constraint is not set ?
> I tried to reverse engineer such databases, but if the FK  
> constraints are missing, Cayenne Modeler doesn't seem to recognize  
> them (despite of the naming convention) :(.
> It looks like many existing databases don't use the FK constraints  
> (only the naming convention - e.g. all RoR and similar frameworks  
> based applications).
> Thanks,
> Joseph.

View raw message