﻿--------------------------Hammad 2022-11-06--------

CREATE TABLE [dbo].[Rec_HirinigRequiredFiles](
	[HirinigRequiredFileCode] [int] IDENTITY(1,1) NOT NULL,
	[HirinigDetailCode] [int] NOT NULL,
	[RecruitRequiredFileCode] [int] NOT NULL,
 CONSTRAINT [PK_Rec_HirinigRequiredFiles] PRIMARY KEY CLUSTERED 
(
	[HirinigRequiredFileCode] 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].[Rec_HirinigRequiredFiles]  WITH CHECK ADD  CONSTRAINT [FK_Rec_HirinigRequiredFiles_Rec_HirinigDetails] FOREIGN KEY([HirinigDetailCode])
REFERENCES [dbo].[Rec_HirinigDetails] ([HirinigDetailCode])
GO

ALTER TABLE [dbo].[Rec_HirinigRequiredFiles] CHECK CONSTRAINT [FK_Rec_HirinigRequiredFiles_Rec_HirinigDetails]
GO

ALTER TABLE [dbo].[Rec_HirinigRequiredFiles]  WITH CHECK ADD  CONSTRAINT [FK_Rec_HirinigRequiredFiles_Rec_RecruitRequiredFiles] FOREIGN KEY([RecruitRequiredFileCode])
REFERENCES [dbo].[Rec_RecruitRequiredFiles] ([RecruitRequiredFileCode])
GO

ALTER TABLE [dbo].[Rec_HirinigRequiredFiles] CHECK CONSTRAINT [FK_Rec_HirinigRequiredFiles_Rec_RecruitRequiredFiles]
GO

--------------------------End 2022-11-06--------

--------------------------Ali 2022-11-06--------

CREATE TABLE [dbo].[Rec_JobApplyingStageFiles](
	[JobApplyingStageFileCode] [int] IDENTITY(1,1) NOT NULL,
	[JobApplyingStageCode] [int] NOT NULL,
	[FileName] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_Rec_JobApplyingStageFiles] PRIMARY KEY CLUSTERED 
(
	[JobApplyingStageFileCode] 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].[Rec_JobApplyingStageFiles]  WITH CHECK ADD  CONSTRAINT [FK_Rec_JobApplyingStageFiles_Rec_JobApplyingStages] FOREIGN KEY([JobApplyingStageCode])
REFERENCES [dbo].[Rec_JobApplyingStages] ([JobApplyingStageCode])
GO

ALTER TABLE [dbo].[Rec_JobApplyingStageFiles] CHECK CONSTRAINT [FK_Rec_JobApplyingStageFiles_Rec_JobApplyingStages]
GO
--------------------------End 2022-11-06--------
