表名：ZL_Answer












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Aidint40是是 否 答案ID
2Surveyidint40   否 问卷ID
3Qidint40   否 问题ID
4Answercontentnvarchar10000   否 答案内容
5Useridint40   是  
6Submitdatedatetime83   是 提交答案时间
7Submitipvarchar500   是 提交的IP地址
8AnswerScoreint40   是 提交答案得分

简要说明：

回复信息表


GO
CREATE TABLE [dbo].[ZL_Answer](
[Aid] [int] IDENTITY(1,1) NOT NULL,
[Surveyid] [int] NOT NULL,
[Qid] [int] NOT NULL,
[Answercontent] [nvarchar](1000) NOT NULL,
[Userid] [int] NULL,
[Submitdate] [datetime] NULL,
[Submitip] [varchar](50) NULL,
[AnswerScore] [int] Null,
CONSTRAINT [PK_ZL_Answer] PRIMARY KEY CLUSTERED
(
[Aid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
CREATE TABLE [dbo].[ZL_Answer_Recode](
[Rid] [int] IDENTITY(1,1) NOT NULL,
[Sid] [int] NOT NULL,
[Userid] [int] NOT NULL,
[Submitip] [varchar](50) ,
[Submitdate] [datetime] NULL CONSTRAINT [DF_ZL_Answer_Recode_Submitdate]  DEFAULT (getdate()),
[Status] [int] NOT NULL CONSTRAINT [DF_ZL_ZL_Answer_Recode_Status]  DEFAULT (0)
CONSTRAINT [PK_ZL_ANSWER_RECODE] PRIMARY KEY CLUSTERED
([Rid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

--注意：将清空全表数据

detele from ZL_Answer

--注意：将删除整个表

drop table ZL_Answer

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Answer