﻿--------------------------End 2023-10-15-----------------------
 INSERT[dbo].[ConfigParameter]  ([ConfigKey], [Name], [Arabic_Name], [ConfigValue], [ConfigCategoryCode], [OrderNo], [ConfigType], [IsVisible], [ModifiedBy], [ModificationDate], [RequestTypeId],[ConfigDescription])
VALUES(N'VacCheckEmpHaveFingerprint',N'Check Employee Have Fingerprint',N'التحقق من الموظف لديه بصمة',N'false',2,52,1,1,Null,Null,11,N'التحقق من الموظف لديه بصمة فى يوم اى يوم من الاجازه التى يقوم بادخالها ويظهر تنبيه بذلك')
Go
--------------------------End 2023-10-15-----------------------

--------------------------Negm 2023-10-17-----------------------

CREATE TABLE [dbo].[FingerAreaEmployee](
	[FingerPrintEmployeeCode] [int] IDENTITY(1,1) NOT NULL,
	[EmployeeCode] [int] NOT NULL,
	[FingerAreaCode] [int] NOT NULL,
PRIMARY KEY CLUSTERED 
(
	[FingerPrintEmployeeCode] 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

ALTER TABLE [dbo].[FingerAreaEmployee]  WITH CHECK ADD  CONSTRAINT [FK_FingerAreaEmployee_FingerArea] FOREIGN KEY([FingerAreaCode])
REFERENCES [dbo].[FingerArea] ([FingerAreaCode])
GO

ALTER TABLE [dbo].[FingerAreaEmployee] CHECK CONSTRAINT [FK_FingerAreaEmployee_FingerArea]
GO
--------------------------End 2023-10-17-----------------------

