GO
CREATE TABLE [dbo].[ZL_Exam_Student](
[Noteid] [int] IDENTITY(1,1) NOT NULL,
[UserID] [int] NULL,
[UserName] [nvarchar](255) NULL,
[SchoolID] [int] NULL,
[RoomID] [int] NULL,
[Addtime] [datetime] NULL,
[StatusType] [int] NULL,
[StudentType] [int] NULL,
[StudentTypeTitle] [nvarchar](50) NULL,
[Auditing] [int] NULL,
[AuditingContext] [nvarchar](50) NULL,
[AuditingUserID] [int] NULL,
[AuditingUserName] [nvarchar](255) NULL,
CONSTRAINT [PK_ZL_Exam_Student] PRIMARY KEY CLUSTERED
([Noteid] 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
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'记录ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'Noteid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学校ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'SchoolID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'RoomID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'加入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'Addtime'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份类型 1：学生，2：老师，3：家长' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'StatusType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生属性：1、学生' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'StudentType'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学生属性：是学生或班干部；StatusType属性为1时。此属性值有效' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'StudentTypeTitle'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核用户 0：未审核，1：审核通过' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'Auditing'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'申请理由' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'AuditingContext'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核用户ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'AuditingUserID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'审核用户用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZL_Exam_Student', @level2type=N'COLUMN',@level2name=N'AuditingUserName'
GO
ALTER TABLE [dbo].[ZL_Exam_Student] ADD  CONSTRAINT [DF_ZL_Student_Addtime]  DEFAULT (getdate()) FOR [Addtime]