HJGL_DS/DataBase/版本日志/HJGLDB_DS_2026-01-28_xiaj.sql

--<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>

/**********<EFBFBD>˵<EFBFBD>************************************************************/

--26<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȷ<EFBFBD>ϼ<EFBFBD>¼
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = 'C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E')
BEGIN
	INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
	VALUES ('C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E','<EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȷ<EFBFBD>ϼ<EFBFBD>¼','JGZL/PressureTestOfPipelineSystemConfirmationRecord.aspx',260,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
END
GO
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E')
BEGIN
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('6E4DCE61-6A33-4BD0-8008-13B7DDFD4156','C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('58B3FFF1-CE29-4EB3-92CC-B5B274EDB182','C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E','<EFBFBD>޸<EFBFBD>',2)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('4EC3C837-3BF9-42E1-B06F-2AEA074DF52D','C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E','ɾ<EFBFBD><EFBFBD>',3)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('139EEC34-7E29-47AA-919F-F9989211BD69','C1E0F7E9-7786-49B8-89BA-4BD12DF7F50E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
END
GO

--27<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = 'B8A07C4A-E480-4658-A5BF-2A2CEE829622')
BEGIN
	INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
	VALUES ('B8A07C4A-E480-4658-A5BF-2A2CEE829622','<EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼','JGZL/PressureTestOfPipelineSystemRecord.aspx',270,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
END
GO
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'B8A07C4A-E480-4658-A5BF-2A2CEE829622')
BEGIN
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('87CD243B-A206-4B67-AD14-2BD9F1C91D97','B8A07C4A-E480-4658-A5BF-2A2CEE829622','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('2C23E5CC-2CAE-46D8-B890-36CDFE7C64A2','B8A07C4A-E480-4658-A5BF-2A2CEE829622','<EFBFBD>޸<EFBFBD>',2)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('E6FB0C23-6A6A-4890-9553-01C157AED2CE','B8A07C4A-E480-4658-A5BF-2A2CEE829622','ɾ<EFBFBD><EFBFBD>',3)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('48F71436-346A-459F-9A6F-596F9F6F66AC','B8A07C4A-E480-4658-A5BF-2A2CEE829622','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
END
GO

--28<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳй©<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = 'FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94')
BEGIN
	INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
	VALUES ('FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94','<EFBFBD>ܵ<EFBFBD>ϵͳй©<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼','JGZL/LeakTestOfPipelineSystemRecord.aspx',280,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
END
GO
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94')
BEGIN
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('9BD5A7CF-E829-42FF-A99F-380E6CF613C7','FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('C946AA1A-F7C5-422B-88DD-53614F5C9E1B','FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94','<EFBFBD>޸<EFBFBD>',2)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('1092A6E7-7FE2-4F96-A269-5A192CC98BAA','FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94','ɾ<EFBFBD><EFBFBD>',3)
	INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
	VALUES ('D66ADB7B-DC0C-49C5-B190-CB66DC0CB1EF','FF56CCBE-0B8C-4AF6-832E-EC6ED1584C94','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
END
GO

/**********<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>************************************************************/

--26<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ȷ<EFBFBD>ϼ<EFBFBD>¼
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'JGZL_PressureTestOfPipelineSystemConfirmationRecord') AND type = N'U')
BEGIN

CREATE TABLE [dbo].[JGZL_PressureTestOfPipelineSystemConfirmationRecord](
	[RecordId] [nvarchar](50) NOT NULL,
	[ProjectId] [nvarchar](50) NULL,
	[SystemName] [nvarchar](50) NULL,
	[SystemCode] [nvarchar](50) NULL,
	[CheckItem1] [nvarchar](50) NULL,
	[CheckItem2] [nvarchar](50) NULL,
	[CheckItem3] [nvarchar](50) NULL,
	[CheckItem4] [nvarchar](50) NULL,
	[CheckItem5] [nvarchar](50) NULL,
	[CheckItem6] [nvarchar](50) NULL,
	[CheckItem7] [nvarchar](50) NULL,
	[CheckItem8] [nvarchar](50) NULL,
	[CheckItem9] [nvarchar](50) NULL,
	[CheckItem10] [nvarchar](50) NULL,
	[CheckItem11] [nvarchar](50) NULL,
	[CheckItem12] [nvarchar](50) NULL,
	[Remark] [nvarchar](500) NULL,
	[CompileMan] [nvarchar](50) NULL,
	[CompileDate] [datetime] NULL,
	[Reviewer] [nvarchar](50) NULL,
	[RevieweDate] [datetime] NULL,
 CONSTRAINT [PK_JGZL_PressureTestOfPipelineSystemConfirmationRecord] PRIMARY KEY CLUSTERED 
(
	[RecordId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemConfirmationRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemConfirmationRecord_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemConfirmationRecord] CHECK CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemConfirmationRecord_Base_Project]
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemConfirmationRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemConfirmationRecord_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemConfirmationRecord] CHECK CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemConfirmationRecord_Sys_User]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'ProjectId'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'SystemName'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'SystemCode'
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>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem1'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem2'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem3'
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><EFBFBD><EFBFBD><EFBFBD>ļ<EFBFBD><EFBFBD>͹淶Ҫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem4'
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><EFBFBD>͹淶Ҫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem5'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem6'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem7'
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><EFBFBD><EFBFBD><EFBFBD>DZ<EFBFBD><EFBFBD>Ѱ<EFBFBD><EFBFBD>涨<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>룬<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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem8'
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>ʩ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem9'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>ӽ<EFBFBD>ͷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Ҫ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>IJ<EFBFBD>λδ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem10'
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><EFBFBD>춨״̬<EFBFBD><EFBFBD><EFBFBD>Ϲ淶Ҫ<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem11'
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>ʷ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CheckItem12'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'Remark'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CompileMan'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'CompileDate'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'Reviewer'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord', @level2type=N'COLUMN',@level2name=N'RevieweDate'
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'JGZL_PressureTestOfPipelineSystemConfirmationRecord'

END

GO


--27<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'JGZL_PressureTestOfPipelineSystemRecord') AND type = N'U')
BEGIN

CREATE TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecord](
	[RecordId] [nvarchar](50) NOT NULL,
	[ProjectId] [nvarchar](50) NULL,
	[SystemName] [nvarchar](50) NULL,
	[SystemCode] [nvarchar](50) NULL,
	[TestConclusion] [nvarchar](2000) NULL,
	[Remark] [nvarchar](500) NULL,
	[CompileMan] [nvarchar](50) NULL,
	[CompileDate] [datetime] NULL,
	[Reviewer] [nvarchar](50) NULL,
	[RevieweDate] [datetime] NULL,
 CONSTRAINT [PK_JGZL_PressureTestOfPipelineSystemRecord] PRIMARY KEY CLUSTERED 
(
	[RecordId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemRecord_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecord] CHECK CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemRecord_Base_Project]
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemRecord_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
ALTER TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecord] CHECK CONSTRAINT [FK_JGZL_PressureTestOfPipelineSystemRecord_Sys_User]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'ProjectId'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'SystemName'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'SystemCode'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'TestConclusion'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'Remark'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'CompileMan'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'CompileDate'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'Reviewer'
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'JGZL_PressureTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RevieweDate'
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'JGZL_PressureTestOfPipelineSystemRecord'

END

GO

--<EFBFBD>ܵ<EFBFBD>ϵͳѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><EFBFBD>
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'JGZL_PressureTestOfPipelineSystemRecordItem') AND type = N'U')
BEGIN

CREATE TABLE [dbo].[JGZL_PressureTestOfPipelineSystemRecordItem](
	[Id] [nvarchar](50) NOT NULL,
	[RecordId] [nvarchar](50) NOT NULL,
	[PipelineNo] [nvarchar](50) NULL,
	[DesignPressure] [nvarchar](50) NULL,
	[DesignTemperature] [nvarchar](50) NULL,
	[TestTemperature] [nvarchar](50) NULL,
	[TestMedium] [nvarchar](50) NULL,
	[TestMediumTemperature] [nvarchar](50) NULL,
	[TestPressure] [nvarchar](50) NULL,
	[VoltageStabilizationTime] [nvarchar](50) NULL,
 CONSTRAINT [PK_JGZL_PressureTestOfPipelineSystemRecordItem] 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]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'Id'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>/<2F><><EFBFBD>ߺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'PipelineNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>MPa<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'DesignPressure'
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'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'DesignTemperature'
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'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestTemperature'
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'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestMedium'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¶ȣ<EFBFBD><EFBFBD>棩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestMediumTemperature'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>MPa<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestPressure'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ѹʱ<EFBFBD>䣨min<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PressureTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'VoltageStabilizationTime'
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'JGZL_PressureTestOfPipelineSystemRecordItem'

END

GO

--28<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD>ϵͳй©<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'JGZL_LeakTestOfPipelineSystemRecord') AND type = N'U')
BEGIN

CREATE TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecord](
	[RecordId] [nvarchar](50) NOT NULL,
	[ProjectId] [nvarchar](50) NULL,
	[SystemName] [nvarchar](50) NULL,
	[SystemCode] [nvarchar](50) NULL,
	[TestConclusion] [nvarchar](2000) NULL,
	[Remark] [nvarchar](500) NULL,
	[CompileMan] [nvarchar](50) NULL,
	[CompileDate] [datetime] NULL,
	[Reviewer] [nvarchar](50) NULL,
	[RevieweDate] [datetime] NULL,
 CONSTRAINT [PK_JGZL_LeakTestOfPipelineSystemRecord] PRIMARY KEY CLUSTERED 
(
	[RecordId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_LeakTestOfPipelineSystemRecord_Base_Project] FOREIGN KEY([ProjectId])
REFERENCES [dbo].[Base_Project] ([ProjectId])
ALTER TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecord] CHECK CONSTRAINT [FK_JGZL_LeakTestOfPipelineSystemRecord_Base_Project]
ALTER TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecord]  WITH CHECK ADD  CONSTRAINT [FK_JGZL_LeakTestOfPipelineSystemRecord_Sys_User] FOREIGN KEY([CompileMan])
REFERENCES [dbo].[Sys_User] ([UserId])
ALTER TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecord] CHECK CONSTRAINT [FK_JGZL_LeakTestOfPipelineSystemRecord_Sys_User]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ĿId' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'ProjectId'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'SystemName'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'SystemCode'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'TestConclusion'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'Remark'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'CompileMan'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'CompileDate'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'Reviewer'
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'JGZL_LeakTestOfPipelineSystemRecord', @level2type=N'COLUMN',@level2name=N'RevieweDate'
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'JGZL_LeakTestOfPipelineSystemRecord'

END

GO

--<EFBFBD>ܵ<EFBFBD>ϵͳй©<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼<EFBFBD><EFBFBD>
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'JGZL_LeakTestOfPipelineSystemRecordItem') AND type = N'U')
BEGIN

CREATE TABLE [dbo].[JGZL_LeakTestOfPipelineSystemRecordItem](
	[Id] [nvarchar](50) NOT NULL,
	[RecordId] [nvarchar](50) NOT NULL,
	[PipelineNo] [nvarchar](50) NULL,
	[DesignPressure] [nvarchar](50) NULL,
	[DesignTemperature] [nvarchar](50) NULL,
	[TestTemperature] [nvarchar](50) NULL,
	--[TestMedium] [nvarchar](50) NULL,
	[TestMediumTemperature] [nvarchar](50) NULL,
	[TestPressure] [nvarchar](50) NULL,
	[VoltageStabilizationTime] [nvarchar](50) NULL,
 CONSTRAINT [PK_JGZL_LeakTestOfPipelineSystemRecordItem] 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]
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'Id'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'RecordId'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>/<2F><><EFBFBD>ߺ<EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'PipelineNo'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>MPa<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'DesignPressure'
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'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'DesignTemperature'
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'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestTemperature'
--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'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestMedium'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¶ȣ<EFBFBD><EFBFBD>棩' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestMediumTemperature'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ѹ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>MPa<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'TestPressure'
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ѹʱ<EFBFBD>䣨min<EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_LeakTestOfPipelineSystemRecordItem', @level2type=N'COLUMN',@level2name=N'VoltageStabilizationTime'
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'JGZL_LeakTestOfPipelineSystemRecordItem'

END

GO