1746 lines
109 KiB
Transact-SQL
1746 lines
109 KiB
Transact-SQL
alter table [dbo].[Sys_User] add HomePageType nvarchar(10) null
|
||
GO
|
||
|
||
update [dbo].[Sys_User] set HomePageType='1'
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[HSSEData_HSSE](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[BeUnderConstructionNum] [int] NULL,
|
||
[ShutdownNum] [int] NULL,
|
||
[JoinConstructionPersonNum] [int] NULL,
|
||
[MajorProjectsUnderConstructionNum] [int] NULL,
|
||
[TotalWorkingHour] [int] NULL,
|
||
[LostWorkingHour] [int] NULL,
|
||
[SafeWorkingHour] [int] NULL,
|
||
[SafeTrainNum] [int] NULL,
|
||
[SpecialTrainNum] [int] NULL,
|
||
[SpecialOperationTrainNum] [int] NULL,
|
||
[TotalEnergyConsumption] [int] NULL,
|
||
[IncomeComprehensiveEnergyConsumption] [int] NULL,
|
||
[NewWaterConsumption] [int] NULL,
|
||
[HeadOfficeInspectorGeneralNum] [int] NULL,
|
||
[HeadOfficeFullTimeNum] [int] NULL,
|
||
[BranchInspectorGeneralNum] [int] NULL,
|
||
[BranchFullTimeNum] [int] NULL,
|
||
[ProjectInspectorGeneralNum] [int] NULL,
|
||
[ProjectFullTimeNum] [int] NULL,
|
||
[ProjectSafetyMonitorNum] [int] NULL,
|
||
[SafetyInjectionEngineer] [int] NULL,
|
||
[CertificateANum] [int] NULL,
|
||
[CertificateBNum] [int] NULL,
|
||
[CertificateCNum] [int] NULL,
|
||
[SafetyCommitteeMeetingNum] [int] NULL,
|
||
[EnterpriseTopicsMeetingNum] [int] NULL,
|
||
[ProjectSafetyLeadingGroupMeetingNum] [int] NULL,
|
||
[ProjectSafetyMeetingNum] [int] NULL,
|
||
[CompanyLeadShiftCheckNum] [int] NULL,
|
||
[CompanyComprehensiveCheckNum] [int] NULL,
|
||
[CompanySpecialCheckNum] [int] NULL,
|
||
[ProjectLeadShiftCheckNum] [int] NULL,
|
||
[ProjectSpecialCheckNum] [int] NULL,
|
||
[ProjectMajorCheckNum] [int] NULL,
|
||
[NearMissNum] [int] NULL,
|
||
[RecordableEventNum] [int] NULL,
|
||
[GeneralAccidentNum] [int] NULL,
|
||
[MajorAccidentNum] [int] NULL,
|
||
[SeriousAccidentNum] [int] NULL,
|
||
[SpecialSeriousAccidentNum] [int] NULL,
|
||
[CompanyComprehensivePlanNum] [int] NULL,
|
||
[CompanySpecialPlanNum] [int] NULL,
|
||
[CompanyOnSiteDisposalPlan] [int] NULL,
|
||
[CompanyDrillNum] [int] NULL,
|
||
[ProjectComprehensivePlanNum] [int] NULL,
|
||
[ProjectSpecialPlanNum] [int] NULL,
|
||
[ProjectOnSiteDisposalPlan] [int] NULL,
|
||
[ProjectDrillNum] [int] NULL,
|
||
[CostExtract] [int] NULL,
|
||
[CostUse] [int] NULL,
|
||
[UseEquipmentNum] [int] NULL,
|
||
[SpecialEquipmentNum] [int] NULL,
|
||
[LicensesNum] [int] NULL,
|
||
[LicensesCloseNum] [int] NULL,
|
||
[GeneralClosedNum] [int] NULL,
|
||
[GeneralNotClosedNum] [int] NULL,
|
||
[MajorClosedNum] [int] NULL,
|
||
[MajorNotClosedNum] [int] NULL,
|
||
[GeneralRiskNum] [int] NULL,
|
||
[LowRiskNum] [int] NULL,
|
||
[MediumRiskNum] [int] NULL,
|
||
[HighRiskNum] [int] NULL,
|
||
[CompletedNum] [int] NULL,
|
||
[TrainPersonNum] [int] NULL,
|
||
[ConstructionNum] [int] NULL,
|
||
[FinishedNum] [int] NULL,
|
||
[SuperCompletedNum] [int] NULL,
|
||
[SuperTrainPersonNum] [int] NULL,
|
||
[SuperConstructionNum] [int] NULL,
|
||
[SuperFinishedNum] [int] NULL,
|
||
[State] [varchar](50) NULL,
|
||
[CreateMan] [varchar](50) NULL,
|
||
[CreateDate] [datetime] NULL,
|
||
CONSTRAINT [PK_HSSEData_HSSE] 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]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ڽ<EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BeUnderConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ͣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ShutdownNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ν<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'JoinConstructionPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʩΣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorProjectsUnderConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܹ<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TotalWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʧ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LostWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafeWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafeTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ר<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialOperationTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܺ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TotalEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ԪӪҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD><EFBFBD>ܺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'IncomeComprehensiveEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˮ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'NewWaterConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD><EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HeadOfficeInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD>רְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HeadOfficeFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BranchInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD>רְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BranchFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀרְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyMonitorNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ڸ<EFBFBD>ִҵע<EFBFBD><EFBFBD>ʦ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafetyInjectionEngineer'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateANum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'B֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateBNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'C֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateCNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ί<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafetyCommitteeMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'EnterpriseTopicsMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD>쵼С<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyLeadingGroupMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyLeadShiftCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ۺϼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyComprehensiveCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanySpecialCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectLeadShiftCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSpecialCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀרҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectMajorCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'δ<EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'NearMissNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ɼ<EFBFBD>¼<EFBFBD>¼<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'RecordableEventNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϴ<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SeriousAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD><EFBFBD>ش<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialSeriousAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyComprehensivePlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ר<EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanySpecialPlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ֳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyOnSiteDisposalPlan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyDrillNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectComprehensivePlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ר<EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSpecialPlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ֳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectOnSiteDisposalPlan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectDrillNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CostExtract'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʹ<EFBFBD>ã<EFBFBD><EFBFBD><EFBFBD>Ԫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CostUse'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UseEquipmentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>豸<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialEquipmentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LicensesNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ɹر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LicensesCloseNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ͷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LowRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>з<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MediumRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>߷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HighRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD>ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD>깤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'FinishedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperTrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD>ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD>깤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperFinishedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'HSSE<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HSSE'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[HSSEData_HiddenDangerDetail](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[TypeName] [nvarchar](50) NULL,
|
||
[TotalNum] [int] NULL,
|
||
[NeedRectifyNum] [int] NULL,
|
||
CONSTRAINT [PK_HSSEData_HiddenDangerDetail] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'TypeName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'TotalNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'NeedRectifyNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ų<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HSSEData_HiddenDangerDetail'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[CQMSData_CQMS](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[TrainPersonNum] [int] NULL,
|
||
[TechnicalDisclosePersonNum] [int] NULL,
|
||
[UseNum] [int] NULL,
|
||
[OKNum] [int] NULL,
|
||
[CompanyPersonNum] [int] NULL,
|
||
[BranchPersonNum] [int] NULL,
|
||
[ProjectPersonNum] [int] NULL,
|
||
[ProblemNum] [int] NULL,
|
||
[ProblemCompletedNum] [int] NULL,
|
||
[ProblemNotCompletedNum] [int] NULL,
|
||
[SNum] [int] NULL,
|
||
[ANum] [int] NULL,
|
||
[BNum] [int] NULL,
|
||
[CNum] [int] NULL,
|
||
[KeyProcessNum] [int] NULL,
|
||
[KeyProcessOKNum] [int] NULL,
|
||
[SpecialProcessNum] [int] NULL,
|
||
[SpecialProcessOKNum] [int] NULL,
|
||
[ConcealedWorksNum] [int] NULL,
|
||
[ConcealedWorksOKNum] [int] NULL,
|
||
[UnitProjectOnesNum] [int] NULL,
|
||
[UnitProjectOnesOKNum] [int] NULL,
|
||
[MaterialInRecheckNum] [int] NULL,
|
||
[MaterialInRecheckOKNum] [int] NULL,
|
||
[SingleProjectNum] [int] NULL,
|
||
[UnitProjectNum] [int] NULL,
|
||
[SubProjectNum] [int] NULL,
|
||
[SubdivisionalWorksNum] [int] NULL,
|
||
[InspectionLotNum] [int] NULL,
|
||
[State] [varchar](50) NULL,
|
||
[CreateMan] [varchar](50) NULL,
|
||
[CreateDate] [datetime] NULL,
|
||
CONSTRAINT [PK_CQMSData_CQMS] 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]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'TrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'TechnicalDisclosePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ü<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UseNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'У<EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'OKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CompanyPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'BranchPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProjectPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemNotCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ANum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'B<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'BNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'C<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ؼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'KeyProcessNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ؼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'KeyProcessOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SpecialProcessNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SpecialProcessOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ConcealedWorksNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ConcealedWorksOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectOnesNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectOnesOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>Ͻ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'MaterialInRecheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>Ͻ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'MaterialInRecheckOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SingleProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ֲ<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SubProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SubdivisionalWorksNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'InspectionLotNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CQMS<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CQMSData_CQMS'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[HJGLData_HJGL](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[WelderNum] [int] NULL,
|
||
[TotalDineNum] [int] NULL,
|
||
[CompleteDineNum] [int] NULL,
|
||
[TotalFilmNum] [int] NULL,
|
||
[OKFilmNum] [int] NULL,
|
||
[State] [varchar](50) NULL,
|
||
[CreateMan] [varchar](50) NULL,
|
||
[CreateDate] [datetime] NULL,
|
||
CONSTRAINT [PK_HJGLData_HJGL] 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]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'WelderNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'TotalDineNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ɴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'CompleteDineNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ƭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'TotalFilmNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϸ<EFBFBD>Ƭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'OKFilmNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_HJGL'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[HJGLData_Defect](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[DefectName] [nvarchar](50) NULL,
|
||
[DefectNum] [int] NULL,
|
||
CONSTRAINT [PK_HJGLData_Defect] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'DefectName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'DefectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȱ<EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HJGLData_Defect'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[SYHSEData_SYHSE](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[GeneralRiskNum] [int] NULL,
|
||
[LowRiskNum] [int] NULL,
|
||
[MediumRiskNum] [int] NULL,
|
||
[HighRiskNum] [int] NULL,
|
||
[GradedResponsiblePersonNum] [int] NULL,
|
||
[ChargeInsurancePersonNum] [int] NULL,
|
||
[DesignQuantity] [int] NULL,
|
||
[RunningCapacity] [int] NULL,
|
||
[InterlockSettingValue] [int] NULL,
|
||
[VideoSurveillanceNum] [int] NULL,
|
||
[TotalWorkinghours] [int] NULL,
|
||
[SafeWorkinghours] [int] NULL,
|
||
[LostWorkinghours] [int] NULL,
|
||
[TotalEnergyConsumption] [int] NULL,
|
||
[IncomeComprehensiveEnergyConsumption] [int] NULL,
|
||
[NewWaterConsumption] [int] NULL,
|
||
[GeneralClosedNum] [int] NULL,
|
||
[GeneralNotClosedNum] [int] NULL,
|
||
[MajorClosedNum] [int] NULL,
|
||
[MajorNotClosedNum] [int] NULL,
|
||
[HotWorkPermitNum] [int] NULL,
|
||
[HotWorkClosedNum] [int] NULL,
|
||
[HighPermitNum] [int] NULL,
|
||
[HighClosedNum] [int] NULL,
|
||
[TemporaryElectricityPermitNum] [int] NULL,
|
||
[TemporaryElectricityClosedNum] [int] NULL,
|
||
[BlindPlatePermitNum] [int] NULL,
|
||
[BlindPlateClosedNum] [int] NULL,
|
||
[GroundbreakingPermitNum] [int] NULL,
|
||
[GroundbreakingClosedNum] [int] NULL,
|
||
[OpenCircuitPermitNum] [int] NULL,
|
||
[OpenCircuitClosedNum] [int] NULL,
|
||
[HoistingPermitNum] [int] NULL,
|
||
[HoistingClosedNum] [int] NULL,
|
||
[State] [varchar](50) NULL,
|
||
[CreateMan] [varchar](50) NULL,
|
||
[CreateDate] [datetime] NULL,
|
||
CONSTRAINT [PK_SYHSEData_SYHSE] 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]
|
||
|
||
GO
|
||
|
||
SET ANSI_PADDING OFF
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ͷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'LowRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>з<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MediumRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>߷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ּ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GradedResponsiblePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'ChargeInsurancePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'DesignQuantity'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'RunningCapacity'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>趨ֵ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'InterlockSettingValue'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ƶ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'VideoSurveillanceNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܹ<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TotalWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'SafeWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʧ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'LostWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܺ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TotalEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ԪӪҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD><EFBFBD>ܺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'IncomeComprehensiveEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˮ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'NewWaterConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MajorClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MajorNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HotWorkPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HotWorkClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ߴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ߴ<EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TemporaryElectricityPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TemporaryElectricityClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'BlindPlatePermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä<EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'BlindPlateClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GroundbreakingPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GroundbreakingClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>·<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'OpenCircuitPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>·<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'OpenCircuitClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HoistingPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>װ<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HoistingClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʵҵ<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SYHSEData_SYHSE'
|
||
GO
|
||
|
||
|
||
INSERT Sys_Menu (MenuId,MenuName,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'QHSE<EFBFBD>ϱ<EFBFBD>',130,N'0',N'Menu_ZHGL',1,0,1)
|
||
GO
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/HSSEData_HSSE.aspx',10,N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'Menu_ZHGL',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'0E44584C-719F-4D1F-BBA8-E7895C5141AA',N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'4B4D01B9-655A-4507-B7B2-403CCD8CC32B',N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'7FBDDF6F-EACE-41A8-A174-538A712E24F7',N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'263678A5-AD17-4C58-A411-A8A38AC013FA',N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'19E8CF8F-DFB4-43B0-A9D6-CE9297C3624C',N'94F94EC1-54B3-4BEB-A019-0A755A66D8FD',N'<EFBFBD><EFBFBD><EFBFBD>沢<EFBFBD>ϱ<EFBFBD>',5)
|
||
|
||
|
||
GO
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'4C9920AE-F335-48B1-BDB0-276173305952',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/CQMSData_CQMS.aspx',20,N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'Menu_ZHGL',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'DA200A82-6C43-4581-9FFC-A4161FFA47DA',N'4C9920AE-F335-48B1-BDB0-276173305952',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'D2B27E27-9601-42AC-82FE-6EC09583F39E',N'4C9920AE-F335-48B1-BDB0-276173305952',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'7A09DAAC-360A-470A-8621-0AF394C8C45B',N'4C9920AE-F335-48B1-BDB0-276173305952',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'F62DC09B-F712-4DA6-8B4D-93F9EE726488',N'4C9920AE-F335-48B1-BDB0-276173305952',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'23A448C7-C9D1-4F7C-8032-E9F3B40FD080',N'4C9920AE-F335-48B1-BDB0-276173305952',N'<EFBFBD><EFBFBD><EFBFBD>沢<EFBFBD>ϱ<EFBFBD>',5)
|
||
|
||
GO
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/HJGLData_HJGL.aspx',30,N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'Menu_ZHGL',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'E66A78DB-2175-4EBD-98B0-678482814724',N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'337B5B86-DBD9-44EB-9F48-2511876709B2',N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'57F4D505-F1BC-4370-9108-BD40A7FD4126',N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'8ECA6557-17B0-4669-ABC1-B698DE5D9E6D',N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'D1C34E85-955F-4348-AB51-A844BCE0B360',N'2110702F-4E12-479A-8EA1-E5A8EEF77276',N'<EFBFBD><EFBFBD><EFBFBD>沢<EFBFBD>ϱ<EFBFBD>',5)
|
||
|
||
GO
|
||
--INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
--VALUES ( N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'ʵҵ<CAB5><D2B5><EFBFBD><EFBFBD>','ZHGL/DataSync/SYHSEData_SYHSE.aspx',40,N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'Menu_ZHGL',1,1,1)
|
||
--GO
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'7F8BA66D-DB63-4DBB-9EB6-73F0280CFA30',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><><EFBFBD><EFBFBD>',1)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'EB8B7C26-E1A0-4498-8089-35637CC6DF26',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><EFBFBD>',2)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'968690EE-8FE8-482A-AF0C-B08D919EF933',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'ɾ<><C9BE>',3)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'8C6B85C7-81C9-4F7E-95C4-576DB34F3B18',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><><EFBFBD><EFBFBD>',4)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'D627B46D-4D5B-49BA-8AE9-5C7C5C0295CD',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><><EFBFBD>沢<EFBFBD>ϱ<EFBFBD>',5)
|
||
|
||
--GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_HSSEData_HSSE](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[BeUnderConstructionNum] [int] NULL,
|
||
[ShutdownNum] [int] NULL,
|
||
[JoinConstructionPersonNum] [int] NULL,
|
||
[MajorProjectsUnderConstructionNum] [int] NULL,
|
||
[TotalWorkingHour] [int] NULL,
|
||
[LostWorkingHour] [int] NULL,
|
||
[SafeWorkingHour] [int] NULL,
|
||
[SafeTrainNum] [int] NULL,
|
||
[SpecialTrainNum] [int] NULL,
|
||
[SpecialOperationTrainNum] [int] NULL,
|
||
[TotalEnergyConsumption] [int] NULL,
|
||
[IncomeComprehensiveEnergyConsumption] [int] NULL,
|
||
[NewWaterConsumption] [int] NULL,
|
||
[HeadOfficeInspectorGeneralNum] [int] NULL,
|
||
[HeadOfficeFullTimeNum] [int] NULL,
|
||
[BranchInspectorGeneralNum] [int] NULL,
|
||
[BranchFullTimeNum] [int] NULL,
|
||
[ProjectInspectorGeneralNum] [int] NULL,
|
||
[ProjectFullTimeNum] [int] NULL,
|
||
[ProjectSafetyMonitorNum] [int] NULL,
|
||
[SafetyInjectionEngineer] [int] NULL,
|
||
[CertificateANum] [int] NULL,
|
||
[CertificateBNum] [int] NULL,
|
||
[CertificateCNum] [int] NULL,
|
||
[SafetyCommitteeMeetingNum] [int] NULL,
|
||
[EnterpriseTopicsMeetingNum] [int] NULL,
|
||
[ProjectSafetyLeadingGroupMeetingNum] [int] NULL,
|
||
[ProjectSafetyMeetingNum] [int] NULL,
|
||
[CompanyLeadShiftCheckNum] [int] NULL,
|
||
[CompanyComprehensiveCheckNum] [int] NULL,
|
||
[CompanySpecialCheckNum] [int] NULL,
|
||
[ProjectLeadShiftCheckNum] [int] NULL,
|
||
[ProjectSpecialCheckNum] [int] NULL,
|
||
[ProjectMajorCheckNum] [int] NULL,
|
||
[NearMissNum] [int] NULL,
|
||
[RecordableEventNum] [int] NULL,
|
||
[GeneralAccidentNum] [int] NULL,
|
||
[MajorAccidentNum] [int] NULL,
|
||
[SeriousAccidentNum] [int] NULL,
|
||
[SpecialSeriousAccidentNum] [int] NULL,
|
||
[CompanyComprehensivePlanNum] [int] NULL,
|
||
[CompanySpecialPlanNum] [int] NULL,
|
||
[CompanyOnSiteDisposalPlan] [int] NULL,
|
||
[CompanyDrillNum] [int] NULL,
|
||
[ProjectComprehensivePlanNum] [int] NULL,
|
||
[ProjectSpecialPlanNum] [int] NULL,
|
||
[ProjectOnSiteDisposalPlan] [int] NULL,
|
||
[ProjectDrillNum] [int] NULL,
|
||
[CostExtract] [int] NULL,
|
||
[CostUse] [int] NULL,
|
||
[UseEquipmentNum] [int] NULL,
|
||
[SpecialEquipmentNum] [int] NULL,
|
||
[LicensesNum] [int] NULL,
|
||
[LicensesCloseNum] [int] NULL,
|
||
[GeneralClosedNum] [int] NULL,
|
||
[GeneralNotClosedNum] [int] NULL,
|
||
[MajorClosedNum] [int] NULL,
|
||
[MajorNotClosedNum] [int] NULL,
|
||
[GeneralRiskNum] [int] NULL,
|
||
[LowRiskNum] [int] NULL,
|
||
[MediumRiskNum] [int] NULL,
|
||
[HighRiskNum] [int] NULL,
|
||
[CompletedNum] [int] NULL,
|
||
[TrainPersonNum] [int] NULL,
|
||
[ConstructionNum] [int] NULL,
|
||
[FinishedNum] [int] NULL,
|
||
[SuperCompletedNum] [int] NULL,
|
||
[SuperTrainPersonNum] [int] NULL,
|
||
[SuperConstructionNum] [int] NULL,
|
||
[SuperFinishedNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_HSSEData_HSSE] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ڽ<EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BeUnderConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ͣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ShutdownNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ν<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'JoinConstructionPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʩΣ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorProjectsUnderConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܹ<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TotalWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʧ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LostWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafeWorkingHour'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafeTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ר<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ѵ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialOperationTrainNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܺ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TotalEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ԪӪҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD><EFBFBD>ܺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'IncomeComprehensiveEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˮ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'NewWaterConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD><EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HeadOfficeInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD>רְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HeadOfficeFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BranchInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD>רְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'BranchFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD>ܼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectInspectorGeneralNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀרְ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectFullTimeNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyMonitorNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ڸ<EFBFBD>ִҵע<EFBFBD><EFBFBD>ʦ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafetyInjectionEngineer'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateANum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'B֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateBNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'C֤<EFBFBD><EFBFBD>Ա' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CertificateCNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ί<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SafetyCommitteeMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'EnterpriseTopicsMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD>쵼С<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyLeadingGroupMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSafetyMeetingNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyLeadShiftCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ۺϼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyComprehensiveCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanySpecialCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectLeadShiftCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀר<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSpecialCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀרҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectMajorCheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'δ<EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'NearMissNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ɼ<EFBFBD>¼<EFBFBD>¼<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'RecordableEventNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϴ<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SeriousAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ر<EFBFBD><EFBFBD>ش<EFBFBD><EFBFBD>¹<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialSeriousAccidentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyComprehensivePlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD>ר<EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanySpecialPlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ֳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyOnSiteDisposalPlan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompanyDrillNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectComprehensivePlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD>ר<EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectSpecialPlanNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD>ֳ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԥ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectOnSiteDisposalPlan'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ProjectDrillNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȡ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ԫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CostExtract'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ʹ<EFBFBD>ã<EFBFBD><EFBFBD><EFBFBD>Ԫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CostUse'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'UseEquipmentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>豸<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SpecialEquipmentNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LicensesNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD><EFBFBD><EFBFBD>ɹر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LicensesCloseNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MajorNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'GeneralRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ͷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'LowRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>з<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'MediumRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>߷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'HighRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'CompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'TrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD>ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'ConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Σ<EFBFBD><EFBFBD><EFBFBD>깤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'FinishedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperTrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD>ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperConstructionNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Σ<EFBFBD><EFBFBD><EFBFBD>깤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE', @level2type=N'COLUMN',@level2name=N'SuperFinishedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'HSSE<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HSSE'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_HSSEData_HiddenDangerDetail](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[TypeName] [nvarchar](50) NULL,
|
||
[TotalNum] [int] NULL,
|
||
[NeedRectifyNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_HSSEData_HiddenDangerDetail] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'TypeName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'TotalNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail', @level2type=N'COLUMN',@level2name=N'NeedRectifyNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ų<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HSSEData_HiddenDangerDetail'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_CQMSData_CQMS](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[TrainPersonNum] [int] NULL,
|
||
[TechnicalDisclosePersonNum] [int] NULL,
|
||
[UseNum] [int] NULL,
|
||
[OKNum] [int] NULL,
|
||
[CompanyPersonNum] [int] NULL,
|
||
[BranchPersonNum] [int] NULL,
|
||
[ProjectPersonNum] [int] NULL,
|
||
[ProblemNum] [int] NULL,
|
||
[ProblemCompletedNum] [int] NULL,
|
||
[ProblemNotCompletedNum] [int] NULL,
|
||
[SNum] [int] NULL,
|
||
[ANum] [int] NULL,
|
||
[BNum] [int] NULL,
|
||
[CNum] [int] NULL,
|
||
[KeyProcessNum] [int] NULL,
|
||
[KeyProcessOKNum] [int] NULL,
|
||
[SpecialProcessNum] [int] NULL,
|
||
[SpecialProcessOKNum] [int] NULL,
|
||
[ConcealedWorksNum] [int] NULL,
|
||
[ConcealedWorksOKNum] [int] NULL,
|
||
[UnitProjectOnesNum] [int] NULL,
|
||
[UnitProjectOnesOKNum] [int] NULL,
|
||
[MaterialInRecheckNum] [int] NULL,
|
||
[MaterialInRecheckOKNum] [int] NULL,
|
||
[SingleProjectNum] [int] NULL,
|
||
[UnitProjectNum] [int] NULL,
|
||
[SubProjectNum] [int] NULL,
|
||
[SubdivisionalWorksNum] [int] NULL,
|
||
[InspectionLotNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_CQMSData_CQMS] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѵ<EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'TrainPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>˴<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'TechnicalDisclosePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ü<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UseNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'У<EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'OKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ҵ<EFBFBD>ܲ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CompanyPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>֧<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'BranchPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ŀ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProjectPersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ProblemNotCompletedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'A<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ANum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'B<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'BNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'C<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'CNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ؼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'KeyProcessNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ؼ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'KeyProcessOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SpecialProcessNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SpecialProcessOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ConcealedWorksNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'ConcealedWorksOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectOnesNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>պϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectOnesOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>Ͻ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'MaterialInRecheckNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>Ͻ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ϸ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'MaterialInRecheckOKNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SingleProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'UnitProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ֲ<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SubProjectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD≯<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'SubdivisionalWorksNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS', @level2type=N'COLUMN',@level2name=N'InspectionLotNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CQMS<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_CQMSData_CQMS'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_HJGLData_HJGL](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[WelderNum] [int] NULL,
|
||
[TotalDineNum] [int] NULL,
|
||
[CompleteDineNum] [int] NULL,
|
||
[TotalFilmNum] [int] NULL,
|
||
[OKFilmNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_HJGLData_HJGL] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'WelderNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'TotalDineNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ɴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'CompleteDineNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ƭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'TotalFilmNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϸ<EFBFBD>Ƭ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL', @level2type=N'COLUMN',@level2name=N'OKFilmNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_HJGL'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_HJGLData_Defect](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[DefectName] [nvarchar](50) NULL,
|
||
[DefectNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_HJGLData_Defect] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'DefectName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ȱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect', @level2type=N'COLUMN',@level2name=N'DefectNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȱ<EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_HJGLData_Defect'
|
||
GO
|
||
|
||
|
||
|
||
CREATE TABLE [dbo].[Project_SYHSEData_SYHSE](
|
||
[Id] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[CollCropCode] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[ReportDate] [datetime] NULL,
|
||
[GeneralRiskNum] [int] NULL,
|
||
[LowRiskNum] [int] NULL,
|
||
[MediumRiskNum] [int] NULL,
|
||
[HighRiskNum] [int] NULL,
|
||
[GradedResponsiblePersonNum] [int] NULL,
|
||
[ChargeInsurancePersonNum] [int] NULL,
|
||
[DesignQuantity] [int] NULL,
|
||
[RunningCapacity] [int] NULL,
|
||
[InterlockSettingValue] [int] NULL,
|
||
[VideoSurveillanceNum] [int] NULL,
|
||
[TotalWorkinghours] [int] NULL,
|
||
[SafeWorkinghours] [int] NULL,
|
||
[LostWorkinghours] [int] NULL,
|
||
[TotalEnergyConsumption] [int] NULL,
|
||
[IncomeComprehensiveEnergyConsumption] [int] NULL,
|
||
[NewWaterConsumption] [int] NULL,
|
||
[GeneralClosedNum] [int] NULL,
|
||
[GeneralNotClosedNum] [int] NULL,
|
||
[MajorClosedNum] [int] NULL,
|
||
[MajorNotClosedNum] [int] NULL,
|
||
[HotWorkPermitNum] [int] NULL,
|
||
[HotWorkClosedNum] [int] NULL,
|
||
[HighPermitNum] [int] NULL,
|
||
[HighClosedNum] [int] NULL,
|
||
[TemporaryElectricityPermitNum] [int] NULL,
|
||
[TemporaryElectricityClosedNum] [int] NULL,
|
||
[BlindPlatePermitNum] [int] NULL,
|
||
[BlindPlateClosedNum] [int] NULL,
|
||
[GroundbreakingPermitNum] [int] NULL,
|
||
[GroundbreakingClosedNum] [int] NULL,
|
||
[OpenCircuitPermitNum] [int] NULL,
|
||
[OpenCircuitClosedNum] [int] NULL,
|
||
[HoistingPermitNum] [int] NULL,
|
||
[HoistingClosedNum] [int] NULL,
|
||
CONSTRAINT [PK_Project_SYHSEData_SYHSE] 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]
|
||
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'Id'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'UnitId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ͳһ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'CollCropCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>λ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'UnitName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ϱ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'ReportDate'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ͷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'LowRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>з<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MediumRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>߷<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighRiskNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ּ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GradedResponsiblePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'ChargeInsurancePersonNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'DesignQuantity'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'RunningCapacity'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>趨ֵ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'InterlockSettingValue'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>Ƶ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'VideoSurveillanceNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܹ<EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TotalWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'SafeWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ʧ<EFBFBD><EFBFBD>ʱ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'LostWorkinghours'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܺ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TotalEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ԪӪҵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ۺ<EFBFBD><EFBFBD>ܺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'IncomeComprehensiveEnergyConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ˮ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'NewWaterConsumption'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'һ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GeneralNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ıջ<EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MajorClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ش<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>δ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'MajorNotClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HotWorkPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HotWorkClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ߴ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ߴ<EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HighClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TemporaryElectricityPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ٵ<EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'TemporaryElectricityClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'BlindPlatePermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ä<EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'BlindPlateClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GroundbreakingPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'GroundbreakingClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>·<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'OpenCircuitPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>·<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'OpenCircuitClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HoistingPermitNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>װ<EFBFBD>ر<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE', @level2type=N'COLUMN',@level2name=N'HoistingClosedNum'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ʵҵ<EFBFBD><EFBFBD>ҳ<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Project_SYHSEData_SYHSE'
|
||
GO
|
||
|
||
CREATE TABLE [dbo].[Hazard_RealTimeDevice](
|
||
[ID] [nvarchar](50) NOT NULL,
|
||
[UnitId] [nvarchar](50) NULL,
|
||
[UnitName] [nvarchar](50) NULL,
|
||
[HazardName] [nvarchar](50) NULL,
|
||
[HazardLevel] [nvarchar](50) NULL,
|
||
[DeviceCode] [nvarchar](50) NULL,
|
||
[DeviceName] [nvarchar](50) NULL,
|
||
[DeviceType] [nvarchar](50) NULL,
|
||
[SphereType] [nvarchar](50) NULL,
|
||
[TemperatureType] [nvarchar](50) NULL,
|
||
[DesignTemperantureMax] [nvarchar](50) NULL,
|
||
[DesignTemperantureMin] [nvarchar](50) NULL,
|
||
[PressureType] [nvarchar](50) NULL,
|
||
[DesignPressure] [nvarchar](50) NULL,
|
||
[DesignPressureMax] [nvarchar](50) NULL,
|
||
[Medium] [nvarchar](50) NULL,
|
||
[MediumForm] [nvarchar](50) NULL,
|
||
[MediumLevelMax] [nvarchar](50) NULL,
|
||
[Reserves] [nvarchar](50) NULL,
|
||
[StandardCode] [nvarchar](50) NULL,
|
||
[StandardName] [nvarchar](50) NULL,
|
||
[StandardType] [nvarchar](50) NULL,
|
||
[StandardDes] [nvarchar](500) NULL,
|
||
[MeasurementUnit] [nvarchar](50) NULL,
|
||
[MeterMax] [nvarchar](50) NULL,
|
||
[MeterMin] [nvarchar](50) NULL,
|
||
[ThresholdLow1] [nvarchar](50) NULL,
|
||
[ThresholdLow2] [nvarchar](50) NULL,
|
||
[ThresholdMax1] [nvarchar](50) NULL,
|
||
[ThresholdMax2] [nvarchar](50) NULL,
|
||
[BitNum] [nvarchar](50) NULL,
|
||
[DateTime] [datetime] NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
CONSTRAINT [PK_Hazard] 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]
|
||
|
||
GO
|
||
|
||
|
||
CREATE TABLE [dbo].[Hazard_RealTimeValue](
|
||
[ID] [nvarchar](50) NOT NULL,
|
||
[Value] [nvarchar](50) NULL,
|
||
[DateTime] [nvarchar](50) NULL,
|
||
[BitNum] [nvarchar](50) NULL,
|
||
[Remark] [nvarchar](500) NULL,
|
||
CONSTRAINT [PK_Hazard_RealTimeValue] 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]
|
||
|
||
GO
|
||
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'C483220C-0FEE-4E45-9B78-BBBA857EFFB3',N'<EFBFBD><EFBFBD>ȫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/ProjectDataSync/Project_HSSEData_HSSE.aspx',160,N'6A0506EB-05CE-4BB3-9BA9-866389F01E1C',N'Menu_HSSE',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'E2FB07FE-84DC-4BF1-9798-7168976F632C',N'C483220C-0FEE-4E45-9B78-BBBA857EFFB3',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'6158D1D5-3AD1-4B55-84D2-3EA0A7D148CD',N'C483220C-0FEE-4E45-9B78-BBBA857EFFB3',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'A76E59F7-FD2A-458B-9CA4-F42B3DBCAEF6',N'C483220C-0FEE-4E45-9B78-BBBA857EFFB3',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'8703A742-638C-4084-A00D-A559C83CD3BF',N'C483220C-0FEE-4E45-9B78-BBBA857EFFB3',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
|
||
|
||
GO
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'B2086D3A-2384-487E-AFFB-6FACDD09B621',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/ProjectDataSync/Project_CQMSData_CQMS.aspx',70,N'4a0e62cb-ee50-4a14-80b7-377602e9902c',N'Menu_CQMS',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'3524F8DA-99B3-466A-A836-64DE28D289D3',N'B2086D3A-2384-487E-AFFB-6FACDD09B621',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'BCBBC252-AA7C-4E20-91AE-09E0534F3224',N'B2086D3A-2384-487E-AFFB-6FACDD09B621',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'7203E174-4C42-4064-943B-C7AB4C4AD4E9',N'B2086D3A-2384-487E-AFFB-6FACDD09B621',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'138C136C-7C87-4BA9-87B9-19185982F8FF',N'B2086D3A-2384-487E-AFFB-6FACDD09B621',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
|
||
GO
|
||
INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
VALUES ( N'6035E549-66FF-4B6D-989B-BE99C9EF5EB7',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>','ZHGL/DataSync/ProjectDataSync/Project_HJGLData_HJGL.aspx',160,N'F3B157B7-9BEE-4150-80CB-087828F1C51D',N'Menu_HJGL',1,1,1)
|
||
GO
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'A4831499-CE34-49BE-B35B-BE8208CBBD55',N'6035E549-66FF-4B6D-989B-BE99C9EF5EB7',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'DF5DE385-5C50-40AC-8D51-E83A49FD7E52',N'6035E549-66FF-4B6D-989B-BE99C9EF5EB7',N'<EFBFBD><EFBFBD>',2)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'407DB594-D61C-4349-AE52-B5D635FF8C2A',N'6035E549-66FF-4B6D-989B-BE99C9EF5EB7',N'ɾ<EFBFBD><EFBFBD>',3)
|
||
INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'36119E83-A0DF-4955-A076-E58EDFD2ECD6',N'6035E549-66FF-4B6D-989B-BE99C9EF5EB7',N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
||
|
||
GO
|
||
--INSERT Sys_Menu (MenuId,MenuName,Url,SortIndex,SuperMenu,MenuType,IsOffice,IsEnd,IsUsed)
|
||
--VALUES ( N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'ʵҵ<CAB5><D2B5><EFBFBD><EFBFBD>','ZHGL/DataSync/SYHSEData_SYHSE.aspx',30,N'1E216BE3-DB22-4649-BD9A-0777B0DC03E6',N'Menu_ZHGL',1,1,1)
|
||
--GO
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'7F8BA66D-DB63-4DBB-9EB6-73F0280CFA30',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><><EFBFBD><EFBFBD>',1)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'EB8B7C26-E1A0-4498-8089-35637CC6DF26',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><EFBFBD>',2)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'968690EE-8FE8-482A-AF0C-B08D919EF933',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'ɾ<><C9BE>',3)
|
||
-- INSERT Sys_ButtonToMenu (ButtonToMenuId,MenuId,ButtonName,SortIndex) VALUES ( N'8C6B85C7-81C9-4F7E-95C4-576DB34F3B18',N'64EE5EC2-F725-4656-9110-5AF83C18FB6C',N'<27><><EFBFBD><EFBFBD>',4)
|
||
|
||
--GO
|