254 lines
8.2 KiB
Transact-SQL
254 lines
8.2 KiB
Transact-SQL
|
|
CREATE TABLE [dbo].[Transfer_ProjectSetup](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[SN] [nvarchar](50) NULL,
|
|
[PlantNo] [nvarchar](50) NULL,
|
|
[PlantName] [nvarchar](200) NULL,
|
|
[CommissioningSystem] [nvarchar](50) NULL,
|
|
[CommissioningCodeDescription] [nvarchar](50) NULL,
|
|
[SubCommissioningSystem] [nvarchar](50) NULL,
|
|
[SubCommissioningCodeDescription] [nvarchar](50) NULL,
|
|
[DescriptionArea] [nvarchar](50) NULL,
|
|
[TurnoverSystemSequenceNumber] [nvarchar](50) NULL,
|
|
[Description] [nvarchar](50) NULL,
|
|
[TurnoverCode] [nvarchar](50) NULL,
|
|
[TurnoverDescription] [nvarchar](50) NULL,
|
|
[Remark] [nvarchar](200) NULL,
|
|
CONSTRAINT [PK_Transfer_ProjectSetup] 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'ProjectSetup' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transfer_ProjectSetup'
|
|
GO
|
|
|
|
|
|
CREATE TABLE [dbo].[Transfer_Piping](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[PIPINGLINENUMBER] [nvarchar](50) NULL,
|
|
[SYSTEM] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[TestPackage] [nvarchar](50) NULL,
|
|
[TestPackageSTART] [datetime] NULL,
|
|
[TestPackageFINISH] [datetime] NULL,
|
|
[FINALStatus] [nvarchar](50) NULL,
|
|
[PreTestFINISHED] [nvarchar](50) NULL,
|
|
[FinalTestFINISHED] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_Piping] 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'Piping' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transfer_Piping'
|
|
GO
|
|
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[Transfer_StaticEquipment](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[StaticEquipment] [nvarchar](50) NULL,
|
|
[SYSTEM] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[TestPackage] [nvarchar](50) NULL,
|
|
[TestPackageSTART] [datetime] NULL,
|
|
[TestPackageFINISH] [datetime] NULL,
|
|
[MechanicalFINALStatus] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_StaticEquipment] 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'StaticEquipment' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transfer_StaticEquipment'
|
|
GO
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[Transfer_RotatingEquipment](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[RotatingEquipment] [nvarchar](50) NULL,
|
|
[SYSTEM] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[TestPackage] [nvarchar](50) NULL,
|
|
[TestPackageSTART] [datetime] NULL,
|
|
[TestPackageFINISH] [datetime] NULL,
|
|
[MechanicalFINALStatus] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_RotatingEquipment] 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'RotatingEquipment' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Transfer_RotatingEquipment'
|
|
GO
|
|
|
|
|
|
|
|
|
|
|
|
CREATE TABLE [dbo].[Transfer_Instrumentation](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[INSTRUMENTATION] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Instrumentation] 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].[Transfer_Electrical](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[ELECTRICAL] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Electrical] 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].[Transfer_Civil_Structure](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NOT NULL,
|
|
[Civil_Structure] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Civil_Structure] 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].[Transfer_Firefighting](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[Firefighting] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Firefighting] 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].[Transfer_PunchlistFrom](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[Item_No] [nvarchar](50) NULL,
|
|
[Punch_No] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Discipline] [nvarchar](50) NULL,
|
|
[DESCRIPTION] [nvarchar](50) NULL,
|
|
[Identified] [nvarchar](50) NULL,
|
|
[Category] [nvarchar](50) NULL,
|
|
[PUNCH_ITEM_FINISH_DATE] [datetime] NULL,
|
|
[Action_By] [nvarchar](50) NULL,
|
|
[Required_By] [nvarchar](50) NULL,
|
|
[PUNCH_ITEM_STATUS] [nvarchar](50) NULL,
|
|
[Comments] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_PunchlistFrom] 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].[Transfer_HVAC](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[HVAC] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_HVAC] 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].[Transfer_Plumbing](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[Plumbing] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_Plumbing] 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].[Transfer_Telecom](
|
|
[Id] [nvarchar](50) NOT NULL,
|
|
[ProjectId] [nvarchar](50) NULL,
|
|
[Telecom] [nvarchar](50) NULL,
|
|
[SystemName] [nvarchar](50) NULL,
|
|
[Subsystem] [nvarchar](50) NULL,
|
|
[Test_Package] [nvarchar](50) NULL,
|
|
[Test_Package_START] [datetime] NULL,
|
|
[Test_Package_FINISH] [datetime] NULL,
|
|
[FINAL_Status] [nvarchar](50) NULL,
|
|
CONSTRAINT [PK_Transfer_Telecom] 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 |