On Oct 25, 2007, at 2:24 PM, William Perng wrote:
There is a many to many relationship between OrderHeader table andTrackingCode table. I thought many(OrderHeader) to one (TrackingCode) shouldbe good enough. Could anyone please tell me what's the design idea(or business benefit) behind this ?
In general tracking codes are attached to visiting of certain URLs or other things. There can certainly be more than one in a session, though usually one per tracking code type attached to orders. All codes seen during the session are attached to the Visit though.
-David
smime.p7s
Description: S/MIME cryptographic signature