表名：ZL_GuestAnswer












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1IDint40是  否  
2QueIdint40   是 问题ID
3Contentnvarchar40000   是 回答
4supplymentnvarchar40000   是 回答追问
5AddTimedatetime83   是 回答时间
6UserIdint40   是 回答人Id
7UserNamenvarchar2550   是 回答人
8Statusint40   是0状态
9supplymentidint40   是 回答追问
10auditint40   是 审核状态
11IsNiint40   是0 

简要说明：

留言回复表


GO
CREATE TABLE [dbo].[ZL_GuestAnswer] (
[ID] [int] IDENTITY (1, 1) NOT NULL ,
[QueId] [int] NULL,
[Content] [nvarchar] (4000)NULL,
[supplyment] [nvarchar] (4000) NULL,
[AddTime][datetime] null,
[UserId] [int] null,
[UserName][nvarchar](255) null,
[Status] [int] null DEFAULT (0),
[supplymentid] [int] NULL,
[audit] [int] NULL,
[IsNi] [int] NULL DEFAULT (0)
) ON [PRIMARY]

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

detele from ZL_GuestAnswer

--注意：将删除整个表

drop table ZL_GuestAnswer

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

TRUNCATE table ZL_GuestAnswer