proj.sql

用ｖｂ编的一个软件项目开发系统

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)
  )