文件名称：创建Answer表-在线考试系统PPT报告
文件大小：564KB
文件格式：PPT
更新时间：2024-05-13 13:35:36
在线考试系统 ppt 实习 报告
（3）、3、创建Answer表 CREATE TABLE [dbo].[Answer]( [ID] [int] IDENTITY(1,1) NOT NULL, [Tag] [char](2) NULL, [Body] [varchar](1000) NULL, [QuestionID] [int] NULL, CONSTRAINT [PK_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] GO （4）、创建ExamineeAnswer表 CREATE TABLE [dbo].[ExamineeAnswer]( [ID] [int] IDENTITY(1,1) NOT NULL, [OnlineExamineID] [int] NULL, [QuestionID] [int] NULL, [Answer] [char](2) NULL, CONSTRAINT [PK_ExamineeAnswer] 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