Hi friends,

I'm new to designing databases. We are developing a new Inventory System and I am task to help create the tables/entities associated with the system. Can you help give some links of sample tables about Inventory System pls. where i can prototype or pattern our
new system.

We are monitoring the lumber supplies in a Furniture Production Co.
And we have lots of lumber suppliers. We have a recieving storage area(in diff state) and production area(in another state).

I have identified the following tables:

1. supplier_table
2. lumber_table
3. inventory1(stocks received)
3. inventory2(stocks on hand)
4. inventory3(stocks delivered)

I want to know when im going out of lumber and order to the supplier.

Thanks a lot in advance