assets1.sql

直接打开

USE Assets
GO
CREATE TABLE Assets
  (Id	int PRIMARY KEY IDENTITY,
   Aid	varchar(30) NOT NULL,
   Aname	varchar(50) NOT NULL,
   TypeId	tinyint,
   Model	varchar(30),
   Producer	varchar(100),
   UseDate	varchar(20),
   UsedYear	int,
   OrgPrice	decimal(15,2),
   Ratio	decimal(7,5),
   DeptId	int,
   RepPerson	varchar(30),
   Status	varchar(30),
   AddWay	varchar(30),
   IsAudit	int,
   PostDate	varchar(20),
   IsDiscount	tinyint
  )
GO