[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