表名：ZL_Question












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1Qidint40是是 否 主键
2Surveyidint40   否 问卷的ID
3Typeidint40   是1问题类型ID
4Qtitlenvarchar5000   是 问题题目
5Qcontenttext160   是 问题设定内容
6Orderidint40   是0排序ID
7QuestionCreateTimedatetime83   是getdate创建时间
8IsNullbit10   是 是否为空
9Qoptionnvarchar40000   是 该问题的设定与规则,用于前端输出

简要说明：

问答表

GO
CREATE TABLE [dbo].[ZL_Question](
[Qid] [int] IDENTITY(1,1) NOT NULL,
[Surveyid] [int] NOT NULL,
[Typeid] [int] NULL CONSTRAINT [DF_ZL_Question_Typeid]  DEFAULT (1),
[Qtitle] [nvarchar](500) NULL,
[Qcontent] [text] NULL,
[Orderid] [int] NULL CONSTRAINT [DF_ZL_Question_Orderid]  DEFAULT (0),
[QuestionCreateTime] [datetime] NULL CONSTRAINT [DF_ZL_Question_QuestionCreateTime]  DEFAULT (getdate()),
[IsNull] [bit] Null,
[Qoption] [nvarchar](4000) NULL,
 CONSTRAINT [PK_ZL_Question] PRIMARY KEY CLUSTERED
(
[Qid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

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

detele from ZL_Question

--注意：将删除整个表

drop table ZL_Question

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

TRUNCATE table ZL_Question