Inventory Design-Example of inventory table

Create Table Stockpile/* database table */
(
Stockpile_id int identity (1, 1) not null,/* inventory number, primary key */
Dept_id int not null,/* Department of the product, foreign key (refer to the dept table )*/
Storehouse_id int not null,/* Warehouse, foreign key (refer to the sotrehouse table )*/
Product_id int not null,/* product number, foreign key (refer to the product table )*/
Firstenterdate datetime not null,/* The first import time of the product */
Lastleavedate datetime null,/* the last time this item was delivered */
Quantity int not null,/* quantity */
Price money not null/* weighted price */
/* When lastleavedate is null, this product has never been sold */
)