/****** Object:  Table [dbo].[Cmp_TTBKB]    Script Date: 08/02/2016 14:36:03 ******/
--北航调停课系统数据对接中间表
SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

SET ANSI_PADDING ON

IF not EXISTS (SELECT * FROM sysobjects WHERE name = 'Cmp_TTBKB')
Begin
CREATE TABLE [dbo].[Cmp_TTBKB](
	[ID] [varchar](50) NOT NULL,
	[BDLB] [varchar](50) NULL,
	[BDBH] [varchar](50) NULL,
	[XIAOQU] [varchar](50) NULL,
	[XN] [varchar](20) NULL,
	[XQ] [varchar](20) NULL,
	[RWH] [varchar](50) NULL,
	[KCDM] [varchar](20) NULL,
	[kcmc] [varchar](100) NULL,
	[ZGH] [varchar](50) NULL,
	[JSXM] [varchar](50) NULL,
	[SKRQ] [datetime] NULL,
	[ZC] [varchar](2) NULL,
	[SKSJ] [varchar](20) NULL,
	[SKTJSJ] [varchar](50) NULL,
	[SKDD] [varchar](50) NULL,
	[CDMC] [varchar](100) NULL,
	[SJLB] [varchar](50) NULL,
 CONSTRAINT [PK_Cmp_TTBKB] 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]

SET ANSI_PADDING OFF

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'变动类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'BDLB'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'变动编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'BDBH'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'校区' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'XIAOQU'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学年' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'XN'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'学期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'XQ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'任务号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'RWH'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'课程代码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'KCDM'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'课程名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'kcmc'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'职工号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'ZGH'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'教师姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'JSXM'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上课日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'SKRQ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'周次' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'ZC'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上课时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'SKSJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上课具体时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'SKTJSJ'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'上课地点' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'SKDD'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'场地名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'CDMC'

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据操作方式（DEL 删除 ADD 新增）' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Cmp_TTBKB', @level2type=N'COLUMN',@level2name=N'SJLB'

END