Post reply

issues when implementing an inventory

  • January 5, 2004 at 2:36 am

    #160327

    Hi,

    I am in the process of implementing an inventory.I've googled for sample articles, but no joy.

    As far as I can see, I have to store the items that belong to a particular shop, and mark them as in the "transfer pool" when a user wants to transfer them to another shop.

    schema so far:

    tblShop

    shopId

    productId

    qtyInStock

    qtyToBeTransferred

    This seems to be overly simple.I am sure that there are many other issues involved, and I'd rather find out sooner rather than later.Has anyone found any decent articles or gotchas that I should be aware of?

    Many thanks.

    yogi.

  • January 5, 2004 at 3:30 am

    #488642

    This site http://www.databaseanswers.com/data_models/ has quite a few basic data models available for free. Maybe it is of any help to you.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 5, 2004 at 5:45 am

    #488645

    Hi Frank.

    Looks like I have most things covered.

    Nice site.

    Cheers,

    yogiberr

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply