assets1.sql

来自「用visual c＋＋＆sql开发的企业固定资产管理系统。」· SQL 代码 · 共 23 行

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