题目表
CREATE TABLE [dbo].[Questions]( [id] [int] IDENTITY(1,1) NOT NULL, [cate] [int] NOT NULL, [type] [varchar](50) NULL, [dep] [varchar](100) NULL, [question] [varchar](1000) NULL, [KeyA] [varchar](500) NULL, [KeyB] [varchar](500) NULL, [KeyC] [varchar](500) NULL, [KeyD] [varchar](500) NULL, [Key] [varchar](50) NULL, [CreateTime] [datetime] NULL, [CreateById] [varchar](50) NULL, [ISCertificateByPost] [varchar](50) NULL, [MesStation] [varchar](50) NULL )
结果表
CREATE TABLE [dbo].[Questions_results]( [id] [int] IDENTITY(1,1) NOT NULL, [cate] [int] NULL, [type] [varchar](50) NULL, [dep] [varchar](100) NULL, [serial] [varchar](50) NULL, [qty] [nchar](10) NULL, [UserCode] [varchar](50) NULL, [UserName] [varchar](50) NULL, [Status] [varchar](50) NULL, [Score] [float] NULL, [starttime] [datetime] NULL, [endtime] [datetime] NULL, [CreateTime] [datetime] NULL, [CreateById] [varchar](50) NULL, [MesStation] [varchar](50) NULL, [Did] [int] NULL )
回答表
CREATE TABLE [dbo].[Questions_log]([id] [int] IDENTITY(1,1) NOT NULL,[serial] [varchar](50) NULL,[type] [varchar](50) NULL,[dep] [varchar](100) NULL,[question] [varchar](1000) NULL,[KeyA] [varchar](500) NULL,[KeyB] [varchar](500) NULL,[KeyC] [varchar](500) NULL,[KeyD] [varchar](500) NULL,[Key] [varchar](50) NULL,[selectkey] [varchar](50) NULL,[Remarks] [varchar](200) NULL,[CreateTime] [datetime] NULL,[CreateById] [varchar](50) NULL,[ISCertificateByPost] [varchar](50) NULL,[MesStation] [varchar](50) NULL,[cate] [int] NULL )
类目表
CREATE TABLE [dbo].[Questions_Item]([id] [int] IDENTITY(1,1) NOT NULL,[class] [varchar](50) NULL,[type] [varchar](100) NULL,[item] [varchar](2000) NULL,[qty] [varchar](50) NULL,[sort] [varchar](50) NULL )