Hey guys/girls. I just finished my FIRST real sql database. I have saved a screenshot of the database relationships diagram. I haven't started writing the program yet, but any suggestions in the database design would be appreciated before I get to the programming phase. I used smallint, smallmoney, smalldatetime, and varchar wherever possible for the fields. The ID fields are all smallint, set to be identity, increment 1, and seed 1. Is that appropriate?

The reason for all the movement fields is the items will be shuttled several times and need to be tracked for each person handling the products. The way the items will move is, store, truck driver, warehouse, driver, service shop, driver, warehouse, driver, store. It's alot of handling, but it's the way our company functions at this moment.

Here's the JPG of the relationships diagram: http://www.geocities.com/stillmidnig...ipsDiagram.jpg

Thanks!