issues when implementing an inventory

• yogiberr

  Hall of Fame

  Points: 3679

  More actions

  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.

• Frank Kalis

  SSC Guru

  Points: 111183

  More actions

  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]

• yogiberr

  Hall of Fame

  Points: 3679

  More actions

  January 5, 2004 at 5:45 am

  #488645

  Hi Frank.

  Looks like I have most things covered.

  Nice site.

  Cheers,

  yogiberr