USE [interlock2]
GO

/****** Object:  Table [dbo].[t_interlock]    Script Date: 3/13/2018 7:14:19 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[t_interlock](
    [Id] [int] IDENTITY(1,1) NOT NULL,
    [Department] [nvarchar](50) NULL,
    [interlock_to_bypassed] [nvarchar](50) NULL,
    [justification] [nvarchar](200) NULL,
    [expceted_dt_restoration] [nvarchar](50) NULL,
    [second_layer_info] [nvarchar](100) NULL,
    [req_name] [nvarchar](50) NULL,
    [req_pno] [nvarchar](50) NULL,
    [req_sign] [nvarchar](50) NULL,
    [req_agency] [nvarchar](50) NULL,
    [req_dt] [nvarchar](50) NULL,
    [req_time] [nvarchar](50) NULL,
    [App_name] [nvarchar](50) NULL,
    [app_pno] [nvarchar](50) NULL,
    [app_sign] [nvarchar](50) NULL,
    [app_agency] [nvarchar](50) NULL,
    [app_dt] [nvarchar](50) NULL,
    [app_time] [nvarchar](50) NULL,
    [execution_forcing_done] [nvarchar](300) NULL,
    [execution_line_number] [nvarchar](50) NULL,
    [execution_name] [nvarchar](50) NULL,
    [execution_pno] [nvarchar](50) NULL,
    [execution_sign] [nvarchar](50) NULL,
    [execution_agency] [nvarchar](50) NULL,
    [execution_dt] [nvarchar](50) NULL,
    [execution_time] [nvarchar](50) NULL,
    [interlock_requester] [nvarchar](50) NULL,
    [interlock_name] [nvarchar](50) NULL,
    [interlock_pno] [nvarchar](50) NULL,
    [interlock_sign] [nvarchar](50) NULL,
    [interlock_agency] [nvarchar](50) NULL,
    [interlock_dt] [nvarchar](50) NULL,
    [interlock_time] [nvarchar](50) NULL,
    [int_restoredby_name] [nvarchar](50) NULL,
    [int_restoredby_pno] [nvarchar](50) NULL,
    [int_restoredby_sign] [nvarchar](50) NULL,
    [int_restoredby_dt] [nvarchar](50) NULL,
    [int_restoredby_time] [nvarchar](50) NULL,
    [reviewedby] [nvarchar](50) NULL,
    [reviewed_dt] [nvarchar](50) NULL,
    [reviewed_time] [nvarchar](50) NULL
) ON [PRIMARY]

GO