问题表

题目表

USE [BW_OA]
GO

/****** Object:  Table [dbo].[exam_question]    Script Date: 2025/10/3 16:52:08 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[exam_question](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CategoryId] [int] NULL,
	[CategoryName] [nvarchar](64) NOT NULL,
	[DepartmentCode] [varchar](32) NULL,
	[DepartmentName] [nvarchar](64) NULL,
	[QuestionName] [varchar](1000) NULL,
	[Type] [varchar](16) NULL,
	[KeyA] [nvarchar](512) NULL,
	[KeyB] [nvarchar](512) NULL,
	[KeyC] [nvarchar](512) NULL,
	[KeyD] [nvarchar](512) NULL,
	[KeyE] [nvarchar](512) NULL,
	[Key] [nvarchar](512) NULL,
	[CreateTime] [datetime] NULL,
	[CreateCode] [varchar](32) NULL,
	[CreateName] [varchar](64) NULL,
	[ModifyTime] [datetime] NULL,
	[ModifyCode] [varchar](32) NULL,
	[ModifyName] [varchar](64) NULL,
 CONSTRAINT [PK_exam_question] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[exam_question] ADD  CONSTRAINT [DF_exam_question_cate]  DEFAULT ((0)) FOR [CategoryName]
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'Id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'CategoryId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'CategoryName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'DepartmentCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'DepartmentName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'问题名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'QuestionName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型（single、multiple）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'Type'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'KeyA'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案B' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'KeyB'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案C' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'KeyC'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案D' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'KeyD'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案E' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'KeyE'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'Key'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'CreateCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'CreateName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'ModifyTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'ModifyCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'修改人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_question', @level2type=N'COLUMN',@level2name=N'ModifyName'
GO

结果表

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
)

回答表

USE [BW_OA]
GO

/****** Object:  Table [dbo].[exam_answer]    Script Date: 2025/10/3 17:57:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[exam_answer](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[DepartmentCode] [varchar](32) NULL,
	[DepartmentName] [nvarchar](64) NULL,
	[CategoryId] [int] NULL,
	[CategoryName] [nvarchar](64) NULL,
	[QuestionId] [int] NULL,
	[QuestionName] [text] NULL,
	[Type] [varchar](16) NULL,
	[KeyA] [nvarchar](512) NULL,
	[KeyB] [nvarchar](512) NULL,
	[KeyC] [nvarchar](512) NULL,
	[KeyD] [nvarchar](512) NULL,
	[Key] [nvarchar](512) NULL,
	[SelectKey] [varchar](50) NULL,
	[Remarks] [varchar](200) NULL,
	[CreateTime] [datetime] NULL,
	[CreateCode] [varchar](32) NULL,
	[CreateName] [varchar](64) NULL,
 CONSTRAINT [PK_exam_answer] PRIMARY KEY CLUSTERED 
(
	[Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'Id'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门编码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'DepartmentCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'部门名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'DepartmentName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'CategoryId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类别名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'CategoryName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'问题ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'QuestionId'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'问题名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'QuestionName'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'类型（single、multiple）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'Type'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案A' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'KeyA'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案B' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'KeyB'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案C' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'KeyC'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案D' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'KeyD'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'Key'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'选择答案' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'SelectKey'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'Remarks'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'CreateTime'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'CreateCode'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'创建人' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'exam_answer', @level2type=N'COLUMN',@level2name=N'CreateName'
GO

类目表

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
)

posted @ 2025-10-03 16:37 microsoft-zhcn 阅读(4) 评论(0) 收藏举报

刷新页面返回顶部

microsoft-zhcn

问题表

公告