--菜单权限 IF NOT EXISTS (SELECT * FROM Sys_ButtonToMenu WHERE MenuId = '4E0030F6-EF5E-40A6-939F-C29BC4D7CEE1') BEGIN INSERT [dbo].[Sys_ButtonToMenu] ([ButtonToMenuId], [MenuId], [ButtonName], [SortIndex]) VALUES (N'193BB4A7-B5F2-4A01-8E98-8010D073CA7A', N'4E0030F6-EF5E-40A6-939F-C29BC4D7CEE1', N'修改', 1) INSERT [dbo].[Sys_ButtonToMenu] ([ButtonToMenuId], [MenuId], [ButtonName], [SortIndex]) VALUES (N'249C8227-035A-419C-84B7-49BF75B0CC9D', N'9DE9B74A-0823-4857-8B50-2DAA5E635EC4', N'增加', 1) INSERT [dbo].[Sys_ButtonToMenu] ([ButtonToMenuId], [MenuId], [ButtonName], [SortIndex]) VALUES (N'5B819DF9-9076-4BEF-8404-F6A75D9B9633', N'9DE9B74A-0823-4857-8B50-2DAA5E635EC4', N'保存', 4) INSERT [dbo].[Sys_ButtonToMenu] ([ButtonToMenuId], [MenuId], [ButtonName], [SortIndex]) VALUES (N'739FEA2A-EDCC-4212-BA6E-52BF16F692EE', N'9DE9B74A-0823-4857-8B50-2DAA5E635EC4', N'修改', 2) INSERT [dbo].[Sys_ButtonToMenu] ([ButtonToMenuId], [MenuId], [ButtonName], [SortIndex]) VALUES (N'DB9951FE-07B7-406E-9574-9A14C30F267F', N'9DE9B74A-0823-4857-8B50-2DAA5E635EC4', N'删除', 3) END GO --博晟培训考试和塔吊菜单 IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = '3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3') BEGIN INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'17666A2C-EE47-42DE-AB8E-E23088BB156D', N'培训人员', NULL, N'BoSheng/BoTrainPerson.aspx', 40, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'培训考试（扩展）', NULL, N'', 95, N'0', N'Menu_Person_P', 0, 0, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'4E0030F6-EF5E-40A6-939F-C29BC4D7CEE1', N'人员信息', NULL, N'BoSheng/BoPerson.aspx', 20, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'909BBC10-68D4-4C97-9FC3-9C1168D5FBC5', N'培训试卷', NULL, N'BoSheng/BoExam.aspx', 50, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'9DF3DA33-E80D-4BF5-882C-842E400F7CAF', N'培训记录', NULL, N'BoSheng/BoTrain.aspx', 30, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'C5DF2DE4-EB56-45F9-9881-6CD0B7A8E72F', N'人员培训记录', NULL, N'BoSheng/BoPersonTrainRecord.aspx', 60, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'FCA7A020-9F1B-4E1B-B457-001E05A19774', N'项目单位', NULL, N'BoSheng/BoUnit.aspx', 10, N'3FD5EEC5-B3ED-4944-B9E9-6B8C923316E3', N'Menu_Person_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'960812BA-ADE3-41C2-AE4A-BF24A58DE4CB', N'塔吊状态', NULL, N'HSSE/TowerCrane/TowerCraneState.aspx', 120, N'688a1471-2d76-4d51-9d2c-6807795beb11', N'Menu_Device_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'9DE9B74A-0823-4857-8B50-2DAA5E635EC4', N'塔吊', NULL, N'HSSE/TowerCrane/TowerCrane.aspx', 70, N'688a1471-2d76-4d51-9d2c-6807795beb11', N'Menu_Device_P', 0, 1, 1) INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Icon], [Url], [SortIndex], [SuperMenu], [MenuType], [IsOffice], [IsEnd], [IsUsed]) VALUES (N'DE0CA5F1-AE72-4752-A244-D474F3F5F9C8', N'塔吊记录', NULL, N'HSSE/TowerCrane/TowerCraneRecord.aspx', 130, N'688a1471-2d76-4d51-9d2c-6807795beb11', N'Menu_Device_P', 0, 1, 1) END GO ---博晟培训考试 --Bo_Sheng_Exam IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_Exam') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_Exam]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [RecordId] [nvarchar](50) NULL, [ExamNo] [nvarchar](50) NULL, [GroupNo] [nvarchar](50) NULL, [CourseID] [nvarchar](50) NULL, [COrder] [int] NULL, [QsnCode] [nvarchar](50) NULL, [QsnId] [nvarchar](50) NULL, [QsnContent] [nvarchar](max) NULL, [QsnFileName] [nvarchar](50) NULL, [QsnAnswer] [nvarchar](50) NULL, [QsnCategory] [nvarchar](50) NULL, [QsnKind] [nvarchar](50) NULL, [QsnImportant] [nvarchar](50) NULL, [Description] [nvarchar](500) NULL, [Analysis] [nvarchar](max) NULL, [UploadTime] [datetime] NULL, [DeleteTag] [nvarchar](50) NULL, CONSTRAINT [PK_Bo_Sheng_Exam] 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] TEXTIMAGE_ON [PRIMARY] END GO --Bo_Sheng_Person IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_Person') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_Person]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [CreateDate] [datetime] NULL, [CreateUser] [nvarchar](50) NULL, [OperDate] [datetime] NULL, [OperUser] [nvarchar](50) NULL, [DeleteUser] [nvarchar](50) NULL, [DeleteDate] [datetime] NULL, [DeleteTag] [nvarchar](50) NULL, [Name] [nvarchar](100) NULL, [Sex] [nvarchar](2) NULL, [BirthDay] [datetime] NULL, [Address] [nvarchar](200) NULL, [Nation] [nvarchar](50) NULL, [IdentifyID] [nvarchar](50) NULL, [Kind] [nvarchar](50) NULL, [Photo] [nvarchar](2000) NULL, [Police] [nvarchar](50) NULL, [ValidPeriodStart] [nvarchar](50) NULL, [ValidPeriodEnd] [nvarchar](50) NULL, [Education] [nvarchar](50) NULL, [Native] [nvarchar](500) NULL, [Telephone] [nvarchar](50) NULL, [MaritalStatus] [nvarchar](50) NULL, [BloodGroup] [nvarchar](50) NULL, [RegisteredType] [nvarchar](50) NULL, [Age] [int] NULL, [JobNumber] [nvarchar](50) NULL, [CardContent] [nvarchar](50) NULL, [ContactTel] [nvarchar](50) NULL, [SecondContacts] [nvarchar](50) NULL, [SecondContactsTel] [nvarchar](50) NULL, [NewAddress] [nvarchar](50) NULL, [HealthCondition] [nvarchar](50) NULL, [HealthFile] [nvarchar](500) NULL, [BuildArea] [nvarchar](50) NULL, [TraPrincipal] [nvarchar](50) NULL, [RegisterDate] [datetime] NULL, [CategoryType] [nvarchar](50) NULL, [Station] [nvarchar](50) NULL, [Category] [nvarchar](50) NULL, [CategoryLevel] [nvarchar](50) NULL, [EntranceDate] [datetime] NULL, [IsOut] [nvarchar](50) NULL, [LeaveDate] [datetime] NULL, [IsBlackList] [nvarchar](50) NULL, [AgreementId] [nvarchar](100) NULL, [HasInsurance] [nvarchar](50) NULL, [DeviceNumber] [nvarchar](50) NULL, [IsActive] [nvarchar](50) NULL, [DepartId] [nvarchar](50) NULL, [DepartName] [nvarchar](100) NULL, [OwnerDepartId] [nvarchar](50) NULL, [UploadTime] [datetime] NULL, CONSTRAINT [PK_Bo_Sheng_Person] 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] END GO --Bo_Sheng_PersonTrainRecord IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_PersonTrainRecord') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_PersonTrainRecord]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [EmpName] [nvarchar](50) NULL, [IdentifyId] [nvarchar](50) NULL, [CategoryName] [nvarchar](50) NULL, [RecordId] [nvarchar](50) NULL, [DepartId] [nvarchar](50) NULL, [DepartName] [nvarchar](50) NULL, [TrainPeriod] [nvarchar](50) NULL, [TotalScore] [decimal](18, 2) NULL, [PassScore] [decimal](18, 2) NULL, [Score] [decimal](18, 2) NULL, [IsPass] [nvarchar](50) NULL, [GroupNo] [nvarchar](50) NULL, [ExamNo] [nvarchar](50) NULL, [ExamCount] [nvarchar](50) NULL, [DeviceNo] [nvarchar](50) NULL, [OwnerDepartId] [nvarchar](50) NULL, [Answers] [nvarchar](500) NULL, [RecordName] [nvarchar](50) NULL, [TrainType] [nvarchar](50) NULL, [PaperMode] [nvarchar](50) NULL, [TrainMode] [nvarchar](50) NULL, [TrainPrincipal] [nvarchar](50) NULL, [TrainStartDate] [datetime] NULL, [TrainEndDate] [datetime] NULL, [TrainContent] [nvarchar](2000) NULL, [TrainDescript] [nvarchar](max) NULL, [DeleteTag] [nvarchar](50) NULL, CONSTRAINT [PK_Bo_Sheng_PersonTrainRecord] 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] TEXTIMAGE_ON [PRIMARY] END GO --Bo_Sheng_Train IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_Train') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_Train]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [DeleteUser] [nvarchar](50) NULL, [DeleteDate] [datetime] NULL, [DeleteTag] [nvarchar](50) NULL, [RecordName] [nvarchar](500) NULL, [TrainType] [nvarchar](50) NULL, [PaperMode] [nvarchar](50) NULL, [TrainMode] [nvarchar](50) NULL, [TrainPrincipal] [nvarchar](50) NULL, [TrainStartDate] [datetime] NULL, [TrainEndDate] [datetime] NULL, [TrainContent] [nvarchar](max) NULL, [TrainDescript] [nvarchar](max) NULL, [TrainPeriod] [nvarchar](50) NULL, [PersonCount] [int] NULL, [PassedCount] [int] NULL, [CoverImg] [nvarchar](2000) NULL, [DemandID] [nvarchar](50) NULL, [CourseCount] [int] NULL, [CourseDuration] [nvarchar](50) NULL, [Source] [nvarchar](50) NULL, [Description] [nvarchar](500) NULL, [DeviceNo] [nvarchar](50) NULL, [OwnerDepartId] [nvarchar](50) NULL, [UploadTime] [datetime] NULL, [OwnerDeptName] [nvarchar](100) NULL, [TrainDepart] [nvarchar](max) NULL, [CreateDate] [datetime] NULL, [CreateUser] [nvarchar](50) NULL, [OperDate] [datetime] NULL, [OperUser] [nvarchar](50) NULL, CONSTRAINT [PK_Bo_Sheng_Train] 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] TEXTIMAGE_ON [PRIMARY] END GO --Bo_Sheng_TrainPerson IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_TrainPerson') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_TrainPerson]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [DeleteUser] [nvarchar](50) NULL, [DeleteDate] [datetime] NULL, [DeleteTag] [nvarchar](50) NULL, [EmpName] [nvarchar](100) NULL, [IdentifyId] [nvarchar](50) NULL, [Photo] [nvarchar](500) NULL, [Station] [nvarchar](50) NULL, [Category] [nvarchar](50) NULL, [CategoryName] [nvarchar](50) NULL, [RecordId] [nvarchar](50) NULL, [SignName] [nvarchar](500) NULL, [DepartId] [nvarchar](50) NULL, [DepartName] [nvarchar](50) NULL, [SignInDate] [datetime] NULL, [SignInType] [nvarchar](50) NULL, [TrainPeriod] [nvarchar](50) NULL, [State] [nvarchar](50) NULL, [TotalScore] [decimal](18, 2) NULL, [PassScore] [decimal](18, 0) NULL, [Score] [decimal](18, 2) NULL, [IsPass] [nvarchar](50) NULL, [GroupNo] [nvarchar](50) NULL, [ExamNo] [nvarchar](50) NULL, [ExamCount] [int] NULL, [DeviceNo] [nvarchar](50) NULL, [OwnerDepartId] [nvarchar](50) NULL, [UploadTime] [datetime] NULL, [Answers] [nvarchar](2000) NULL, [CreateDate] [datetime] NULL, [CreateUser] [nvarchar](50) NULL, [OperDate] [datetime] NULL, [OperUser] [nvarchar](50) NULL, CONSTRAINT [PK_Bo_Sheng_TrainPerson] 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] END GO --Bo_Sheng_Unit IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Bo_Sheng_Unit') AND type = N'U') BEGIN CREATE TABLE [dbo].[Bo_Sheng_Unit]( [ID] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [ParentID] [nvarchar](50) NULL, [DepartCode] [nvarchar](50) NULL, [ParentCode] [nvarchar](50) NULL, [DepartName] [nvarchar](200) NULL, [DepartType] [nvarchar](50) NULL, [DepartShortName] [nvarchar](50) NULL, [DepartOrder] [nvarchar](50) NULL, [State] [nvarchar](50) NULL, [DepartSir] [nvarchar](50) NULL, [IsEpiboly] [nvarchar](50) NULL, [Phone] [nvarchar](50) NULL, [Charge] [nvarchar](50) NULL, [Remark] [nvarchar](1000) NULL, [OwnerDeptID] [nvarchar](50) NULL, [CreateDate] [datetime] NULL, [CreateUser] [nvarchar](50) NULL, [OperDate] [datetime] NULL, [OperUser] [nvarchar](50) NULL, [DeleteTag] [nvarchar](50) NULL, CONSTRAINT [PK_Bo_Sheng_Unit] 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] END GO ---塔吊 --HSSE_TowerCrane IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'HSSE_TowerCrane') AND type = N'U') BEGIN CREATE TABLE [dbo].[HSSE_TowerCrane]( [TowerCraneId] [nvarchar](50) NOT NULL, [ProjectId] [nvarchar](50) NULL, [TowerCraneName] [nvarchar](50) NULL, [TowerCraneCode] [nvarchar](50) NULL, [MaxHoist] [float] NULL, [MaxMoment] [float] NULL, [FrontArmLength] [float] NULL, [BackArmLength] [float] NULL, [TowerCap] [nvarchar](2) NULL, [ArmHeigh] [float] NULL, [Remark] [nvarchar](50) NULL, [CreateDate] [datetime] NULL, [VideoAccount] [nvarchar](50) NULL, [VideoPassword] [nvarchar](50) NULL, CONSTRAINT [PK_HSSE_TowerCrane] PRIMARY KEY CLUSTERED ( [TowerCraneId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO --HSSE_TowerCraneRecord IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'HSSE_TowerCraneRecord') AND type = N'U') BEGIN CREATE TABLE [dbo].[HSSE_TowerCraneRecord]( [TowerCraneRecordId] [nvarchar](50) NOT NULL, [AlarmType] [nvarchar](50) NULL, [AmountHoist] [float] NULL, [Camber] [float] NULL, [Height] [float] NULL, [Hoist] [float] NULL, [Moment] [float] NULL, [Range] [float] NULL, [RotationAngle] [float] NULL, [WindSpeed] [float] NULL, [Date] [datetime] NULL, [TowerCraneId] [nvarchar](50) NULL, [Remark] [nvarchar](50) NULL, CONSTRAINT [PK_HSSE_TowerCraneRecord] PRIMARY KEY CLUSTERED ( [TowerCraneRecordId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] END GO --Sys_DataExchange IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'Sys_DataExchange') AND type = N'U') BEGIN CREATE TABLE [dbo].[Sys_DataExchange]( [DataID] [int] NOT NULL, [GetTime] [datetime] NULL, [MessageText] [nvarchar](max) NULL, [FromSystem] [nvarchar](50) NULL, [ToSystem] [nvarchar](50) NULL, [IsUpdate] [bit] NULL, CONSTRAINT [PK_Sys_DataExchange] PRIMARY KEY CLUSTERED ( [DataID] 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] ALTER TABLE [dbo].[Sys_DataExchange] ADD CONSTRAINT [DF_Sys_DataExchange_DataID] DEFAULT ((0)) FOR [DataID] ALTER TABLE [dbo].[Sys_DataExchange] ADD CONSTRAINT [DF_Sys_DataExchange_IsUpdate] DEFAULT ((0)) FOR [IsUpdate] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'DataID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'提取时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'GetTime' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据内容' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'MessageText' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'来源系统' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'FromSystem' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'接收系统' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'ToSystem' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'是否更新' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange', @level2type=N'COLUMN',@level2name=N'IsUpdate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据交换表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DataExchange' END GO