------------------------------- Ali 2020-04-13 --------------------------

CREATE TABLE [dbo].[WF_GeneralsRequest](
	[MasterRequestCode] [int] NOT NULL,
	[GeneralRequestTypeCode] [int] NOT NULL,
 CONSTRAINT [PK_WF_GeneralsRequest] PRIMARY KEY CLUSTERED 
(
	[MasterRequestCode] 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].[WF_GeneralsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralsRequest_WF_GeneralRequestType] FOREIGN KEY([GeneralRequestTypeCode])
REFERENCES [dbo].[WF_GeneralRequestType] ([GeneralRequestTypeCode])
GO

ALTER TABLE [dbo].[WF_GeneralsRequest] CHECK CONSTRAINT [FK_WF_GeneralsRequest_WF_GeneralRequestType]
GO

ALTER TABLE [dbo].[WF_GeneralsRequest]  WITH CHECK ADD  CONSTRAINT [FK_WF_GeneralsRequest_WF_MasterRequests] FOREIGN KEY([MasterRequestCode])
REFERENCES [dbo].[WF_MasterRequests] ([MasterRequestCode])
GO

ALTER TABLE [dbo].[WF_GeneralsRequest] CHECK CONSTRAINT [FK_WF_GeneralsRequest_WF_MasterRequests]
GO
------------------------------- End 2020-04-13 --------------------------