How to design such relationship? is it possible at all with caenne?

From: Tomas Jucius (entire..mail.com)
Date: Fri Aug 12 2005 - 16:14:15 EDT

  • Next message: Gentry, Michael \(Contractor\): "RE: How to design such relationship? is it possible at all with caenne?"

    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)?

    This archive was generated by hypermail 2.0.0 : Fri Aug 12 2005 - 16:14:16 EDT