【SQL开源代码栏目提醒】:网学会员在SQL开源代码频道为大家收集整理了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)
)