BEGIN
CREATE TABLE [dbo].[quanxian]([qxid] [int] IDENTITY(1,1) NOT NULL,
[qx] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'quanxian', @level2type=N'COLUMN', @level2name=N'qx'
BEGIN
CREATE TABLE [dbo].[yonghu]([yhid] [int] IDENTITY(1,1) NOT NULL,
[yhm] [VARCHAR](40),
[mm] [VARCHAR](40),
[xm] [VARCHAR](40),
[qx] [VARCHAR](40),
[dz] [VARCHAR](40),
[dh] [VARCHAR](40),
[bj] [VARCHAR](40),
[zp] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'yhm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'mm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'姓名' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'xm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'权限' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'qx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'地址' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电话' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'dh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'bj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'照片' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'yonghu', @level2type=N'COLUMN', @level2name=N'zp'
BEGIN
CREATE TABLE [dbo].[kaochang]([kcid] [int] IDENTITY(1,1) NOT NULL,
[kc] [VARCHAR](40),
[wz] [VARCHAR](40),
[zws] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'考场' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kaochang', @level2type=N'COLUMN', @level2name=N'kc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'位置' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kaochang', @level2type=N'COLUMN', @level2name=N'wz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'座位数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kaochang', @level2type=N'COLUMN', @level2name=N'zws'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kaochang', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[banji]([bjid] [int] IDENTITY(1,1) NOT NULL,
[bj] [VARCHAR](40),
[xn] [VARCHAR](40),
[zy] [VARCHAR](40),
[rs] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'bj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学年' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'xn'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'专业' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'zy'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'人数' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'banji', @level2type=N'COLUMN', @level2name=N'rs'
BEGIN
CREATE TABLE [dbo].[kemu]([kmid] [int] IDENTITY(1,1) NOT NULL,
[km] [VARCHAR](40),
[xs] [VARCHAR](40),
[rkjs] [VARCHAR](40),
[xf] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kemu', @level2type=N'COLUMN', @level2name=N'km'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学时' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kemu', @level2type=N'COLUMN', @level2name=N'xs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任课教师' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kemu', @level2type=N'COLUMN', @level2name=N'rkjs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学分' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'kemu', @level2type=N'COLUMN', @level2name=N'xf'
BEGIN
CREATE TABLE [dbo].[anpai]([apid] [int] IDENTITY(1,1) NOT NULL,
[bh] [VARCHAR](40),
[bj] [VARCHAR](40),
[kc] [VARCHAR](40),
[js] [VARCHAR](40),
[km] [VARCHAR](40),
[sjd] [VARCHAR](40),
[rq] [VARCHAR](40),
[bz] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'编号' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'bh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'bj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'考场' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'kc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'教师' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'js'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'科目' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'km'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间段' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'sjd'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'rq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'anpai', @level2type=N'COLUMN', @level2name=N'bz'
BEGIN
CREATE TABLE [dbo].[sjd]([sjdid] [int] IDENTITY(1,1) NOT NULL,
[sjd] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'时间段' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'sjd', @level2type=N'COLUMN', @level2name=N'sjd'
BEGIN
CREATE TABLE [dbo].[riqi]([rqid] [int] IDENTITY(1,1) NOT NULL,
[rq] [VARCHAR](40),
) ON [PRIMARY]
END
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'日期' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'riqi', @level2type=N'COLUMN', @level2name=N'rq'