表名：ZL_Exam_ClassRoom












序号列名数据类型长度小数位标识主键外键允许空默认值说明
1RoomIDint40是是 否 班级ID
2RoomNamenvarchar2550   是 班级名称
3SchoolIDint40   是 学校ID
4ClassNamenvarchar500   是 班级名称
5Roomnvarchar100   是  
6Teachernvarchar2550   是 担任老师
7Advisernvarchar2550   是 副管理员
8Monitornvarchar2550   是 班微标
9Creationdatetime83   是 创建时间
10CreateUserint40   是 创建人(管理员)
11Integralint40   是0人数(Disuse,应该动态查询)
12Classinfontext160   是 班级介绍
13Gradeint40   是 年级(disuse,应该改名称)
14IsTrueint40   是0审核
15ClassStarint40   是 班级星级
16IsDoneint40   是 是否毕业

简要说明：

在线考试班级表

GO
CREATE TABLE [dbo].[ZL_Exam_ClassRoom](
[RoomID] [int] IDENTITY(1,1) NOT NULL,
[RoomName] [nvarchar](255) NULL,
[SchoolID] [int] NULL,
[ClassName] [nvarchar](50) NULL,
[Room] [nvarchar](10) NULL,
[Teacher] [nvarchar](255) NULL,
[Adviser] [nvarchar](255) NULL,
[Monitor] [nvarchar](255) NULL,
[Creation] [datetime] NULL,
[CreateUser] [int] NULL,
[Integral] [int] NULL,
[Classinfo] [ntext] NULL,
[Grade] [int] NULL,
[IsTrue] [int] NULL,
[ClassStar] [int] NULL,
[IsDone] [int] NULL,
CONSTRAINT [PK_ZL_Exam_ClassRoom] PRIMARY KEY CLUSTERED
([RoomID] 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
ALTER TABLE [dbo].[ZL_Exam_ClassRoom] ADD  CONSTRAINT [DF_ZL_Exam_ClassRoom_Integral]  DEFAULT ((0)) FOR [Integral]
GO
ALTER TABLE [dbo].[ZL_Exam_ClassRoom] ADD  CONSTRAINT [DF_ZL_Exam_ClassRoom_IsTrue]  DEFAULT ((0)) FOR [IsTrue]

--注意：将清空全表数据

detele from ZL_Exam_ClassRoom

--注意：将删除整个表

drop table ZL_Exam_ClassRoom

--注意：清空且复位表ID序列为初始值

TRUNCATE table ZL_Exam_ClassRoom