[thelist] inventory database design question
rudy
r937 at interlog.com
Sun Mar 9 07:00:01 CST 2003
> Am I right to combine these two in the same tables?
that's such a black and white word, "right"
yes, i think you are
> Would that be a robust setup, or am I overlooking something?
i like it a lot
if you are thinking of calculating profit, which i suspect from
column names like PriceIn and PriceOut, you just have to be
careful how you handle nulls in the serial number
FIFO works in sql, but it can get complicated if all you have
is the dates that the inventory came in
rudy
More information about the thelist
mailing list