[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
RE: Inventory class proposal
From: |
Alejandro Imass |
Subject: |
RE: Inventory class proposal |
Date: |
Tue, 31 Oct 2000 10:07:06 -0800 (PST) |
>
> To show that this works well for us we currently
> have over 3 million item
> codes in our system comprised of stock and non
> stock. My suggestion is that
> a varchar(23) should be the minimum and that since
> it's varchar storage
> space will not be an issue since it is trimmed
> before storage into the
> database table.
>
> Also it may be better to rename the column from
> ItemNum to ItemCode since it
> is not necessarily a number.
>
OK :-] good points.
I will be moving this discussion per Derek's sugestion
soon. Any person interested I think should susbscribe
there.
__________________________________________________
Do You Yahoo!?
Yahoo! Messenger - Talk while you surf! It's FREE.
http://im.yahoo.com/