331 lines
31 KiB
MySQL
331 lines
31 KiB
MySQL
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
/**********<EFBFBD>˵<EFBFBD>************************************************************/
|
|||
|
|
|
|||
|
|
|
|||
|
|
--42<EFBFBD><EFBFBD><EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼
|
|||
|
|
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = '32B46F24-DA2A-40BC-9DB8-29D0A1A382B1')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
|||
|
|
VALUES ('32B46F24-DA2A-40BC-9DB8-29D0A1A382B1','<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>¼','JGZL/PipelineInstallationInspectionRecord.aspx',420,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = '32B46F24-DA2A-40BC-9DB8-29D0A1A382B1')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('85405401-D732-43CE-AC4B-146C4BA617DF','32B46F24-DA2A-40BC-9DB8-29D0A1A382B1','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('3CEEF467-4B7B-4E8C-A0A3-412920FBA25C','32B46F24-DA2A-40BC-9DB8-29D0A1A382B1','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('D83B664F-025E-476A-AF14-4DDB5934D042','32B46F24-DA2A-40BC-9DB8-29D0A1A382B1','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('7966E502-5E7B-4889-8E08-1F22ED72F5B0','32B46F24-DA2A-40BC-9DB8-29D0A1A382B1','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
--43<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ռ<EFBFBD>¼
|
|||
|
|
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = 'F0B43C16-6825-47A5-88D4-8ADDC5C9F34E')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
|||
|
|
VALUES ('F0B43C16-6825-47A5-88D4-8ADDC5C9F34E','<EFBFBD><EFBFBD><EFBFBD>ι<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ռ<EFBFBD>¼','JGZL/ConcealedWorksInspectionRecord.aspx',430,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'F0B43C16-6825-47A5-88D4-8ADDC5C9F34E')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('CD62B4FD-4571-4C5F-9E7E-DD00AB5ECCF1','F0B43C16-6825-47A5-88D4-8ADDC5C9F34E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('604FC21D-62F0-493E-A229-96A579C74118','F0B43C16-6825-47A5-88D4-8ADDC5C9F34E','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('2638A948-5C2C-44F5-97E6-7047E6FB95E8','F0B43C16-6825-47A5-88D4-8ADDC5C9F34E','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('D2293061-360B-4DAF-AF15-79917598389B','F0B43C16-6825-47A5-88D4-8ADDC5C9F34E','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
--44<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 = 'F5833B38-65DF-4236-A676-EE75F9487061')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
|||
|
|
VALUES ('F5833B38-65DF-4236-A676-EE75F9487061','<EFBFBD><EFBFBD>ҵ<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>','JGZL/IndustrialPipelineInstallationQualityCertificate.aspx',440,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'F5833B38-65DF-4236-A676-EE75F9487061')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('091E0FE5-4DEE-4044-9A4B-B5AB11305D6E','F5833B38-65DF-4236-A676-EE75F9487061','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('FE861861-DC5F-45CE-A24C-797CE564A30D','F5833B38-65DF-4236-A676-EE75F9487061','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('A77D1C0C-1E84-451B-B565-ACE676337273','F5833B38-65DF-4236-A676-EE75F9487061','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('98D45B02-B1F8-4C9E-9FDB-92EE01ABE4C6','F5833B38-65DF-4236-A676-EE75F9487061','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
--44<EFBFBD><EFBFBD><EFBFBD><EFBFBD>ҵ<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD>ܱ<EFBFBD>
|
|||
|
|
IF NOT EXISTS (SELECT * FROM Sys_Menu WHERE MenuId = 'C527812C-0FF8-4EAC-B1FD-3B561DBE46ED')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
|||
|
|
VALUES ('C527812C-0FF8-4EAC-B1FD-3B561DBE46ED','<EFBFBD><EFBFBD>ҵ<EFBFBD>ܵ<EFBFBD><EFBFBD><EFBFBD>װ<EFBFBD><EFBFBD><EFBFBD>ܱ<EFBFBD>','JGZL/IndustrialPipelineInstallationSummary.aspx',445,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
IF NOT EXISTS (SELECT * FROM ButtonToMenu WHERE MenuId = 'C527812C-0FF8-4EAC-B1FD-3B561DBE46ED')
|
|||
|
|
BEGIN
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('4406F283-A0BE-49D2-B467-6E5D135124D9','C527812C-0FF8-4EAC-B1FD-3B561DBE46ED','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',1)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('8D020AEC-1F19-49F1-A71D-458586FA788C','C527812C-0FF8-4EAC-B1FD-3B561DBE46ED','<EFBFBD><EFBFBD>',2)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('9D6996F3-B2B0-450C-87A0-D069D38640E8','C527812C-0FF8-4EAC-B1FD-3B561DBE46ED','ɾ<EFBFBD><EFBFBD>',3)
|
|||
|
|
INSERT INTO ButtonToMenu(ButtonToMenuId,MenuId,ButtonName,SortIndex)
|
|||
|
|
VALUES ('60FBB6AA-F717-4639-8724-370F03458FBD','C527812C-0FF8-4EAC-B1FD-3B561DBE46ED','<EFBFBD><EFBFBD><EFBFBD><EFBFBD>',4)
|
|||
|
|
END
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
/**********<EFBFBD><EFBFBD><EFBFBD>ݱ<EFBFBD>************************************************************/
|
|||
|
|
|
|||
|
|
|
|||
|
|
--42<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_PipelineInstallationInspectionRecord') AND type = N'U')
|
|||
|
|
BEGIN
|
|||
|
|
|
|||
|
|
CREATE TABLE [dbo].[JGZL_PipelineInstallationInspectionRecord](
|
|||
|
|
[RecordId] [nvarchar](50) NOT NULL,
|
|||
|
|
[ProjectId] [nvarchar](50) NULL,
|
|||
|
|
[ProfessionalEngineering] [nvarchar](50) NULL,
|
|||
|
|
[DrawingNumber] [nvarchar](50) NULL,
|
|||
|
|
[InspectionItems] [nvarchar](2000) NULL,
|
|||
|
|
[InspectionResults] [nvarchar](2000) NULL,
|
|||
|
|
[Remark] [nvarchar](500) NULL,
|
|||
|
|
[CompileMan] [nvarchar](50) NULL,
|
|||
|
|
[CompileDate] [datetime] NULL,
|
|||
|
|
[Reviewer] [nvarchar](50) NULL,
|
|||
|
|
[RevieweDate] [datetime] NULL,
|
|||
|
|
CONSTRAINT [PK_JGZL_PipelineInstallationInspectionRecord] 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_PipelineInstallationInspectionRecord] WITH CHECK ADD CONSTRAINT [FK_JGZL_PipelineInstallationInspectionRecord_Base_Project] FOREIGN KEY([ProjectId])
|
|||
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_PipelineInstallationInspectionRecord] CHECK CONSTRAINT [FK_JGZL_PipelineInstallationInspectionRecord_Base_Project]
|
|||
|
|
ALTER TABLE [dbo].[JGZL_PipelineInstallationInspectionRecord] WITH CHECK ADD CONSTRAINT [FK_JGZL_PipelineInstallationInspectionRecord_Sys_User] FOREIGN KEY([CompileMan])
|
|||
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_PipelineInstallationInspectionRecord] CHECK CONSTRAINT [FK_JGZL_PipelineInstallationInspectionRecord_Sys_User]
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @level2type=N'COLUMN',@level2name=N'ProfessionalEngineering'
|
|||
|
|
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_PipelineInstallationInspectionRecord', @level2type=N'COLUMN',@level2name=N'DrawingNumber'
|
|||
|
|
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_PipelineInstallationInspectionRecord', @level2type=N'COLUMN',@level2name=N'InspectionItems'
|
|||
|
|
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_PipelineInstallationInspectionRecord', @level2type=N'COLUMN',@level2name=N'InspectionResults'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord', @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_PipelineInstallationInspectionRecord'
|
|||
|
|
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
--43<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_ConcealedWorksInspectionRecord') AND type = N'U')
|
|||
|
|
BEGIN
|
|||
|
|
|
|||
|
|
CREATE TABLE [dbo].[JGZL_ConcealedWorksInspectionRecord](
|
|||
|
|
[RecordId] [nvarchar](50) NOT NULL,
|
|||
|
|
[ProjectId] [nvarchar](50) NULL,
|
|||
|
|
[ConcealedWorks] [nvarchar](50) NULL,
|
|||
|
|
[DrawingNumber] [nvarchar](50) NULL,
|
|||
|
|
[ConcealedContentAndDiagram] [nvarchar](2000) NULL,
|
|||
|
|
[InspectionResults] [nvarchar](2000) NULL,
|
|||
|
|
[Remark] [nvarchar](500) NULL,
|
|||
|
|
[CompileMan] [nvarchar](50) NULL,
|
|||
|
|
[CompileDate] [datetime] NULL,
|
|||
|
|
[Reviewer] [nvarchar](50) NULL,
|
|||
|
|
[RevieweDate] [datetime] NULL,
|
|||
|
|
CONSTRAINT [PK_JGZL_ConcealedWorksInspectionRecord] 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_ConcealedWorksInspectionRecord] WITH CHECK ADD CONSTRAINT [FK_JGZL_ConcealedWorksInspectionRecord_Base_Project] FOREIGN KEY([ProjectId])
|
|||
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_ConcealedWorksInspectionRecord] CHECK CONSTRAINT [FK_JGZL_ConcealedWorksInspectionRecord_Base_Project]
|
|||
|
|
ALTER TABLE [dbo].[JGZL_ConcealedWorksInspectionRecord] WITH CHECK ADD CONSTRAINT [FK_JGZL_ConcealedWorksInspectionRecord_Sys_User] FOREIGN KEY([CompileMan])
|
|||
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_ConcealedWorksInspectionRecord] CHECK CONSTRAINT [FK_JGZL_ConcealedWorksInspectionRecord_Sys_User]
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
|||
|
|
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_ConcealedWorksInspectionRecord', @level2type=N'COLUMN',@level2name=N'ConcealedWorks'
|
|||
|
|
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_ConcealedWorksInspectionRecord', @level2type=N'COLUMN',@level2name=N'DrawingNumber'
|
|||
|
|
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_ConcealedWorksInspectionRecord', @level2type=N'COLUMN',@level2name=N'ConcealedContentAndDiagram'
|
|||
|
|
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_ConcealedWorksInspectionRecord', @level2type=N'COLUMN',@level2name=N'InspectionResults'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord', @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_ConcealedWorksInspectionRecord'
|
|||
|
|
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
--44<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_IndustrialPipelineInstallationQualityCertificate') AND type = N'U')
|
|||
|
|
BEGIN
|
|||
|
|
|
|||
|
|
CREATE TABLE [dbo].[JGZL_IndustrialPipelineInstallationQualityCertificate](
|
|||
|
|
[CertificateId] [nvarchar](50) NOT NULL,
|
|||
|
|
[ProjectId] [nvarchar](50) NULL,
|
|||
|
|
[CertificateCode] [nvarchar](50) NULL,
|
|||
|
|
[EngineeringName] [nvarchar](50) NULL,
|
|||
|
|
[EngineeringCode] [nvarchar](50) NULL,
|
|||
|
|
[DeliveryUnit] [nvarchar](50) NULL,
|
|||
|
|
[DeliveryUnitCode] [nvarchar](50) NULL,
|
|||
|
|
[InstallStartDate] [datetime] NULL,
|
|||
|
|
[InstallEndDate] [datetime] NULL,
|
|||
|
|
[PipelineLevel] [nvarchar](50) NULL,
|
|||
|
|
[PipelineLength] [nvarchar](50) NULL,
|
|||
|
|
[DesignUnit] [nvarchar](50) NULL,
|
|||
|
|
[LosslessTestingAgency] [nvarchar](50) NULL,
|
|||
|
|
[SupervisoryAndInspectionAgency] [nvarchar](50) NULL,
|
|||
|
|
[ConstructionUnit] [nvarchar](50) NULL,
|
|||
|
|
[SpecialEquipmentProductionLicenseCode] [nvarchar](50) NULL,
|
|||
|
|
[Remark] [nvarchar](500) NULL,
|
|||
|
|
[CompileMan] [nvarchar](50) NULL,
|
|||
|
|
[CompileDate] [datetime] NULL,
|
|||
|
|
[Reviewer] [nvarchar](50) NULL,
|
|||
|
|
[RevieweDate] [datetime] NULL,
|
|||
|
|
CONSTRAINT [PK_JGZL_IndustrialPipelineInstallationQualityCertificate] PRIMARY KEY CLUSTERED
|
|||
|
|
(
|
|||
|
|
[CertificateId] 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_IndustrialPipelineInstallationQualityCertificate] WITH CHECK ADD CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationQualityCertificate_Base_Project] FOREIGN KEY([ProjectId])
|
|||
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationQualityCertificate] CHECK CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationQualityCertificate_Base_Project]
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationQualityCertificate] WITH CHECK ADD CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationQualityCertificate_Sys_User] FOREIGN KEY([CompileMan])
|
|||
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationQualityCertificate] CHECK CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationQualityCertificate_Sys_User]
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'CertificateId'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'CertificateCode'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'EngineeringName'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'EngineeringCode'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'DeliveryUnit'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'DeliveryUnitCode'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'InstallStartDate'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'InstallEndDate'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'PipelineLevel'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'PipelineLength'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'DesignUnit'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'LosslessTestingAgency'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'SupervisoryAndInspectionAgency'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>赥λ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'ConstructionUnit'
|
|||
|
|
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_IndustrialPipelineInstallationQualityCertificate', @level2type=N'COLUMN',@level2name=N'SpecialEquipmentProductionLicenseCode'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate', @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_IndustrialPipelineInstallationQualityCertificate'
|
|||
|
|
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
--44<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_IndustrialPipelineInstallationSummary') AND type = N'U')
|
|||
|
|
BEGIN
|
|||
|
|
|
|||
|
|
CREATE TABLE [dbo].[JGZL_IndustrialPipelineInstallationSummary](
|
|||
|
|
[SummaryId] [nvarchar](50) NOT NULL,
|
|||
|
|
[CertificateId] [nvarchar](50) NOT NULL,
|
|||
|
|
[ProjectId] [nvarchar](50) NULL,
|
|||
|
|
[PipelineCode] [nvarchar](50) NULL,
|
|||
|
|
[PipelineLevel] [nvarchar](50) NULL,
|
|||
|
|
[PipelineStartPoint] [nvarchar](50) NULL,
|
|||
|
|
[PipelineEndPoint] [nvarchar](50) NULL,
|
|||
|
|
[DesignPressure] [nvarchar](50) NULL,
|
|||
|
|
[DesignTemperature] [nvarchar](50) NULL,
|
|||
|
|
[Medium] [nvarchar](50) NULL,
|
|||
|
|
[Material] [nvarchar](50) NULL,
|
|||
|
|
[Specifications] [nvarchar](50) NULL,
|
|||
|
|
[Length] [nvarchar](50) NULL,
|
|||
|
|
[LayingMethod] [nvarchar](50) NULL,
|
|||
|
|
[WeldsNum] [nvarchar](50) NULL,
|
|||
|
|
[LosslessRatio] [nvarchar](50) NULL,
|
|||
|
|
[VoltageResistantTestMethod] [nvarchar](50) NULL,
|
|||
|
|
[VoltageResistantTestMedium] [nvarchar](50) NULL,
|
|||
|
|
[VoltageResistantTestPressure] [nvarchar](50) NULL,
|
|||
|
|
[LeakageTestMedium] [nvarchar](50) NULL,
|
|||
|
|
[LeakageTestPressure] [nvarchar](50) NULL,
|
|||
|
|
[CleaningMethod] [nvarchar](50) NULL,
|
|||
|
|
[CorrosionControlMethod] [nvarchar](50) NULL,
|
|||
|
|
[InsulationMethod] [nvarchar](50) NULL,
|
|||
|
|
[Remark] [nvarchar](500) NULL,
|
|||
|
|
[CompileMan] [nvarchar](50) NULL,
|
|||
|
|
[CompileDate] [datetime] NULL,
|
|||
|
|
[Reviewer] [nvarchar](50) NULL,
|
|||
|
|
[RevieweDate] [datetime] NULL,
|
|||
|
|
CONSTRAINT [PK_JGZL_IndustrialPipelineInstallationSummary] PRIMARY KEY CLUSTERED
|
|||
|
|
(
|
|||
|
|
[SummaryId] 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_IndustrialPipelineInstallationSummary] WITH CHECK ADD CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationSummary_Base_Project] FOREIGN KEY([ProjectId])
|
|||
|
|
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationSummary] CHECK CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationSummary_Base_Project]
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationSummary] WITH CHECK ADD CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationSummary_Sys_User] FOREIGN KEY([CompileMan])
|
|||
|
|
REFERENCES [dbo].[Sys_User] ([UserId])
|
|||
|
|
ALTER TABLE [dbo].[JGZL_IndustrialPipelineInstallationSummary] CHECK CONSTRAINT [FK_JGZL_IndustrialPipelineInstallationSummary_Sys_User]
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'SummaryId'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD>֤<EFBFBD><EFBFBD><EFBFBD><EFBFBD>Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'CertificateId'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'PipelineCode'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'PipelineLevel'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'PipelineStartPoint'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'PipelineEndPoint'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'DesignPressure'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'DesignTemperature'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'Medium'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'Material'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'Specifications'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'Length'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD>跽ʽ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'LayingMethod'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'WeldsNum'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD><EFBFBD>ⷽ<EFBFBD><EFBFBD>/<2F><><EFBFBD><EFBFBD>' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'LosslessRatio'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'VoltageResistantTestMethod'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'VoltageResistantTestMedium'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'VoltageResistantTestPressure'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'LeakageTestMedium'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'LeakageTestPressure'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'CleaningMethod'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'CorrosionControlMethod'
|
|||
|
|
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_IndustrialPipelineInstallationSummary', @level2type=N'COLUMN',@level2name=N'InsulationMethod'
|
|||
|
|
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'<EFBFBD><EFBFBD>ע' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_IndustrialPipelineInstallationSummary', @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_IndustrialPipelineInstallationSummary', @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_IndustrialPipelineInstallationSummary', @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_IndustrialPipelineInstallationSummary', @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_IndustrialPipelineInstallationSummary', @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_IndustrialPipelineInstallationSummary'
|
|||
|
|
|
|||
|
|
END
|
|||
|
|
|
|||
|
|
GO
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|
|||
|
|
|