問題表

題目表

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'創(chuàng)建時間' , @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'創(chuàng)建人工號' , @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'創(chuàng)建人' , @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'創(chuàng)建時間' , @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'創(chuàng)建人工號' , @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'創(chuàng)建人' , @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 閱讀(5) 評論(0) 收藏舉報

刷新頁面返回頂部

microsoft-zhcn

問題表

公告