product.sql

库存管理系统

USE Stock
GO
CREATE TABLE Product
  (Pid 		int PRIMARY KEY IDENTITY,
   Pname 	varchar(50) NOT NULL,
   TypeId	int,
   Pstyle	varchar(50),
   Punit	varchar(10),
   Pprice	decimal(15, 2),
   Plow	int,
   Phigh	int,
   Valid	int,
   AlarmDays	int
  )
GO