modeling question
Date: Mon, 07 Jul 2003 03:19:06 GMT
Message-ID: <22ohgvkqmjghmqbkmvriupgdjnklkfurjn_at_4ax.com>
I must store inTransit information for a logistics application. My
application has a retail and wholesale side.
Items can be intransit:
from one retail location to another
I have a table for retail locations and a table for wholesale
locations. These entities work different in the business process and
have different attributes so I think they should be modeled as
separate entities.
How should I physically implement this?
I see 4 solutions:
from one wholesale location to another
from a retail location to a wholesale location
from a wholesale location to a retail location
1) The inTransit table has 2 columns for the FROM location and 2
columns for the TO location. Ex. to_retail, to_wholesale,
from_retail, from_wholesale.
The drawbacks of this approach are that I have no way to enforce that
I would appreciate any advice you can give me. Received on Mon Jul 07 2003 - 05:19:06 CEST