当前位置：首页 > news >正文

问题表 - microsoft

news 2026/3/27 5:58:26

题目表

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
)

查看全文

http://www.jsqmd.com/news/7656/