proj.sql

来自「本系统实现了软件项目开发的流程管理和控制」· SQL 代码 · 共 22 行

CREATE TABLE Proj
  (ProjId	Int Primary Key IDENTITY,
  ProjName	Varchar(50) NOT NULL,
  Status	Tinyint,
  Client	Varchar(50), 
  Contact	Varchar(50),
  Ctel		Varchar(50),
  ApplyDate	Varchar(10),
  ApplyEmp	Varchar(50),
  StartDate	Char(10),
  Softmanager	Varchar(300),
  Amount0	Decimal(15,2),
  Benefit0	Decimal(15,2),
  FinishDate0	Char(10),
  Amount	Decimal(15,2),
  Benefit	Decimal(15,2),
  FinishDate	Char(10),
  TesterSign	Varchar(50),
  SQASign	Varchar(50),
  ApplyerSign	Varchar(50)
  )