USE [SCADASettings]
GO

/****** Object:  Table [dbo].[PortSettings]    Script Date: 28-06-2026 21:03:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[PortSettings](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Sim7600ComPort] [nvarchar](50) NOT NULL,
	[BaudRate] [int] NOT NULL,
	[SmsEnabled] [bit] NOT NULL,
	[CallEnabled] [bit] NOT NULL,
	[TestMobileNumber] [nvarchar](20) NULL,
	[ModifiedOn] [datetime] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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].[PortSettings] ADD  DEFAULT ((115200)) FOR [BaudRate]
GO

ALTER TABLE [dbo].[PortSettings] ADD  DEFAULT ((1)) FOR [SmsEnabled]
GO

ALTER TABLE [dbo].[PortSettings] ADD  DEFAULT ((1)) FOR [CallEnabled]
GO

ALTER TABLE [dbo].[PortSettings] ADD  DEFAULT (getdate()) FOR [ModifiedOn]
GO


----------------------------------------------------------------------------


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[UserNotification]    Script Date: 28-06-2026 21:04:30 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UserNotification](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[EmpID] [nvarchar](200) NULL,
	[EmpName] [nvarchar](200) NULL,
	[MobilePhone] [nvarchar](200) NULL,
	[Email] [nvarchar](200) NULL,
	[UserRole] [nvarchar](200) NULL,
	[Department] [nvarchar](200) NULL,
	[CreatedAt] [datetime2](7) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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].[UserNotification] ADD  DEFAULT (sysutcdatetime()) FOR [CreatedAt]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetUserTokens]    Script Date: 28-06-2026 21:04:44 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetUserTokens](
	[UserId] [nvarchar](450) NOT NULL,
	[LoginProvider] [nvarchar](450) NOT NULL,
	[Name] [nvarchar](450) NOT NULL,
	[Value] [nvarchar](max) NULL,
 CONSTRAINT [PK_AspNetUserTokens] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[LoginProvider] ASC,
	[Name] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AspNetUserTokens]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetUserTokens] CHECK CONSTRAINT [FK_AspNetUserTokens_AspNetUsers_UserId]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetUsers]    Script Date: 28-06-2026 21:04:57 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetUsers](
	[Id] [nvarchar](450) NOT NULL,
	[AccessFailedCount] [int] NOT NULL,
	[ConcurrencyStamp] [nvarchar](max) NULL,
	[Email] [nvarchar](256) NULL,
	[EmailConfirmed] [bit] NOT NULL,
	[LockoutEnabled] [bit] NOT NULL,
	[LockoutEnd] [datetimeoffset](7) NULL,
	[NormalizedEmail] [nvarchar](256) NULL,
	[NormalizedUserName] [nvarchar](256) NULL,
	[PasswordHash] [nvarchar](max) NULL,
	[PhoneNumber] [nvarchar](max) NULL,
	[PhoneNumberConfirmed] [bit] NOT NULL,
	[SecurityStamp] [nvarchar](max) NULL,
	[TwoFactorEnabled] [bit] NOT NULL,
	[UserName] [nvarchar](256) NULL,
 CONSTRAINT [PK_AspNetUsers] PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetUserRoles]    Script Date: 28-06-2026 21:05:11 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetUserRoles](
	[UserId] [nvarchar](450) NOT NULL,
	[RoleId] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_AspNetUserRoles] PRIMARY KEY CLUSTERED 
(
	[UserId] ASC,
	[RoleId] 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].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[AspNetRoles] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetRoles_RoleId]
GO

ALTER TABLE [dbo].[AspNetUserRoles]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetUserRoles] CHECK CONSTRAINT [FK_AspNetUserRoles_AspNetUsers_UserId]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetUserLogins]    Script Date: 28-06-2026 21:05:25 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetUserLogins](
	[LoginProvider] [nvarchar](450) NOT NULL,
	[ProviderKey] [nvarchar](450) NOT NULL,
	[ProviderDisplayName] [nvarchar](max) NULL,
	[UserId] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_AspNetUserLogins] PRIMARY KEY CLUSTERED 
(
	[LoginProvider] ASC,
	[ProviderKey] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AspNetUserLogins]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetUserLogins] CHECK CONSTRAINT [FK_AspNetUserLogins_AspNetUsers_UserId]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetUserClaims]    Script Date: 28-06-2026 21:05:37 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetUserClaims](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ClaimType] [nvarchar](max) NULL,
	[ClaimValue] [nvarchar](max) NULL,
	[UserId] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_AspNetUserClaims] PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AspNetUserClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId] FOREIGN KEY([UserId])
REFERENCES [dbo].[AspNetUsers] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetUserClaims] CHECK CONSTRAINT [FK_AspNetUserClaims_AspNetUsers_UserId]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetRoles]    Script Date: 28-06-2026 21:05:50 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetRoles](
	[Id] [nvarchar](450) NOT NULL,
	[ConcurrencyStamp] [nvarchar](max) NULL,
	[Name] [nvarchar](256) NULL,
	[NormalizedName] [nvarchar](256) NULL,
 CONSTRAINT [PK_AspNetRoles] PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[AspNetRoleClaims]    Script Date: 28-06-2026 21:06:12 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AspNetRoleClaims](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ClaimType] [nvarchar](max) NULL,
	[ClaimValue] [nvarchar](max) NULL,
	[RoleId] [nvarchar](450) NOT NULL,
 CONSTRAINT [PK_AspNetRoleClaims] PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AspNetRoleClaims]  WITH CHECK ADD  CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId] FOREIGN KEY([RoleId])
REFERENCES [dbo].[AspNetRoles] ([Id])
ON DELETE CASCADE
GO

ALTER TABLE [dbo].[AspNetRoleClaims] CHECK CONSTRAINT [FK_AspNetRoleClaims_AspNetRoles_RoleId]
GO


USE [UserNotifications]
GO

/****** Object:  Table [dbo].[__EFMigrationsHistory]    Script Date: 28-06-2026 21:06:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[__EFMigrationsHistory](
	[MigrationId] [nvarchar](150) NOT NULL,
	[ProductVersion] [nvarchar](32) NOT NULL,
 CONSTRAINT [PK___EFMigrationsHistory] PRIMARY KEY CLUSTERED 
(
	[MigrationId] 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


-------------------------------------------------------------------------------------












USE [AOL_AuditActions]
GO

/****** Object:  Table [dbo].[AuditActions]    Script Date: 6/10/2026 1:38:18 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AuditActions](
	[Id] [int] NOT NULL,
	[Organization] [nvarchar](200) NULL,
	[Site] [nvarchar](50) NULL,
	[ActionDate] [date] NULL,
	[ResponsiblePerson] [nvarchar](150) NULL,
	[ResponsibleSSO] [nvarchar](50) NULL,
	[ActionTitle] [nvarchar](300) NULL,
	[AuditType] [nvarchar](100) NULL,
	[AuditTypeGroup] [nvarchar](150) NULL,
	[ActionType] [nvarchar](100) NULL,
	[ActionCategory] [nvarchar](100) NULL,
	[ActionCategoryGroup] [nvarchar](150) NULL,
	[ContractorName] [nvarchar](200) NULL,
	[ObservationType] [nvarchar](100) NULL,
	[PotentialIncidentModality] [nvarchar](200) NULL,
	[ImmediateCause] [nvarchar](300) NULL,
	[NatureOfRisk] [nvarchar](200) NULL,
	[Specifics] [nvarchar](max) NULL,
	[WorldRegion] [nvarchar](100) NULL,
	[Country] [nvarchar](100) NULL,
	[SubSite] [nvarchar](100) NULL,
	[Zone] [nvarchar](100) NULL,
	[Area] [nvarchar](100) NULL,
	[RiskCategory] [nvarchar](100) NULL,
	[ClosureCategory] [nvarchar](100) NULL,
	[Observation] [nvarchar](max) NULL,
	[Action] [nvarchar](max) NULL,
	[MultipleEmailCC] [nvarchar](max) NULL,
	[Auditor] [nvarchar](150) NULL,
	[ContactPhone] [nvarchar](50) NULL,
	[DateClosed] [date] NULL,
	[WorkInProgressNotes] [nvarchar](max) NULL,
	[ClosureComment] [nvarchar](max) NULL,
	[ClosedBy] [nvarchar](150) NULL,
	[ActionStatus] [nvarchar](100) NULL,
	[ClosureDueDate] [date] NULL,
	[OriginalClosureDueDate] [date] NULL,
	[DueDateRequestApprover] [nvarchar](150) NULL,
	[ClosureVerificationStatus] [nvarchar](100) NULL,
	[ClosureVerificationBy] [nvarchar](150) NULL,
	[ClosureVerifiedDate] [date] NULL,
	[ClosureVerificationComment] [nvarchar](max) NULL,
	[CAPARequired] [nvarchar](50) NULL,
	[InvestigationDetails] [nvarchar](max) NULL,
	[RootCause] [nvarchar](max) NULL,
	[EffectivityDate] [date] NULL,
	[EffectivityInformation] [nvarchar](max) NULL,
	[Reference] [nvarchar](200) NULL,
	[ReferenceId] [nvarchar](100) NULL,
	[UpdateHistory] [nvarchar](max) NULL,
	[DaysOpen] [int] NULL,
	[DaysPastClosureDue] [int] NULL,
	[CreatedOn] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AuditActions] ADD  DEFAULT (getdate()) FOR [CreatedOn]
GO

-----------

USE [AOL_AuditActions]
GO

/****** Object:  Table [dbo].[Staging_AuditActions]    Script Date: 6/10/2026 1:39:30 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Staging_AuditActions](
	[Id] [int] NOT NULL,
	[Organization] [nvarchar](200) NULL,
	[Site] [nvarchar](50) NULL,
	[ActionDate] [date] NULL,
	[ResponsiblePerson] [nvarchar](150) NULL,
	[ResponsibleSSO] [nvarchar](50) NULL,
	[ActionTitle] [nvarchar](300) NULL,
	[AuditType] [nvarchar](100) NULL,
	[AuditTypeGroup] [nvarchar](150) NULL,
	[ActionType] [nvarchar](100) NULL,
	[ActionCategory] [nvarchar](100) NULL,
	[ActionCategoryGroup] [nvarchar](150) NULL,
	[ContractorName] [nvarchar](200) NULL,
	[ObservationType] [nvarchar](100) NULL,
	[PotentialIncidentModality] [nvarchar](200) NULL,
	[ImmediateCause] [nvarchar](300) NULL,
	[NatureOfRisk] [nvarchar](200) NULL,
	[Specifics] [nvarchar](max) NULL,
	[WorldRegion] [nvarchar](100) NULL,
	[Country] [nvarchar](100) NULL,
	[SubSite] [nvarchar](100) NULL,
	[Zone] [nvarchar](100) NULL,
	[Area] [nvarchar](100) NULL,
	[RiskCategory] [nvarchar](100) NULL,
	[ClosureCategory] [nvarchar](100) NULL,
	[Observation] [nvarchar](max) NULL,
	[Action] [nvarchar](max) NULL,
	[MultipleEmailCC] [nvarchar](max) NULL,
	[Auditor] [nvarchar](150) NULL,
	[ContactPhone] [nvarchar](50) NULL,
	[DateClosed] [date] NULL,
	[WorkInProgressNotes] [nvarchar](max) NULL,
	[ClosureComment] [nvarchar](max) NULL,
	[ClosedBy] [nvarchar](150) NULL,
	[ActionStatus] [nvarchar](100) NULL,
	[ClosureDueDate] [date] NULL,
	[OriginalClosureDueDate] [date] NULL,
	[DueDateRequestApprover] [nvarchar](150) NULL,
	[ClosureVerificationStatus] [nvarchar](100) NULL,
	[ClosureVerificationBy] [nvarchar](150) NULL,
	[ClosureVerifiedDate] [date] NULL,
	[ClosureVerificationComment] [nvarchar](max) NULL,
	[CAPARequired] [nvarchar](50) NULL,
	[InvestigationDetails] [nvarchar](max) NULL,
	[RootCause] [nvarchar](max) NULL,
	[EffectivityDate] [date] NULL,
	[EffectivityInformation] [nvarchar](max) NULL,
	[Reference] [nvarchar](200) NULL,
	[ReferenceId] [nvarchar](100) NULL,
	[UpdateHistory] [nvarchar](max) NULL,
	[DaysOpen] [int] NULL,
	[DaysPastClosureDue] [int] NULL,
	[CreatedOn] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


---------------------------------------------------------------------------------

USE [AOL_Azure_User]
GO

/****** Object:  Table [dbo].[AzureAdUsers]    Script Date: 6/10/2026 1:40:29 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AzureAdUsers](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[DisplayName] [nvarchar](200) NULL,
	[Email] [nvarchar](200) NULL,
	[UserPrincipalName] [nvarchar](200) NULL,
	[MobilePhone] [nvarchar](50) NULL,
	[Department] [nvarchar](100) NULL,
	[SyncedOn] [datetime2](7) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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],
UNIQUE NONCLUSTERED 
(
	[UserPrincipalName] 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].[AzureAdUsers] ADD  DEFAULT (sysutcdatetime()) FOR [SyncedOn]
GO


-------------------------------------------------------------------------------------

USE [AOL_CCF]
GO

/****** Object:  Table [dbo].[change_control_actions]    Script Date: 6/10/2026 1:41:52 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[change_control_actions](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ccf_number] [varchar](50) NULL,
	[action_description] [text] NULL,
	[responsible_department] [varchar](100) NULL,
	[responsible_person] [varchar](100) NULL,
	[target_date] [date] NULL,
	[completion_date] [date] NULL,
	[AttachmentFileName] [nvarchar](255) NULL,
	[AttachmentFile] [varbinary](max) NULL,
	[action_status] [varchar](50) NULL,
	[accepted_by] [varchar](100) NULL,
	[acceptance_status] [varchar](50) NULL,
	[acceptance_date] [date] NULL,
	[acceptance_remarks] [text] NULL,
	[approver_name] [varchar](100) NULL,
	[approval_role] [varchar](50) NULL,
	[approval_status] [varchar](50) NULL,
	[approval_comments] [text] NULL,
	[approval_date] [date] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_CCF]
GO

/****** Object:  Table [dbo].[change_control_master]    Script Date: 6/10/2026 1:42:20 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[change_control_master](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ccf_number] [varchar](50) NULL,
	[site] [varchar](100) NULL,
	[initiation_department] [varchar](50) NULL,
	[project_name] [varchar](100) NULL,
	[reference_number] [varchar](100) NULL,
	[document_title] [varchar](255) NULL,
	[change_related_to] [varchar](200) NULL,
	[change_category] [varchar](50) NULL,
	[existing_procedure] [text] NULL,
	[proposed_change] [text] NULL,
	[change_reason] [text] NULL,
	[linked_deviation_capa] [varchar](100) NULL,
	[initiator_name] [varchar](100) NULL,
	[initiator_sign_date] [date] NULL,
	[initiator_impact_assessment] [text] NULL,
	[dept_head_assigned_to] [varchar](100) NULL,
	[dept_head_review_status] [varchar](50) NULL,
	[dept_head_reviewed_by] [varchar](100) NULL,
	[dept_head_review_datetime] [varchar](25) NULL,
	[dept_head_review_comments] [text] NULL,
	[dqa_assigned_to] [varchar](100) NULL,
	[dqa_review_status] [varchar](50) NULL,
	[dqa_reviewed_by] [varchar](100) NULL,
	[dqa_review_datetime] [varchar](25) NULL,
	[dqa_review_comments] [text] NULL,
	[change_implementable] [varchar](20) NULL,
	[cft_required] [varchar](10) NULL,
	[cft_assigned_to] [varchar](255) NULL,
	[cft_review_status] [varchar](50) NULL,
	[cft_reviewed_by] [varchar](255) NULL,
	[cft_review_datetime] [varchar](25) NULL,
	[cft_decision] [varchar](50) NULL,
	[cft_remarks] [text] NULL,
	[change_level] [varchar](50) NULL,
	[closure_timeline] [varchar](50) NULL,
	[post_implementation_review] [text] NULL,
	[extension1_required] [varchar](10) NULL,
	[extension1_justification] [text] NULL,
	[extension1_target_date] [date] NULL,
	[extension1_approved_by] [varchar](100) NULL,
	[extension1_approval_datetime] [varchar](25) NULL,
	[extension2_required] [varchar](10) NULL,
	[extension2_justification] [text] NULL,
	[extension2_target_date] [date] NULL,
	[extension2_approved_by] [varchar](100) NULL,
	[extension2_approval_datetime] [varchar](25) NULL,
	[extension3_required] [varchar](10) NULL,
	[extension3_justification] [text] NULL,
	[extension3_target_date] [date] NULL,
	[extension3_approved_by] [varchar](100) NULL,
	[extension3_approval_datetime] [varchar](25) NULL,
	[final_approval_assigned_to] [varchar](100) NULL,
	[final_approval_status] [varchar](50) NULL,
	[final_approval_reviewed_by] [varchar](100) NULL,
	[final_approval_review_datetime] [varchar](25) NULL,
	[final_approval_comments] [text] NULL,
	[initiator_closing_comments] [text] NULL,
	[documents_updated] [varchar](10) NULL,
	[training_completed] [varchar](10) NULL,
	[closed_within_timeline] [varchar](10) NULL,
	[delay_justification] [text] NULL,
	[final_dqa_comments] [text] NULL,
	[final_conclusion] [varchar](50) NULL,
	[closure_date] [date] NULL,
	[workflow_status] [varchar](50) NULL,
	[created_date] [date] NULL,
	[last_updated_date] [date] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


--------------------------------------------------------------------------------

USE [AOL_Certificate]
GO

/****** Object:  Table [dbo].[Certificates]    Script Date: 6/10/2026 1:43:11 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Certificates](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[certificate_id] [nvarchar](255) NOT NULL,
	[equipment_id] [nvarchar](255) NULL,
	[instrument_id] [nvarchar](255) NULL,
	[title] [nvarchar](255) NOT NULL,
	[document_type] [nvarchar](100) NULL,
	[document] [varbinary](max) NULL,
	[document_name] [nvarchar](255) NULL,
	[status] [nvarchar](50) NULL,
	[uploaded_by] [nvarchar](100) NULL,
	[uploaded_at] [datetime] NULL,
	[remarks] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


----------------------------------------------------------------------------

USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[Daily_Checklist_Detector]    Script Date: 6/10/2026 1:44:13 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Daily_Checklist_Detector](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](50) NOT NULL,
	[Checklist_Date] [date] NOT NULL,
	[Detector_Type] [varchar](100) NULL,
	[ID_Number] [varchar](50) NOT NULL,
	[Location] [varchar](100) NULL,
	[O2_Working_Status] [varchar](100) NULL,
	[O2_Reading] [decimal](5, 2) NULL,
	[LEL_Working_Status] [varchar](100) NULL,
	[LEL_Reading] [decimal](5, 2) NULL,
	[CO2_Working_Status] [varchar](100) NULL,
	[CO2_Reading] [decimal](5, 2) NULL,
	[H2_Working_Status] [varchar](100) NULL,
	[H2_Reading] [decimal](5, 2) NULL,
	[Status] [varchar](50) NULL,
	[Remark] [varchar](max) NULL,
	[Done_By_Name] [varchar](100) NULL,
	[Done_By_Timestamp] [datetime] NULL,
	[Commends] [varchar](max) NULL,
	[Reviewed_By_Name] [varchar](100) NULL,
	[Reviewed_By_Timestamp] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[Daily_Checklist_Refrigerator_Freezer_Incubator]    Script Date: 6/10/2026 1:44:49 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Daily_Checklist_Refrigerator_Freezer_Incubator](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](50) NOT NULL,
	[Equipment_Name] [varchar](50) NOT NULL,
	[Equipment_ID] [varchar](50) NULL,
	[Equipment_Condition] [varchar](50) NULL,
	[Checklist_Date] [date] NOT NULL,
	[Frequency_Interval] [varchar](50) NOT NULL,
	[Time_Slot] [varchar](50) NOT NULL,
	[Room_Temperature] [decimal](5, 2) NULL,
	[Temp_Reading] [decimal](6, 2) NULL,
	[CO2_Reading] [decimal](5, 2) NULL,
	[Remark] [varchar](max) NULL,
	[Done_By_Name] [varchar](100) NULL,
	[Done_By_Timestamp] [datetime] NULL,
	[Reviewed_By_Name] [varchar](100) NULL,
	[Reviewed_By_Timestamp] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[DieselTankMonitoring]    Script Date: 6/10/2026 1:45:27 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[DieselTankMonitoring](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](50) NOT NULL,
	[Tank_ID] [varchar](50) NOT NULL,
	[Tank_Capacity] [decimal](10, 2) NOT NULL,
	[Log_Date] [date] NOT NULL,
	[Time_Slot] [varchar](50) NOT NULL,
	[Log_Time] [time](7) NOT NULL,
	[Tank_Level] [decimal](10, 2) NOT NULL,
	[Tank_Level_Within_Limit] [varchar](20) NOT NULL,
	[Leaks_Identified] [varchar](20) NOT NULL,
	[Abnormality_Identified] [varchar](20) NOT NULL,
	[Remark] [varchar](max) NULL,
	[Done_By] [varchar](100) NULL,
	[Done_Date_Time] [datetime] NULL,
	[Reviewed_By] [varchar](100) NULL,
	[Reviewed_Date_Time] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[Feeder_Daily_Checklist]    Script Date: 6/10/2026 1:46:00 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Feeder_Daily_Checklist](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](150) NULL,
	[Checklist_Date] [date] NOT NULL,
	[Time_Slot] [varchar](50) NOT NULL,
	[Panel_Name] [varchar](150) NULL,
	[Opening_Reading] [decimal](12, 2) NULL,
	[Closing_Reading] [decimal](12, 2) NULL,
	[Total_Units] [decimal](12, 2) NULL,
	[Remark] [varchar](max) NULL,
	[Done_By] [varchar](100) NULL,
	[Done_DateTime] [datetime] NULL,
	[Reviewed_By] [varchar](100) NULL,
	[Reviewed_DateTime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[RoomMonitoringLog]    Script Date: 6/10/2026 1:46:36 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[RoomMonitoringLog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](50) NOT NULL,
	[Log_Date] [date] NOT NULL,
	[Reading_Type] [varchar](50) NULL,
	[Location] [varchar](100) NULL,
	[Room_Name] [varchar](100) NULL,
	[Frequency_Interval] [varchar](10) NULL,
	[Time_Slot] [varchar](50) NOT NULL,
	[Reading_Time] [time](7) NULL,
	[Status] [varchar](50) NULL,
	[Room_Temp] [decimal](5, 2) NULL,
	[Avg_Temp] [decimal](5, 2) NULL,
	[Compressed_Air_Pressure] [decimal](6, 2) NULL,
	[Nitrogen_Pressure] [decimal](6, 2) NULL,
	[Remarks] [varchar](max) NULL,
	[Done_By] [varchar](100) NULL,
	[Done_Date] [datetime] NULL,
	[Reviewed_By] [varchar](100) NULL,
	[Reviewed_Date] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist]
GO

/****** Object:  Table [dbo].[Static_Switch_Checklist]    Script Date: 6/10/2026 1:47:10 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Static_Switch_Checklist](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Checklist_ID] [varchar](50) NOT NULL,
	[Checklist_Date] [date] NOT NULL,
	[Frequency] [varchar](20) NULL,
	[Time_Slot] [varchar](50) NOT NULL,
	[Equipment_Name] [varchar](100) NULL,
	[Location] [varchar](100) NULL,
	[Input_1_Status] [varchar](20) NULL,
	[Input_2_Status] [varchar](20) NULL,
	[Output_Source] [varchar](20) NULL,
	[Remark] [varchar](max) NULL,
	[Technician_Name] [varchar](100) NULL,
	[Technician_DateTime] [datetime] NULL,
	[Reviewed_Name] [varchar](100) NULL,
	[Reviewed_DateTime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


----------------------------------------------------------------------------------------------

USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[Air_Compressor_Checklist]    Script Date: 6/10/2026 1:48:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Air_Compressor_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[checklist_number] [varchar](50) NULL,
	[checklist_type] [varchar](50) NULL,
	[checklist_date] [date] NOT NULL,
	[compressor_id] [varchar](50) NULL,
	[main_supply] [varchar](10) NULL,
	[pressure_psi] [decimal](6, 2) NULL,
	[coolant_pump_condition] [varchar](50) NULL,
	[condenser_fan_condition] [varchar](50) NULL,
	[compressor_motor_condition] [varchar](50) NULL,
	[oil_leakage] [varchar](10) NULL,
	[coolant_leakage] [varchar](10) NULL,
	[air_leakage] [varchar](10) NULL,
	[drain_water_system] [varchar](10) NULL,
	[auto_drain_test] [varchar](50) NULL,
	[drain_u_trap] [varchar](10) NULL,
	[air_dryer_set_temp] [decimal](5, 2) NULL,
	[running_hours] [varchar](50) NULL,
	[equipment_name] [varchar](150) NULL,
	[equipment_id] [varchar](50) NULL,
	[frequency_interval] [varchar](50) NULL,
	[working_condition] [varchar](20) NULL,
	[pressure_range] [decimal](6, 2) NULL,
	[air_dryer_current_temp] [decimal](5, 2) NULL,
	[remark] [nvarchar](max) NULL,
	[aproval_status] [nvarchar](max) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[DG_Daily_Checklist]    Script Date: 6/10/2026 1:48:37 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[DG_Daily_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[checklist_number] [varchar](50) NULL,
	[checklist_type] [varchar](50) NULL,
	[checklist_date] [date] NOT NULL,
	[dg_id] [varchar](50) NULL,
	[battery_vtg_b1] [decimal](6, 2) NULL,
	[battery_vtg_b2] [decimal](6, 2) NULL,
	[engine_oil_level] [varchar](20) NULL,
	[diesel_level_liters] [decimal](10, 2) NULL,
	[control_panel_mode] [varchar](20) NULL,
	[panel_manual_mode] [varchar](10) NULL,
	[leakage_status] [varchar](50) NULL,
	[battery_charger_status] [varchar](50) NULL,
	[filter_condition] [varchar](50) NULL,
	[coolant_level] [varchar](50) NULL,
	[engine_condition] [varchar](50) NULL,
	[panel_auto_mode] [varchar](10) NULL,
	[equipment_name] [varchar](100) NULL,
	[equipment_id] [varchar](50) NULL,
	[capacity] [decimal](10, 2) NULL,
	[frequency_interval] [varchar](50) NULL,
	[working_condition] [varchar](20) NULL,
	[remark] [nvarchar](max) NULL,
	[approval_status] [nvarchar](max) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[Fire_Alarm_System_Checklist]    Script Date: 6/10/2026 1:49:08 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Fire_Alarm_System_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[location] [varchar](150) NULL,
	[checklist_date] [date] NOT NULL,
	[checklist_time] [time](7) NOT NULL,
	[working_status] [varchar](20) NULL,
	[device_loop_fault] [varchar](10) NULL,
	[remark] [nvarchar](max) NULL,
	[approval_status] [varchar](20) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[Fire_Hydrant_Pump_Critical_Log]    Script Date: 6/10/2026 1:49:40 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Fire_Hydrant_Pump_Critical_Log](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[log_date] [date] NOT NULL,
	[equipment_name] [varchar](100) NULL,
	[id_number] [varchar](50) NULL,
	[pressure] [decimal](6, 2) NULL,
	[frequency_interval] [varchar](50) NULL,
	[working_condition] [varchar](20) NULL,
	[remark] [nvarchar](max) NULL,
	[approval_status] [varchar](20) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[Fire_Hydrant_System_Checklist]    Script Date: 6/10/2026 1:50:15 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Fire_Hydrant_System_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[checklist_date] [date] NOT NULL,
	[fire_hydrant_id] [varchar](50) NULL,
	[battery_condition] [varchar](50) NULL,
	[engine_oil_level] [varchar](50) NULL,
	[diesel_level] [varchar](50) NULL,
	[control_panel_mode] [varchar](20) NULL,
	[panel_manual_mode] [varchar](10) NULL,
	[leakage_status] [varchar](50) NULL,
	[engine_condition] [varchar](50) NULL,
	[water_sump_level] [varchar](50) NULL,
	[coolant_level] [varchar](50) NULL,
	[panel_auto_mode] [varchar](10) NULL,
	[remark] [nvarchar](max) NULL,
	[approval_status] [varchar](20) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[LN2_Tank_Daily_Checklist]    Script Date: 6/10/2026 1:50:50 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[LN2_Tank_Daily_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[location] [varchar](150) NULL,
	[checklist_item] [varchar](200) NULL,
	[checklist_date] [date] NOT NULL,
	[checklist_time] [time](7) NOT NULL,
	[working_status] [varchar](20) NULL,
	[tank_pressure] [decimal](6, 2) NULL,
	[storage_level] [decimal](6, 2) NULL,
	[remark] [nvarchar](max) NULL,
	[approval_status] [varchar](20) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Checklist2]
GO

/****** Object:  Table [dbo].[UPS_Daily_Checklist]    Script Date: 6/10/2026 1:51:21 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[UPS_Daily_Checklist](
	[log_id] [int] IDENTITY(1,1) NOT NULL,
	[ups_type] [varchar](50) NULL,
	[location] [varchar](100) NULL,
	[id_number] [varchar](50) NULL,
	[capacity] [decimal](10, 2) NULL,
	[equipment_condition] [varchar](20) NULL,
	[checklist_date] [date] NOT NULL,
	[frequency] [varchar](20) NULL,
	[reading_time] [time](7) NOT NULL,
	[input_rn] [decimal](6, 2) NULL,
	[input_yn] [decimal](6, 2) NULL,
	[input_bn] [decimal](6, 2) NULL,
	[output_rn] [decimal](6, 2) NULL,
	[output_yn] [decimal](6, 2) NULL,
	[output_bn] [decimal](6, 2) NULL,
	[output_current_r] [decimal](6, 2) NULL,
	[output_current_y] [decimal](6, 2) NULL,
	[output_current_b] [decimal](6, 2) NULL,
	[output_load_r] [decimal](6, 2) NULL,
	[output_load_y] [decimal](6, 2) NULL,
	[output_load_b] [decimal](6, 2) NULL,
	[avg_output_load] [decimal](6, 2) NULL,
	[load_percentage] [decimal](6, 2) NULL,
	[battery_voltage] [decimal](6, 2) NULL,
	[frequency_hz] [decimal](6, 2) NULL,
	[temperature] [decimal](5, 2) NULL,
	[remark] [nvarchar](max) NULL,
	[approve_status] [nvarchar](max) NULL,
	[done_by] [varchar](100) NULL,
	[done_datetime] [datetime] NULL,
	[reviewed_by] [varchar](100) NULL,
	[reviewed_datetime] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[log_id] 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] TEXTIMAGE_ON [PRIMARY]
GO


-------------------------------------------------------------------------------

USE [AOL_Checklist3]
GO

/****** Object:  Table [dbo].[Utility_Daily_Checklist]    Script Date: 6/10/2026 1:52:15 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Utility_Daily_Checklist](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[EntryDate] [date] NOT NULL,
	[EntryDateTime] [datetime] NOT NULL,
	[ShiftName] [varchar](50) NULL,
	[SectionName] [varchar](200) NOT NULL,
	[EquipmentName] [varchar](300) NOT NULL,
	[Parameter1] [varchar](150) NULL,
	[Value1] [varchar](150) NULL,
	[Parameter2] [varchar](150) NULL,
	[Value2] [varchar](150) NULL,
	[Parameter3] [varchar](150) NULL,
	[Value3] [varchar](150) NULL,
	[Status] [varchar](50) NULL,
	[Remarks] [varchar](500) NULL,
	[CheckedBy] [varchar](100) NULL,
	[ApprovedBy] [varchar](100) NULL,
	[CreatedDate] [datetime] NOT NULL,
	[ModifiedDate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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].[Utility_Daily_Checklist] ADD  DEFAULT (CONVERT([date],getdate())) FOR [EntryDate]
GO

ALTER TABLE [dbo].[Utility_Daily_Checklist] ADD  DEFAULT (getdate()) FOR [EntryDateTime]
GO

ALTER TABLE [dbo].[Utility_Daily_Checklist] ADD  DEFAULT (getdate()) FOR [CreatedDate]
GO


----------------------------------------------------------------------

USE [AOL_Deviation]
GO

/****** Object:  Table [dbo].[Deviation_Actions]    Script Date: 6/10/2026 1:53:05 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Deviation_Actions](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Deviation_Number] [varchar](50) NOT NULL,
	[Action_Description] [nvarchar](max) NOT NULL,
	[Responsible_Department] [varchar](100) NULL,
	[Responsible_Person] [varchar](100) NULL,
	[Target_Date] [date] NULL,
	[Completion_Date] [date] NULL,
	[Action_Status] [varchar](50) NULL,
	[Accepted_By] [varchar](100) NULL,
	[Acceptance_Status] [varchar](50) NULL,
	[Acceptance_Date] [date] NULL,
	[Acceptance_Remarks] [nvarchar](max) NULL,
	[Approver_Name] [varchar](100) NULL,
	[Approval_Role] [varchar](50) NULL,
	[Approval_Status] [varchar](50) NULL,
	[Approval_Comments] [nvarchar](max) NULL,
	[Approval_Date] [date] NULL,
	[AttachmentFileName] [nvarchar](255) NULL,
	[AttachmentFile] [varbinary](max) NULL,
	[Created_Date] [datetime2](7) NOT NULL,
	[Last_Updated_Date] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Deviation_Actions] ADD  DEFAULT (getdate()) FOR [Created_Date]
GO


USE [AOL_Deviation]
GO

/****** Object:  Table [dbo].[Deviation_Master_Table]    Script Date: 6/10/2026 1:53:33 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Deviation_Master_Table](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Deviation_Number] [varchar](50) NOT NULL,
	[Site] [varchar](100) NULL,
	[Deviation_Occurred_Date] [date] NULL,
	[Deviation_Identified_Date] [date] NULL,
	[Initiator_Department] [varchar](100) NULL,
	[Change_Related_To] [varchar](200) NULL,
	[Change_Related_Remark] [nvarchar](max) NULL,
	[Reference_Type] [varchar](100) NULL,
	[Reference_Remark] [nvarchar](max) NULL,
	[Deviation_Description] [nvarchar](max) NULL,
	[Immediate_Action_Taken] [nvarchar](max) NULL,
	[Initiated_By] [varchar](100) NULL,
	[Initiated_Sign_Date] [date] NULL,
	[Preliminary_Assigned_To] [varchar](100) NULL,
	[Preliminary_Review_Status] [varchar](50) NULL,
	[Preliminary_Reviewed_By] [varchar](100) NULL,
	[Preliminary_Review_DateTime] [datetime2](7) NULL,
	[Review_Document_Details] [nvarchar](max) NULL,
	[Equipment_Impact] [varchar](10) NULL,
	[Equipment_Impact_Remark] [nvarchar](max) NULL,
	[Calibration_Maintenance_Check] [varchar](10) NULL,
	[Calibration_Remark] [nvarchar](max) NULL,
	[Document_Impact] [varchar](10) NULL,
	[Document_Impact_Remark] [nvarchar](max) NULL,
	[Additional_Testing_Required] [varchar](10) NULL,
	[Additional_Testing_Remark] [nvarchar](max) NULL,
	[Validation_Impact] [varchar](10) NULL,
	[Validation_Impact_Details] [nvarchar](max) NULL,
	[Others_Remark] [nvarchar](max) NULL,
	[Root_Cause_Initial] [nvarchar](max) NULL,
	[Impact_Assessment_By] [varchar](100) NULL,
	[Impact_Assessment_Sign_Date] [date] NULL,
	[HOD_Assigned_To] [varchar](100) NULL,
	[HOD_Review_Status] [varchar](50) NULL,
	[HOD_Reviewed_By] [varchar](100) NULL,
	[HOD_Review_DateTime] [datetime2](7) NULL,
	[HOD_Comments] [nvarchar](max) NULL,
	[DQA_Assigned_To] [varchar](100) NULL,
	[DQA_Review_Status] [varchar](50) NULL,
	[DQA_Reviewed_By] [varchar](100) NULL,
	[DQA_Review_DateTime] [datetime2](7) NULL,
	[Similar_Deviation] [varchar](10) NULL,
	[Similar_Deviation_Reference] [nvarchar](max) NULL,
	[DQA_Comments] [nvarchar](max) NULL,
	[Initial_Categorization] [varchar](50) NULL,
	[Investigation_Required] [varchar](10) NULL,
	[DQA_Head_Name] [varchar](100) NULL,
	[DQA_Head_Sign_Date] [date] NULL,
	[Root_Cause_Final] [nvarchar](max) NULL,
	[Risk_Impact_Assessment] [nvarchar](max) NULL,
	[Initiator_HOD_Name] [varchar](100) NULL,
	[Initiator_HOD_Sign_Date] [date] NULL,
	[CFT_Required] [varchar](10) NULL,
	[CFT_Assigned_To] [varchar](255) NULL,
	[CFT_Review_Status] [varchar](50) NULL,
	[CFT_Reviewed_By] [varchar](255) NULL,
	[CFT_Review_DateTime] [datetime2](7) NULL,
	[CFT_Comments] [nvarchar](max) NULL,
	[CAPA_Required] [varchar](10) NULL,
	[CAPA_Review_Status] [varchar](50) NULL,
	[CAPA_Reviewed_By] [varchar](100) NULL,
	[CAPA_Review_DateTime] [datetime2](7) NULL,
	[Investigation_Adequate] [varchar](10) NULL,
	[Further_Investigation_Details] [nvarchar](max) NULL,
	[Further_Investigation_Review] [nvarchar](max) NULL,
	[Final_Categorization] [varchar](50) NULL,
	[Final_DQA_Comments] [nvarchar](max) NULL,
	[Investigation_CAPA_Approved_By] [varchar](100) NULL,
	[Investigation_CAPA_Approval_Date] [date] NULL,
	[Extension1_Required] [varchar](10) NULL,
	[Extension1_Justification] [nvarchar](max) NULL,
	[Extension1_Target_Date] [date] NULL,
	[Extension1_Approved_By] [varchar](100) NULL,
	[Extension1_Approval_DateTime] [datetime2](7) NULL,
	[Extension2_Required] [varchar](10) NULL,
	[Extension2_Justification] [nvarchar](max) NULL,
	[Extension2_Target_Date] [date] NULL,
	[Extension2_Approved_By] [varchar](100) NULL,
	[Extension2_Approval_DateTime] [datetime2](7) NULL,
	[Extension3_Required] [varchar](10) NULL,
	[Extension3_Justification] [nvarchar](max) NULL,
	[Extension3_Target_Date] [date] NULL,
	[Extension3_Approved_By] [varchar](100) NULL,
	[Extension3_Approval_DateTime] [datetime2](7) NULL,
	[Closed_Within_Timeline] [varchar](10) NULL,
	[Final_Closure_Remark] [nvarchar](max) NULL,
	[Closure_By] [varchar](100) NULL,
	[Closure_Date] [date] NULL,
	[Workflow_Status] [varchar](50) NULL,
	[Created_Date] [datetime2](7) NOT NULL,
	[Last_Updated_Date] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Deviation_Master_Table] ADD  DEFAULT (getdate()) FOR [Created_Date]
GO


---------------------------------------------------------------------------------------

USE [AOL_EQUIPMENT_MASTER]
GO

/****** Object:  Table [dbo].[EquipmentMaster]    Script Date: 6/10/2026 1:54:25 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[EquipmentMaster](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CCFOrProjectOrRequirementId] [nvarchar](100) NULL,
	[SiteName] [nvarchar](100) NULL,
	[LocationArea] [nvarchar](150) NULL,
	[LabName] [nvarchar](100) NULL,
	[AssetNumber] [nvarchar](50) NULL,
	[SerialNumber] [nvarchar](100) NULL,
	[EquipmentName] [nvarchar](150) NULL,
	[EquipmentNumber] [nvarchar](100) NULL,
	[Make] [nvarchar](100) NULL,
	[Model] [nvarchar](100) NULL,
	[Specifications] [nvarchar](max) NULL,
	[InstallationDate] [date] NULL,
	[Priority] [nvarchar](50) NULL,
	[PMOrCalibrationRequired] [nvarchar](50) NULL,
	[PMOrCalibrationType] [nvarchar](50) NULL,
	[Frequency] [nvarchar](50) NULL,
	[WeeklyCalibrationDate] [date] NULL,
	[MonthlyCalibrationDate] [date] NULL,
	[QuarterlyCalibrationDate] [date] NULL,
	[HalfYearlyCalibrationDate] [date] NULL,
	[YearlyCalibrationDate] [date] NULL,
	[WeeklyCalibrationDue] [date] NULL,
	[MonthlyCalibrationDue] [date] NULL,
	[QuarterlyCalibrationDue] [date] NULL,
	[HalfYearlyCalibrationDue] [date] NULL,
	[YearlyCalibrationDue] [date] NULL,
	[WarrantyType] [nvarchar](50) NULL,
	[WarrantyEndDate] [date] NULL,
	[ExtendedWarrantyDate] [date] NULL,
	[PurchaseOrderNumber] [nvarchar](100) NULL,
	[VendorName] [nvarchar](150) NULL,
	[VendorEmail] [nvarchar](150) NULL,
	[VendorPhone] [nvarchar](30) NULL,
	[IsActive] [nvarchar](20) NULL,
	[Remarks] [nvarchar](max) NULL,
	[FileName] [nvarchar](255) NULL,
	[FileData] [varbinary](max) NULL,
	[CreatedDate] [datetime2](7) NOT NULL,
	[CreatedBy] [nvarchar](100) NULL,
	[UpdatedDate] [datetime2](7) NOT NULL,
	[UpdatedBy] [nvarchar](100) NULL,
	[ExtraInput1] [nvarchar](255) NULL,
	[ExtraInput2] [nvarchar](255) NULL,
	[ExtraInput3] [nvarchar](255) NULL,
	[ExtraInput4] [nvarchar](255) NULL,
	[ExtraInput5] [nvarchar](255) NULL,
	[ExtraDate1] [date] NULL,
	[ExtraDate2] [date] NULL,
	[ExtraDate3] [date] NULL,
	[ExtraDate4] [date] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[EquipmentMaster] ADD  DEFAULT (getdate()) FOR [CreatedDate]
GO

ALTER TABLE [dbo].[EquipmentMaster] ADD  DEFAULT (getdate()) FOR [UpdatedDate]
GO


-----------------------------------------------------------------------------

USE [AOL_Inventory]
GO

/****** Object:  Table [dbo].[Inventory_Usage]    Script Date: 6/10/2026 1:55:15 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Inventory_Usage](
	[UsageID] [int] IDENTITY(1,1) NOT NULL,
	[ItemCode] [varchar](100) NOT NULL,
	[UsageDate] [datetime] NOT NULL,
	[UsageType] [varchar](50) NULL,
	[QuantityUsed] [decimal](18, 3) NULL,
	[UOM] [varchar](50) NULL,
	[UnitCost] [decimal](18, 2) NULL,
	[TotalCost]  AS ([QuantityUsed]*[UnitCost]) PERSISTED,
	[FromLocation] [varchar](255) NULL,
	[ToLocation] [varchar](255) NULL,
	[ReferenceDocNo] [varchar](100) NULL,
	[UsedBy] [varchar](100) NULL,
	[ApprovedBy] [varchar](100) NULL,
	[Remarks] [varchar](500) NULL,
	[custom_field_1] [varchar](255) NULL,
	[custom_field_2] [varchar](255) NULL,
	[custom_field_3] [varchar](255) NULL,
	[custom_field_4] [varchar](255) NULL,
	[custom_field_5] [varchar](255) NULL,
	[CreatedOn] [datetime] NULL,
	[UpdatedOn] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[UsageID] 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].[Inventory_Usage] ADD  DEFAULT (getdate()) FOR [CreatedOn]
GO

ALTER TABLE [dbo].[Inventory_Usage] ADD  DEFAULT (getdate()) FOR [UpdatedOn]
GO


USE [AOL_Inventory]
GO

/****** Object:  Table [dbo].[item_code_master]    Script Date: 6/10/2026 1:55:46 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[item_code_master](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[item_code] [varchar](100) NOT NULL,
	[item_name] [varchar](255) NULL,
	[category] [varchar](100) NULL,
	[sub_category] [varchar](100) NULL,
	[warehouse_location] [varchar](255) NULL,
	[make] [varchar](255) NULL,
	[model_number] [varchar](100) NULL,
	[specification] [varchar](max) NULL,
	[uom] [varchar](50) NULL,
	[vendor] [varchar](255) NULL,
	[min_stock] [int] NULL,
	[max_stock] [int] NULL,
	[reorder_level] [int] NULL,
	[reorder_quantity] [int] NULL,
	[stock_quantity] [int] NULL,
	[cost_price] [decimal](15, 2) NULL,
	[selling_price] [decimal](15, 2) NULL,
	[service_life] [varchar](50) NULL,
	[warranty_period] [varchar](50) NULL,
	[criticality] [varchar](50) NULL,
	[barcode] [varchar](100) NULL,
	[qr_code] [varchar](255) NULL,
	[item_status] [varchar](50) NULL,
	[expiry_date] [date] NULL,
	[is_active] [varchar](50) NULL,
	[custom_field_1] [varchar](255) NULL,
	[custom_field_2] [varchar](255) NULL,
	[custom_field_3] [varchar](255) NULL,
	[custom_field_4] [varchar](255) NULL,
	[custom_field_5] [varchar](255) NULL,
	[plant] [varchar](100) NULL,
	[department] [varchar](100) NULL,
	[last_po] [varchar](100) NULL,
	[remarks] [varchar](500) NULL,
	[created_at] [datetime] NULL,
	[updated_at] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[item_code_master] ADD  DEFAULT (getdate()) FOR [created_at]
GO

ALTER TABLE [dbo].[item_code_master] ADD  DEFAULT (getdate()) FOR [updated_at]
GO


------------------------------------------------------------------------------



USE [AOL_Project]
GO

/****** Object:  Table [dbo].[project_approvals]    Script Date: 6/10/2026 1:56:39 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[project_approvals](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[technical_feasibility] [varchar](100) NULL,
	[space_feasibility] [varchar](100) NULL,
	[utility_feasibility] [varchar](100) NULL,
	[feasibility_comments] [text] NULL,
	[budget_estimate] [decimal](15, 2) NULL,
	[timeline_estimate] [varchar](100) NULL,
	[feasibility_status] [varchar](25) NULL,
	[dept_approved_by] [varchar](100) NULL,
	[dept_approved_date] [datetime] NULL,
	[eng_approved_by] [varchar](100) NULL,
	[eng_approved_date] [datetime] NULL,
	[qa_approved_by] [varchar](100) NULL,
	[qa_approved_date] [datetime] NULL,
	[safety_approved_by] [varchar](100) NULL,
	[safety_approved_date] [datetime] NULL,
	[finance_approved_by] [varchar](100) NULL,
	[finance_approved_date] [datetime] NULL,
	[mgmt_approved_by] [varchar](100) NULL,
	[mgmt_approved_date] [datetime] NULL,
	[approval_status] [varchar](25) NULL,
	[rejection_reason] [text] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Project]
GO

/****** Object:  Table [dbo].[project_closure]    Script Date: 6/10/2026 1:57:20 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[project_closure](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[closure_summary] [text] NULL,
	[lessons_learned] [text] NULL,
	[final_cost] [decimal](15, 2) NULL,
	[cost_variance] [decimal](15, 2) NULL,
	[manager_approved_by] [varchar](100) NULL,
	[manager_approval_date] [datetime] NULL,
	[closure_status] [varchar](50) NULL,
	[closure_date] [date] NULL,
	[project_rating] [varchar](50) NULL,
	[client_feedback] [text] NULL,
	[additional_field2] [varchar](225) NULL,
	[additional_field3] [varchar](225) NULL,
	[additional_datetime1] [datetime] NULL,
	[additional_datetime2] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_Project]
GO

/****** Object:  Table [dbo].[project_documents]    Script Date: 6/10/2026 1:57:56 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[project_documents](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[document_type] [varchar](100) NULL,
	[document] [varbinary](max) NULL,
	[document_name] [varchar](255) NULL,
	[version] [varchar](50) NULL,
	[status] [varchar](50) NULL,
	[uploaded_by] [varchar](100) NULL,
	[uploaded_at] [datetime] NULL,
	[remarks] [nvarchar](max) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[project_documents] ADD  DEFAULT (getdate()) FOR [uploaded_at]
GO


USE [AOL_Project]
GO

/****** Object:  Table [dbo].[project_tasks]    Script Date: 6/10/2026 1:58:58 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[project_tasks](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[task_name] [varchar](255) NULL,
	[work_type] [varchar](50) NULL,
	[assigned_to] [varchar](100) NULL,
	[supervisor] [varchar](100) NULL,
	[dependency_task] [varchar](50) NULL,
	[milestone_flag] [varchar](50) NULL,
	[task_sequence] [varchar](50) NULL,
	[start_date] [date] NULL,
	[due_date] [date] NULL,
	[actual_end_date] [date] NULL,
	[estimated_hours] [decimal](10, 2) NULL,
	[actual_hours] [decimal](10, 2) NULL,
	[status] [varchar](50) NULL,
	[completion_percentage] [int] NULL,
	[delay_reason] [text] NULL,
	[issue_log] [text] NULL,
	[additional_field2] [varchar](225) NULL,
	[additional_field3] [varchar](225) NULL,
	[additional_datetime1] [datetime] NULL,
	[additional_datetime2] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[project_tasks] ADD  DEFAULT ((0)) FOR [completion_percentage]
GO


USE [AOL_Project]
GO

/****** Object:  Table [dbo].[project_validation]    Script Date: 6/10/2026 1:59:39 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[project_validation](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[installation_status] [varchar](50) NULL,
	[installation_report] [varchar](255) NULL,
	[fat_required] [varchar](50) NULL,
	[fat_status] [varchar](50) NULL,
	[fat_report] [varchar](255) NULL,
	[sat_required] [varchar](50) NULL,
	[sat_status] [varchar](50) NULL,
	[sat_report] [varchar](255) NULL,
	[validation_status] [varchar](50) NULL,
	[validation_report] [varchar](255) NULL,
	[commissioning_status] [varchar](50) NULL,
	[commissioning_report] [varchar](255) NULL,
	[completed_by] [varchar](100) NULL,
	[completed_date] [date] NULL,
	[additional_field2] [varchar](225) NULL,
	[additional_field3] [varchar](225) NULL,
	[additional_datetime1] [datetime] NULL,
	[additional_datetime2] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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


USE [AOL_Project]
GO

/****** Object:  Table [dbo].[projects_master]    Script Date: 6/10/2026 2:00:09 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[projects_master](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[project_id] [varchar](255) NOT NULL,
	[project_title] [varchar](255) NOT NULL,
	[project_code] [varchar](100) NULL,
	[project_category] [varchar](100) NULL,
	[location] [varchar](255) NULL,
	[requesting_department] [varchar](100) NULL,
	[requested_by] [varchar](100) NULL,
	[project_owner] [varchar](100) NULL,
	[description] [nvarchar](max) NULL,
	[justification] [nvarchar](max) NULL,
	[vendor_name] [varchar](255) NULL,
	[currency] [varchar](10) NULL,
	[capex_opex] [varchar](25) NULL,
	[gxp_type] [varchar](25) NULL,
	[change_control_number] [varchar](100) NULL,
	[project_type] [varchar](25) NULL,
	[baseline_start_date] [date] NULL,
	[baseline_end_date] [date] NULL,
	[expected_start_date] [date] NULL,
	[expected_completion] [date] NULL,
	[estimated_budget] [decimal](15, 2) NULL,
	[approved_budget] [decimal](15, 2) NULL,
	[actual_budget] [decimal](15, 2) NULL,
	[project_status] [varchar](25) NULL,
	[priority] [varchar](25) NULL,
	[overall_completion_status] [varchar](25) NULL,
	[delay_flag] [varchar](25) NULL,
	[delay_reason] [nvarchar](max) NULL,
	[risk_level] [varchar](25) NULL,
	[risk_summary] [nvarchar](max) NULL,
	[created_by] [varchar](100) NULL,
	[created_at] [datetime] NULL,
	[updated_by] [varchar](100) NULL,
	[updated_at] [datetime] NULL,
	[additional_field1] [varchar](225) NULL,
	[additional_field2] [varchar](225) NULL,
	[additional_field3] [varchar](225) NULL,
	[additional_datetime1] [datetime] NULL,
	[additional_datetime2] [datetime] NULL,
	[additional_datetime3] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[projects_master] ADD  DEFAULT (getdate()) FOR [created_at]
GO

ALTER TABLE [dbo].[projects_master] ADD  DEFAULT (getdate()) FOR [updated_at]
GO


---------------------------------------------------------------------------------

USE [AOL_PRPO]
GO

/****** Object:  Table [dbo].[PRPO_Tracking]    Script Date: 6/10/2026 2:01:15 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[PRPO_Tracking](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CostCenter] [nvarchar](50) NULL,
	[CostCenterDesc] [nvarchar](255) NULL,
	[WBSElement] [nvarchar](100) NULL,
	[ProjectName] [nvarchar](255) NULL,
	[PRNumber] [nvarchar](50) NULL,
	[PRItem] [int] NULL,
	[POItemNo] [int] NULL,
	[PurGroup] [nvarchar](50) NULL,
	[PONumber] [nvarchar](50) NULL,
	[PODate] [date] NULL,
	[MaterialNo] [nvarchar](100) NULL,
	[TotalValueWithoutTax] [decimal](18, 2) NULL,
	[TaxValue] [decimal](18, 2) NULL,
	[TotalValueWithTax] [decimal](18, 2) NULL,
	[POCurrency] [nvarchar](10) NULL,
	[TotalValueWithTax_LC] [decimal](18, 2) NULL,
	[LongText] [nvarchar](max) NULL,
	[MaterialShortText] [nvarchar](500) NULL,
	[POQuantity] [decimal](18, 3) NULL,
	[UOM] [nvarchar](20) NULL,
	[UnitRate] [decimal](18, 2) NULL,
	[LandedCost] [decimal](18, 2) NULL,
	[POBasicValue] [decimal](18, 2) NULL,
	[TrackingNo] [nvarchar](100) NULL,
	[PRDate] [date] NULL,
	[VendorName] [nvarchar](255) NULL,
	[DeliveryDate] [date] NULL,
	[GRDate] [date] NULL,
	[GRQuantity] [decimal](18, 3) NULL,
	[GRItem] [int] NULL,
	[GRNNumber] [nvarchar](100) NULL,
	[InvoiceDate] [date] NULL,
	[InvoiceNo] [nvarchar](100) NULL,
	[InvoiceQty] [decimal](18, 3) NULL,
	[InvoiceValue] [decimal](18, 2) NULL,
	[Plant] [nvarchar](100) NULL,
	[DelIndicator] [nvarchar](10) NULL,
	[TotalValueWithoutTax_LC] [decimal](18, 2) NULL,
	[PerUnit] [decimal](18, 2) NULL,
	[VendorNo] [nvarchar](100) NULL,
	[BrandName] [nvarchar](255) NULL,
	[PRReleaseDate] [date] NULL,
	[Requisitioner] [nvarchar](255) NULL,
	[OrderPriceUnit] [nvarchar](50) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_PRPO]
GO

/****** Object:  Table [dbo].[PRPO_Tracking_Staging]    Script Date: 6/10/2026 2:01:48 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[PRPO_Tracking_Staging](
	[StagingId] [int] IDENTITY(1,1) NOT NULL,
	[CostCenter] [nvarchar](255) NULL,
	[CostCenterDesc] [nvarchar](500) NULL,
	[WBSElement] [nvarchar](255) NULL,
	[ProjectName] [nvarchar](500) NULL,
	[PRNumber] [nvarchar](100) NULL,
	[PRItem] [nvarchar](50) NULL,
	[POItemNo] [nvarchar](50) NULL,
	[PurGroup] [nvarchar](100) NULL,
	[PONumber] [nvarchar](100) NULL,
	[PODate] [nvarchar](50) NULL,
	[MaterialNo] [nvarchar](255) NULL,
	[TotalValueWithoutTax] [nvarchar](100) NULL,
	[TaxValue] [nvarchar](100) NULL,
	[TotalValueWithTax] [nvarchar](100) NULL,
	[POCurrency] [nvarchar](20) NULL,
	[TotalValueWithTax_LC] [nvarchar](100) NULL,
	[LongText] [nvarchar](max) NULL,
	[MaterialShortText] [nvarchar](1000) NULL,
	[POQuantity] [nvarchar](100) NULL,
	[UOM] [nvarchar](50) NULL,
	[UnitRate] [nvarchar](100) NULL,
	[LandedCost] [nvarchar](100) NULL,
	[POBasicValue] [nvarchar](100) NULL,
	[TrackingNo] [nvarchar](255) NULL,
	[PRDate] [nvarchar](50) NULL,
	[VendorName] [nvarchar](500) NULL,
	[DeliveryDate] [nvarchar](50) NULL,
	[GRDate] [nvarchar](50) NULL,
	[GRQuantity] [nvarchar](100) NULL,
	[GRItem] [nvarchar](50) NULL,
	[GRNNumber] [nvarchar](100) NULL,
	[InvoiceDate] [nvarchar](50) NULL,
	[InvoiceNo] [nvarchar](100) NULL,
	[InvoiceQty] [nvarchar](100) NULL,
	[InvoiceValue] [nvarchar](100) NULL,
	[Plant] [nvarchar](100) NULL,
	[DelIndicator] [nvarchar](50) NULL,
	[TotalValueWithoutTax_LC] [nvarchar](100) NULL,
	[PerUnit] [nvarchar](100) NULL,
	[VendorNo] [nvarchar](100) NULL,
	[BrandName] [nvarchar](255) NULL,
	[PRReleaseDate] [nvarchar](50) NULL,
	[Requisitioner] [nvarchar](255) NULL,
	[OrderPriceUnit] [nvarchar](100) NULL,
PRIMARY KEY CLUSTERED 
(
	[StagingId] 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] TEXTIMAGE_ON [PRIMARY]
GO


--------------------------------------------------------------------------

USE [AOL_TICKET]
GO

/****** Object:  Table [dbo].[Ticket_Management]    Script Date: 6/10/2026 2:03:09 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Ticket_Management](
	[Sno] [bigint] IDENTITY(1,1) NOT NULL,
	[TicketId] [nvarchar](50) NOT NULL,
	[Createdby] [nvarchar](50) NOT NULL,
	[TicketDate] [date] NOT NULL,
	[Site] [nvarchar](50) NULL,
	[Location] [nvarchar](50) NOT NULL,
	[EquipmentId] [nvarchar](100) NULL,
	[Title] [nvarchar](200) NOT NULL,
	[WorkDescription] [nvarchar](max) NOT NULL,
	[PhoneNumber] [nvarchar](20) NULL,
	[DepartmentName] [nvarchar](50) NULL,
	[WorkType] [nvarchar](50) NULL,
	[Category] [nvarchar](50) NULL,
	[TargetDateTime] [datetime] NULL,
	[AssignedTo] [nvarchar](50) NULL,
	[Priority] [nvarchar](20) NULL,
	[Critical] [nvarchar](20) NULL,
	[Status] [nvarchar](30) NULL,
	[StartTime] [datetime] NULL,
	[EndTime] [datetime] NULL,
	[CompletedDate] [datetime] NULL,
	[HoldTimeMinutes] [datetime] NULL,
	[HoldRemarks] [nvarchar](500) NULL,
	[WorkUpdates] [nvarchar](max) NULL,
	[ResolutionSummary] [nvarchar](max) NULL,
	[Remarks] [nvarchar](max) NULL,
	[Commands] [nvarchar](max) NULL,
	[AttachmentName] [nvarchar](255) NULL,
	[AttachmentData] [varbinary](max) NULL,
	[CreatedAt] [datetime] NULL,
	[UpdatedAt] [datetime] NULL,
	[AdditionalText1] [nvarchar](200) NULL,
	[AdditionalText2] [nvarchar](200) NULL,
	[AdditionalText3] [nvarchar](200) NULL,
	[AdditionalDate1] [datetime] NULL,
	[AdditionalDate2] [datetime] NULL,
	[AdditionalDate3] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Sno] 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] TEXTIMAGE_ON [PRIMARY]
GO


USE [AOL_TICKET]
GO

/****** Object:  Table [dbo].[Tickets]    Script Date: 6/10/2026 2:03:47 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Tickets](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[TicketNumber] [nvarchar](50) NULL,
	[LoggedBy] [nvarchar](100) NULL,
	[CreatedAt] [datetime2](7) NOT NULL,
	[UpdatedAt] [datetime2](7) NOT NULL,
	[ContactPerson] [nvarchar](100) NULL,
	[ContactNumber] [nvarchar](30) NULL,
	[SiteName] [nvarchar](100) NULL,
	[WorkType] [nvarchar](100) NULL,
	[WorkLocation] [nvarchar](150) NULL,
	[EquipmentId] [nvarchar](50) NULL,
	[EquipmentMake] [nvarchar](100) NULL,
	[EquipmentModel] [nvarchar](100) NULL,
	[WorkPermitRequired] [nvarchar](50) NULL,
	[WorkPermitReferenceNumber] [nvarchar](100) NULL,
	[WorkPermitAttachment] [varbinary](max) NULL,
	[WorkPermitAttachmentFileName] [nvarchar](255) NULL,
	[CCFRequired] [nvarchar](50) NULL,
	[CCFReferenceNumber] [nvarchar](100) NULL,
	[CCFAttachment] [varbinary](max) NULL,
	[CCFAttachmentFileName] [nvarchar](255) NULL,
	[Priority] [nvarchar](50) NULL,
	[DepartmentName] [nvarchar](100) NULL,
	[TicketTitle] [nvarchar](255) NULL,
	[WorkDescription] [nvarchar](max) NULL,
	[TargetCompletionDate] [date] NULL,
	[ClearanceStatus] [nvarchar](50) NULL,
	[ClearanceDateTime] [datetime2](7) NULL,
	[TicketStatus] [nvarchar](50) NULL,
	[ReopenOption] [nvarchar](50) NULL,
	[AssignedTo] [nvarchar](100) NULL,
	[WorkStartTime] [datetime2](7) NULL,
	[WorkCompletionRemarks] [nvarchar](max) NULL,
	[HoldRemarks] [nvarchar](max) NULL,
	[ResolutionSummary] [nvarchar](max) NULL,
	[AdditionalRemarks] [nvarchar](max) NULL,
	[WorkEndTime] [datetime2](7) NULL,
	[CompletedDate] [date] NULL,
	[AttachmentFileName] [nvarchar](255) NULL,
	[AttachmentFile] [varbinary](max) NULL,
	[Commands] [nvarchar](max) NULL,
	[SparesUsed] [nvarchar](50) NULL,
	[ItemCodeOrItemName] [nvarchar](150) NULL,
	[SpareDescription] [nvarchar](max) NULL,
	[SpareQuantity] [int] NULL,
	[SpareCost] [decimal](12, 2) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Tickets] ADD  DEFAULT (getdate()) FOR [CreatedAt]
GO

ALTER TABLE [dbo].[Tickets] ADD  DEFAULT (getdate()) FOR [UpdatedAt]
GO


----------------------------------------------------------------------


USE [AOL_WORK]
GO

/****** Object:  Table [dbo].[WorkLog]    Script Date: 6/10/2026 2:04:33 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WorkLog](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[WorkType] [nvarchar](20) NULL,
	[WorkCategory] [nvarchar](50) NULL,
	[WorkDescription] [nvarchar](max) NULL,
	[WorkDoneDate] [date] NULL,
	[WorkStatus] [nvarchar](30) NULL,
	[UpdatedBy] [nvarchar](100) NULL,
	[UpdatedDate] [date] NULL,
	[BeforeFileName] [nvarchar](255) NULL,
	[BeforeFileData] [varbinary](max) NULL,
	[AfterFileName] [nvarchar](255) NULL,
	[AfterFileData] [varbinary](max) NULL,
	[ExtraInput1] [nvarchar](255) NULL,
	[ExtraInput2] [nvarchar](255) NULL,
	[ExtraInput3] [nvarchar](255) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO


----------------------------------------------------------------------------

USE [AOLCCF]
GO

/****** Object:  Table [dbo].[Change_Control_Actions]    Script Date: 6/10/2026 2:05:31 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Change_Control_Actions](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CCF_Number] [nvarchar](50) NOT NULL,
	[Action_Description] [nvarchar](max) NULL,
	[Responsible_Department] [nvarchar](100) NULL,
	[Responsible_Person] [nvarchar](100) NULL,
	[Target_Date] [date] NULL,
	[Completion_Date] [date] NULL,
	[AttachmentFileName] [nvarchar](255) NULL,
	[AttachmentFile] [varbinary](max) NULL,
	[Action_Status] [nvarchar](50) NULL,
	[Accepted_By] [nvarchar](100) NULL,
	[Acceptance_Status] [nvarchar](50) NULL,
	[Acceptance_Date] [datetime2](7) NULL,
	[Acceptance_Remarks] [nvarchar](max) NULL,
	[Approver_Name] [nvarchar](100) NULL,
	[Approval_Role] [nvarchar](50) NULL,
	[Approval_Status] [nvarchar](50) NULL,
	[Approval_Comments] [nvarchar](max) NULL,
	[Approval_Date] [datetime2](7) NULL,
	[Created_Date] [datetime2](7) NULL,
	[Last_Updated_Date] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Change_Control_Actions] ADD  DEFAULT (getdate()) FOR [Created_Date]
GO


USE [AOLCCF]
GO

/****** Object:  Table [dbo].[Change_Control_Master]    Script Date: 6/10/2026 2:06:15 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Change_Control_Master](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CCF_Number] [nvarchar](50) NULL,
	[Site] [nvarchar](100) NULL,
	[Initiation_Department] [nvarchar](50) NULL,
	[Project_Name] [nvarchar](100) NULL,
	[Reference_Number] [nvarchar](100) NULL,
	[Document_Title] [nvarchar](255) NULL,
	[Change_Related_To] [nvarchar](200) NULL,
	[Change_Category] [nvarchar](50) NULL,
	[Existing_Procedure] [nvarchar](max) NULL,
	[Proposed_Change] [nvarchar](max) NULL,
	[Change_Reason] [nvarchar](max) NULL,
	[Linked_Deviation_CAPA] [nvarchar](100) NULL,
	[Initiator_Name] [nvarchar](100) NULL,
	[Initiator_Sign_Date] [date] NULL,
	[Initiator_Impact_Assessment] [nvarchar](max) NULL,
	[Dept_Head_Assigned_To] [nvarchar](100) NULL,
	[Dept_Head_Review_Status] [nvarchar](50) NULL,
	[Dept_Head_Reviewed_By] [nvarchar](100) NULL,
	[Dept_Head_Review_Datetime] [datetime2](7) NULL,
	[Dept_Head_Review_Comments] [nvarchar](max) NULL,
	[DQA_Assigned_To] [nvarchar](100) NULL,
	[DQA_Review_Status] [nvarchar](50) NULL,
	[DQA_Reviewed_By] [nvarchar](100) NULL,
	[DQA_Review_Datetime] [datetime2](7) NULL,
	[DQA_Review_Comments] [nvarchar](max) NULL,
	[Change_Implementable] [nvarchar](20) NULL,
	[CFT_Required] [nvarchar](10) NULL,
	[CFT_Assigned_To] [nvarchar](255) NULL,
	[CFT_Review_Status] [nvarchar](50) NULL,
	[CFT_Reviewed_By] [nvarchar](255) NULL,
	[CFT_Review_Datetime] [datetime2](7) NULL,
	[CFT_Decision] [nvarchar](50) NULL,
	[CFT_Remarks] [nvarchar](max) NULL,
	[Change_Level] [nvarchar](50) NULL,
	[Closure_Timeline] [nvarchar](50) NULL,
	[Post_Implementation_Review] [nvarchar](max) NULL,
	[Extension1_Required] [nvarchar](10) NULL,
	[Extension1_Justification] [nvarchar](max) NULL,
	[Extension1_Target_Date] [date] NULL,
	[Extension1_Approved_By] [nvarchar](100) NULL,
	[Extension1_Approval_Datetime] [datetime2](7) NULL,
	[Extension2_Required] [nvarchar](10) NULL,
	[Extension2_Justification] [nvarchar](max) NULL,
	[Extension2_Target_Date] [date] NULL,
	[Extension2_Approved_By] [nvarchar](100) NULL,
	[Extension2_Approval_Datetime] [datetime2](7) NULL,
	[Extension3_Required] [nvarchar](10) NULL,
	[Extension3_Justification] [nvarchar](max) NULL,
	[Extension3_Target_Date] [date] NULL,
	[Extension3_Approved_By] [nvarchar](100) NULL,
	[Extension3_Approval_Datetime] [datetime2](7) NULL,
	[Final_Approval_Assigned_To] [nvarchar](100) NULL,
	[Final_Approval_Status] [nvarchar](50) NULL,
	[Final_Approval_Reviewed_By] [nvarchar](100) NULL,
	[Final_Approval_Review_Datetime] [datetime2](7) NULL,
	[Final_Approval_Comments] [nvarchar](max) NULL,
	[Initiator_Closing_Comments] [nvarchar](max) NULL,
	[Documents_Updated] [nvarchar](10) NULL,
	[Training_Completed] [nvarchar](10) NULL,
	[Closed_Within_Timeline] [nvarchar](10) NULL,
	[Delay_Justification] [nvarchar](max) NULL,
	[Final_DQA_Comments] [nvarchar](max) NULL,
	[Final_Conclusion] [nvarchar](50) NULL,
	[Closure_Date] [date] NULL,
	[Workflow_Status] [nvarchar](50) NULL,
	[Created_Date] [datetime2](7) NULL,
	[Last_Updated_Date] [datetime2](7) NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Change_Control_Master] ADD  DEFAULT (getdate()) FOR [Created_Date]
GO


---------------------------------------------------------------------------------------

USE [Audit_Trail]
GO

/****** Object:  Table [dbo].[AuditTrail]    Script Date: 6/10/2026 2:07:03 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AuditTrail](
	[Id] [bigint] IDENTITY(1,1) NOT NULL,
	[entry_id] [nvarchar](255) NOT NULL,
	[action_type] [nvarchar](50) NOT NULL,
	[field_name] [nvarchar](255) NULL,
	[old_value] [nvarchar](max) NULL,
	[new_value] [nvarchar](max) NULL,
	[changed_by] [nvarchar](100) NOT NULL,
	[user_role] [nvarchar](100) NULL,
	[electronic_signature] [nvarchar](255) NULL,
	[reason_for_change] [nvarchar](max) NULL,
	[system_name] [nvarchar](255) NULL,
	[machine_name] [nvarchar](255) NULL,
	[ip_address] [nvarchar](100) NULL,
	[event_timestamp] [datetime2](7) NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[AuditTrail] ADD  DEFAULT (sysutcdatetime()) FOR [event_timestamp]
GO


-------------------------------------------------------------------------

USE [AOL_HistoryCard]
GO

/****** Object:  Table [dbo].[Equipment_History_Card]    Script Date: 6/10/2026 2:08:01 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Equipment_History_Card](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[EquipmentId] [nvarchar](100) NULL,
	[EquipmentName] [nvarchar](250) NULL,
	[SerialNumber] [nvarchar](150) NULL,
	[ActivityType] [nvarchar](100) NULL,
	[ReferenceNo] [nvarchar](100) NULL,
	[Description] [nvarchar](max) NULL,
	[Plant] [nvarchar](150) NULL,
	[Department] [nvarchar](150) NULL,
	[Location] [nvarchar](250) NULL,
	[VendorName] [nvarchar](250) NULL,
	[ServiceEngineer] [nvarchar](250) NULL,
	[ExtraDate1] [datetime] NULL,
	[ExtraDate] [datetime] NULL,
	[Remarks] [nvarchar](max) NULL,
	[CreatedBy] [nvarchar](100) NULL,
	[ActivityDate] [datetime] NULL,
	[ModifiedBy] [nvarchar](100) NULL,
	[ModifiedAt] [datetime] NULL,
PRIMARY KEY CLUSTERED 
(
	[Id] 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] TEXTIMAGE_ON [PRIMARY]
GO

ALTER TABLE [dbo].[Equipment_History_Card] ADD  DEFAULT (getdate()) FOR [ActivityDate]
GO