its fairly simple but you will not be able to "flatten" the relationship.
On 8/12/05, Tomas Jucius <entire..mail.com> wrote:
> I have many-to-many relationship with additional field "discount" in
> relational table..
>
> This is scheme:
>
> Table Order fields: order_id, .......other fields....
>
> Table OrderProduct: order_id, product_id, discount
>
> Table Product: product_id, ......other fields......
>
> When there is no "discount" when everything is fine..
>
> How to design such relationship with cayenne.. Is it possible..
>
> And if possible, when how I would have to add new product to orders
> (how about discount value)?
>
-- Joshua T. Pyle Go has always existed.
This archive was generated by hypermail 2.0.0 : Fri Aug 12 2005 - 16:23:52 EDT