cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Joseph Schmidt <>
Subject Re: Conditional relationship mapping?
Date Tue, 31 Mar 2009 10:35:38 GMT

> Is it possible for Cayenne(and the Modeler) to map
> conditional relationships?
> I have a table, e.g. "tag" that relates to too many other
> tables, but one row is always related only to one table.
> This is done by having
> instead of many foreign keys columns, just with 2 in a
> generic way:
> - 'related_table' contains the name of the target table,
> and
> - 'related_row_id' is the 'id' of the row in the target
> table.
> I see this scenario in many schemes lately, where at least
> 3 or 4
> tables behave like the above "tag" table.
> Is it possible to map efficiently such a scenario with
> Cayenne(and the modeler)? If it is, how?

Any idea how to do this?
Or is it possible at all with Cayenne such scenarios?



View raw message