product.sql

来自「这是一个库存管理系统」· SQL 代码 · 共 16 行

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