Generic Relationship Table

From: Bret Gregory (bret.gregor..ccesspointinc.com)
Date: Mon May 03 2004 - 11:24:26 EDT

  • Next message: Bryan Lewis: "Re: how to specify objectId for new object"

    I would like to create a generic relationship table to handle my
    many-to-many relationships.

    For example:
    Charge to Order (n:m)
    Charge to Charge (n:m)

    I would like to have a single table for the flattened relationships. That
    relationship table would have a "type" column that would be used to
    differentiate between the different relationships.

    So I would have something like in the Rel table:

    Charge ID "Charge-Order" Order ID
    Charge A ID "Charge-Charge" Charge B ID

    Is this possible? Any suggestions?

    This archive was generated by hypermail 2.0.0 : Mon May 03 2004 - 11:25:49 EDT