162 lines
12 KiB
Transact-SQL
162 lines
12 KiB
Transact-SQL
insert into Sys_Menu(MenuId,MenuName,Url,SortIndex,SuperMenu,MenuModule)
|
||
values('729387AD-488D-4451-AEB4-570306747351','交工技术文件目录','JGZL/FileDirectory.aspx',20,'2A84FA58-8B20-48ED-A621-3EC98CF4AD28','3')
|
||
go
|
||
|
||
CREATE TABLE [dbo].[JGZL_FileDirectory](
|
||
[FileDirectoryId] [nvarchar](50) NOT NULL,
|
||
[ProjectId] [nvarchar](50) NULL,
|
||
[SerialNumber] [int] NULL,
|
||
[FileCode] [nvarchar](50) NULL,
|
||
[FileName] [nvarchar](50) NULL,
|
||
[Remark] [nvarchar](500) NULL,
|
||
CONSTRAINT [PK_JGZL_FileDirectory] PRIMARY KEY CLUSTERED
|
||
(
|
||
[FileDirectoryId] ASC
|
||
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
|
||
) ON [PRIMARY]
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_FileDirectory] WITH CHECK ADD CONSTRAINT [FK_JGZL_FileDirectory_Base_Project] FOREIGN KEY([ProjectId])
|
||
REFERENCES [dbo].[Base_Project] ([ProjectId])
|
||
GO
|
||
|
||
ALTER TABLE [dbo].[JGZL_FileDirectory] CHECK CONSTRAINT [FK_JGZL_FileDirectory_Base_Project]
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'主键' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'FileDirectoryId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'项目Id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'ProjectId'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'序号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'SerialNumber'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'FileCode'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'文件名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'FileName'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory', @level2type=N'COLUMN',@level2name=N'Remark'
|
||
GO
|
||
|
||
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'交工技术文件目录' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'JGZL_FileDirectory'
|
||
GO
|
||
|
||
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('11CB25D4-8A45-4F94-A906-379FE53CB118','1','SH/T3503-J1O1A','封面','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('3AE9255C-B4D7-45D3-B5AC-9A4B998F5645','2','SH/T3503-J1O3','交工技术文件目录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('F70599FF-765D-4150-9226-DCFF32A8ABE8','3','SH/T3503-J1O4','交工技术文件说明','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('8B8A6274-5F40-4CFA-948E-FCD51CF0DCEB','4','/','特种设备安装改造维修告知书','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('0ECC93E5-64EF-483F-8D4B-0118332160B9','5','ZDS-T6.38.047.A/0.2020','压力管道安装质量证明书','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('867E68E3-0697-4020-8C52-7131841F8D6D','6','SH/T3503-J1O5A','工程施工开工报告','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('718D2FB4-ED5C-45D0-ADCD-0D0B4877CC60','7','SH/T 3503—J106A','工程中间交接证书','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('75575433-AA35-47FD-BE62-6C1E242B59A3','8','SH/T3503-J1O7A','工程交工验收证书','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('6461674D-AC04-464E-B1A8-9D0B5D84E2F1','9','SH/T3503-J114','工程联络单','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('0F9C899F-EF79-4FEF-9E0B-965E6DCF4C55','10','SH/T3543-G110','施工图核查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('F0390438-2E4C-49F5-A18F-F0709CACBE76','11','/','施工方案','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('909E9746-1022-45C0-AD0F-B34DBB4A08F7','12','SH/T3543-G111','技术交底记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('E3EC63E2-533B-43F6-9DA6-C3D5268F84CD','13','SH/T3503-J115','合格焊工登记表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('3CC8E604-C188-4282-A70D-69A38F925C20','14','/','焊工证复印件','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('CC2A65FE-A193-4177-B267-989A104C56AF','15','SH/T3503-J116','无损检测人员登记表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('CD6A265E-DA00-44A3-AFC2-3281E5ECC96D','16','/','无损检测人员证复印件','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('622E6AA2-3DB2-407E-8548-08AFA11C8A0C','17','/','焊接工艺审批流程','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('0DD6038F-2428-42C3-8B70-B57F91E84718','18','/','焊接工艺（WPS）','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D505908E-BFBA-41AC-B5F8-31EB4AB61425','19','/','焊接工艺评定（PQR）','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('6A2CE156-A3FC-4CC9-ADD8-1F9023FA451D','20','/','单线图','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('BF7ACEB8-01E0-4F8A-B6A9-B8FE8E561260','21','SH/T3503-J415-1','管道焊接工作记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('EAA15FCD-8EAC-41B3-AB8C-182C2C9CC385','22','SH/T3543-G402','管道焊接接头报检/检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('1897D31B-1750-45DB-95BF-7F30355A5012','23','ZDS-T6.38.042.A/0.2020','支管连接焊接接头、角焊接头组对焊接检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D99F19F6-8EB4-4040-B37B-638663C95DC2','24','/','管道焊缝检测委托单','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D22A5460-B0EE-40AE-A727-039163D2EBBD','25','SH/T3543-G416-1','管道焊口射线检测报告','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('B0E910D3-1493-4335-8B8D-188C80366DCE','26','SH/T3543-G420-1','管道焊口渗透检测报告','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D8F1D406-6733-4179-8BFC-E824500712D3','27','SH/T3503-J412-1','管道无损检测结果汇总表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('2EC7F67F-53FE-42B8-87A3-2160D8D5CD42','28','SH/T3503-J413-1','管道无损检测数量统计表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('681C64D0-AB57-4E65-A846-B791211383FB','29','SH/T3503-J406-1','管道系统压力试验条件确认记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('3CB94519-CF12-46E5-8157-E6E59E310E6F','30','SH/T3503-J406-2','管道系统压力试验记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('26AA28AD-EB25-40B1-B743-B3418348E9E8','31','/','热处理委托单','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D1B69F2F-A420-4EB2-8406-24D33BA7363E','32','/','热处理曲线','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('72DAC745-40E9-4E29-A076-D103BD33D481','33','SH/T 3503-J411-1','管道焊接接头热处理报告','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('C73368E4-2376-4640-8A66-2FBCDFE592BB','34','SH/T 3503-J130','硬度检验报告','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D9959623-4252-40A9-A9C3-9FCC21C980F6','35','SH/T3503-J407','管道系统泄露性/真空试验条件确认与试验记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('F6ABB9D4-9159-407E-B4EB-273D9F855836','36','SH/T3503-J408','管道吹扫/清洗检验记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('A24A317B-7623-4D20-91E4-C0C06399350A','37','SH/T3543-G112','工序交接记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('4474035B-4059-473E-866D-1CEAA31E7D35','38','SH/T3543-G122','管道预制施工检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('362A78EF-1A67-453C-B629-9680C3A27CB2','39','SH/T3503-J133','管道安装检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('902C30DA-1657-467B-9D09-1A009AD36FBC','40','SH/T3543-G133','质量控制点检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('0D2D6E44-08CE-415F-BAE4-07247599B9E8','41','SH/T3503-J112','隐蔽工程验收记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('5E457E34-84B2-4D0E-9996-2BF46BD82A60','42','SH/T3503-J118','防腐工程质量验收记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('D40B0E6B-3AA5-41C9-B6FE-400BFCCB7A79','43','SH/T 3503—J119','隔热工程质量验收记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('17F06EC4-4CE0-4D17-9446-17A10B67A884','44','SH/T3503-J416','管道静电接地测试记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('4E69ACB5-5066-4A81-944C-D8306E43BE61','45','SH/T3543-G109','周期检定计量器具清单','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('68608A48-5C5A-48AB-87B4-F5F8618B9BEC','46','SH/T3503-J402','阀门试验确认表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('31567B92-B313-4523-BCDB-185B8EC502E3','47','SH/T3543-G406','阀门检验试验记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('E68065A0-04CC-4D50-B161-A762887B58C1','48','SH/T3543-G411','钢管检查验收记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('8A71A091-99C0-41CD-ABC5-370E09790DBE','49','SH/T3543-G412','管件宏观检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('12660CCE-0E2B-4A25-A569-F476E780F242','50','SH/T3543-G410','管道材料材质标识检查记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('5C44E1E1-B0A7-479D-8240-75522A00B918','51','SH/T3543-G115','焊条烘烤记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('6CF460C3-CDFF-4583-AAAD-A98F1809C64C','52','SH/T3543-G117','焊条发放回收记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('7A728573-6F50-4788-A4EB-B985C7239626','53','SH/T3543-G118','焊丝发放记录','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('60EF50FD-87E7-4259-AC4D-E9E87AD1DE3E','54','SH/T3503-J132-1','材料质量证明文件一览表','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('7D76DA2B-DE25-4CCD-9A09-9750935AEFCE','55','/','材料质量证明文件','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('004A31E9-F6EF-4CD6-8D09-5A003FAAC6CA','56','/','竣工图','')
|
||
insert into JGZL_FileDirectory(FileDirectoryId,SerialNumber,FileCode,FileName,Remark)
|
||
values('6589B1D4-C755-4ED4-94C4-70BD168F6398','57','/','档案移交表','')
|
||
go |