表名：ZL_Questions_Knowledge












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1k_idint40是  否 主键ID
2k_namenvarchar2000   否 知识点
3k_Class_idint40   否 所属分类ID
4k_OrderByint40   是 排序
5Statusint40   是 状态
6Gradeint40   是 年级
7IsSysint40   是 是否为系统知识点
8CDatedatetime83   是 创建时间
9CUserint40   是 创建人
10Pidint40   是 父节点ID

简要说明：

问答回复记录表


GO
CREATE TABLE [dbo].[ZL_Questions_Knowledge](
[k_id] [int] IDENTITY(1,1) NOT NULL,
[k_name] [nvarchar](200) NOT NULL,
[k_Class_id] [int] NOT NULL,
[k_OrderBy] [int] NULL,
[Status] [int] NULL,
[Grade] [int] NULL,
[IsSys] [int] NULL,
[CDate] [datetime] NULL,
[CUser] [int] NULL,
[Pid] [int] NULL
) ON [PRIMARY]

GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'知识点' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions_Knowledge', @level2type=N'COLUMN',@level2name=N'k_name'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'所属分类ID' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions_Knowledge', @level2type=N'COLUMN',@level2name=N'k_Class_id'
GO
EXEC dbo.sp_addextendedproperty @name=N'MS_Description', @value=N'排序' , @level0type=N'USER',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Questions_Knowledge', @level2type=N'COLUMN',@level2name=N'k_OrderBy'

 SET IDENTITY_INSERT [ZL_Questions_Knowledge] ON
 INSERT [ZL_Questions_Knowledge] ( [k_id] , [k_name] , [k_Class_id] , [k_OrderBy] ) VALUES ( 1 , '二、欧姆定律及其应用' , 2 , 0 )
 INSERT [ZL_Questions_Knowledge] ( [k_id] , [k_name] , [k_Class_id] , [k_OrderBy] ) VALUES ( 2 , '四、电与热' , 1 , 0 )
 SET IDENTITY_INSERT [ZL_Questions_Knowledge] OFF


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

detele from ZL_Questions_Knowledge

--注意：将删除整个表

drop table ZL_Questions_Knowledge

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

TRUNCATE table ZL_Questions_Knowledge