USE [bigdata_s45045]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Responses]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Products]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Indications]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Countries]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Calendar2]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Calendar1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] DROP CONSTRAINT [FK_ReimbursmentClaim_Calendar]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Responses]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Products]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Indications]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Factories2]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Factories1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Factories]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Countries]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Calendar1]
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] DROP CONSTRAINT [FK_RegistrationClaim_Calendar]
GO
/****** Object:  Table [dbo].[d_Responses]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Responses]') AND type in (N'U'))
DROP TABLE [dbo].[d_Responses]
GO
/****** Object:  Table [dbo].[f_ReimbursmentClaim]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]') AND type in (N'U'))
DROP TABLE [dbo].[f_ReimbursmentClaim]
GO
/****** Object:  Table [dbo].[f_RegistrationClaim]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]') AND type in (N'U'))
DROP TABLE [dbo].[f_RegistrationClaim]
GO
/****** Object:  Table [dbo].[d_Products]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Products]') AND type in (N'U'))
DROP TABLE [dbo].[d_Products]
GO
/****** Object:  Table [dbo].[d_Indications]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Indications]') AND type in (N'U'))
DROP TABLE [dbo].[d_Indications]
GO
/****** Object:  Table [dbo].[d_Factories]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Factories]') AND type in (N'U'))
DROP TABLE [dbo].[d_Factories]
GO
/****** Object:  Table [dbo].[d_Countries]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Countries]') AND type in (N'U'))
DROP TABLE [dbo].[d_Countries]
GO
/****** Object:  Table [dbo].[d_Calendar]    Script Date: 19.04.2017 23:01:53 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Calendar]') AND type in (N'U'))
DROP TABLE [dbo].[d_Calendar]
GO
/****** Object:  Table [dbo].[d_Calendar]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Calendar]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Calendar](
	[DateId] [int] IDENTITY(1,1) NOT NULL,
	[DateNum] [int] NOT NULL,
	[Date_] [date] NOT NULL,
	[Year_] [nvarchar](4) NOT NULL,
	[Month_] [nvarchar](2) NOT NULL,
	[Day_] [nvarchar](2) NOT NULL,
	[Quarter_] [nvarchar](2) NOT NULL,
	[YearQuarter_] [nvarchar](7) NOT NULL,
 CONSTRAINT [PK_Calendar] PRIMARY KEY CLUSTERED 
(
	[DateId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[d_Countries]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Countries]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Countries](
	[CountryId] [int] IDENTITY(1,1) NOT NULL,
	[CountryBk] [nvarchar](2) NOT NULL,
	[CountryName] [nvarchar](300) NULL,
 CONSTRAINT [PK_Countries] PRIMARY KEY CLUSTERED 
(
	[CountryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[d_Factories]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Factories]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Factories](
	[FactoryId] [int] IDENTITY(1,1) NOT NULL,
	[FactoryBk] [nvarchar](50) NOT NULL,
	[FactoryName] [nvarchar](150) NULL,
	[CountryName] [nvarchar](50) NULL,
 CONSTRAINT [PK_Factories] PRIMARY KEY CLUSTERED 
(
	[FactoryId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[d_Indications]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Indications]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Indications](
	[IndicationId] [int] IDENTITY(1,1) NOT NULL,
	[IndicationBk] [nvarchar](13) NOT NULL,
	[IndicationDescription] [nvarchar](500) NULL,
 CONSTRAINT [PK_Indications] PRIMARY KEY CLUSTERED 
(
	[IndicationId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[d_Products]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Products]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Products](
	[ProductId] [int] IDENTITY(1,1) NOT NULL,
	[DrugProductBk] [nvarchar](13) NOT NULL,
	[DrugProductName] [nvarchar](250) NULL,
	[DrugProductFamilyName] [nvarchar](250) NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
	[ProductId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[f_RegistrationClaim]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[f_RegistrationClaim](
	[RegistrationClaimId] [int] IDENTITY(1,1) NOT NULL,
	[ClaimNumber] [nvarchar](20) NULL,
	[CountryId] [int] NOT NULL,
	[SubmissionDateId] [int] NOT NULL,
	[ExpectedResponseDateId] [int] NOT NULL,
	[ResponseDateId] [int] NULL,
	[ProductId] [int] NOT NULL,
	[IndicationId] [int] NOT NULL,
	[FactoryAPIId] [int] NOT NULL,
	[FactoryBulkId] [int] NOT NULL,
	[FactoryPackageId] [int] NOT NULL,
	[ResponseId] [int] NOT NULL,
	[Occurance] [int] NULL default 1,
 CONSTRAINT [PK_RegistrationClaim] PRIMARY KEY CLUSTERED 
(
	[RegistrationClaimId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[f_ReimbursmentClaim]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[f_ReimbursmentClaim](
	[ReimbursmentClaimId] [int] IDENTITY(1,1) NOT NULL,
	[ClaimNumber] [nvarchar](20) NOT NULL,
	[CountryId] [int] NOT NULL,
	[SubmissionDateId] [int] NOT NULL,
	[ExpectedResponseDateId] [int] NOT NULL,
	[ResponseDateId] [int] NOT NULL,
	[ProductId] [int] NOT NULL,
	[IndicationId] [int] NOT NULL,
	[ResponseId] [int] NOT NULL,
	[DrugPrice] [money] NULL,
	[ReimbursmentClaimedPrc] [decimal] NULL,
	[ReimbursmentAppPrc] [decimal] NULL,
	[DrugPriceCurrency] [nvarchar](3) NULL,
 CONSTRAINT [PK_ReimbursmentClaim] PRIMARY KEY CLUSTERED 
(
	[ReimbursmentClaimId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
/****** Object:  Table [dbo].[d_Responses]    Script Date: 19.04.2017 23:01:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[d_Responses]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[d_Responses](
	[ResponseId] [int] IDENTITY(1,1) NOT NULL,
	[ResponseBk] [nvarchar](20) NULL,
	[ResponseType] [nvarchar](150) NULL,
 CONSTRAINT [PK_Responses] PRIMARY KEY CLUSTERED 
(
	[ResponseId] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
END
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Calendar] FOREIGN KEY([ExpectedResponseDateId])
REFERENCES [dbo].[d_Calendar] ([DateId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Calendar]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Calendar1] FOREIGN KEY([SubmissionDateId])
REFERENCES [dbo].[d_Calendar] ([DateId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Calendar1]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Countries] FOREIGN KEY([CountryId])
REFERENCES [dbo].[d_Countries] ([CountryId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Countries]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Factories] FOREIGN KEY([FactoryAPIId])
REFERENCES [dbo].[d_Factories] ([FactoryId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Factories]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Factories1] FOREIGN KEY([FactoryBulkId])
REFERENCES [dbo].[d_Factories] ([FactoryId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Factories1]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Factories2] FOREIGN KEY([FactoryPackageId])
REFERENCES [dbo].[d_Factories] ([FactoryId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Factories2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Factories2]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Indications] FOREIGN KEY([IndicationId])
REFERENCES [dbo].[d_Indications] ([IndicationId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Indications]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Products] FOREIGN KEY([ProductId])
REFERENCES [dbo].[d_Products] ([ProductId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Products]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim]  WITH CHECK ADD  CONSTRAINT [FK_RegistrationClaim_Responses] FOREIGN KEY([ResponseId])
REFERENCES [dbo].[d_Responses] ([ResponseId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_RegistrationClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_RegistrationClaim]'))
ALTER TABLE [dbo].[f_RegistrationClaim] CHECK CONSTRAINT [FK_RegistrationClaim_Responses]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Calendar] FOREIGN KEY([ExpectedResponseDateId])
REFERENCES [dbo].[d_Calendar] ([DateId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Calendar]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Calendar1] FOREIGN KEY([ResponseDateId])
REFERENCES [dbo].[d_Calendar] ([DateId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar1]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Calendar1]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Calendar2] FOREIGN KEY([SubmissionDateId])
REFERENCES [dbo].[d_Calendar] ([DateId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Calendar2]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Calendar2]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Countries] FOREIGN KEY([CountryId])
REFERENCES [dbo].[d_Countries] ([CountryId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Countries]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Countries]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Indications] FOREIGN KEY([IndicationId])
REFERENCES [dbo].[d_Indications] ([IndicationId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Indications]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Indications]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Products] FOREIGN KEY([ProductId])
REFERENCES [dbo].[d_Products] ([ProductId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Products]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Products]
GO
IF NOT EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim]  WITH CHECK ADD  CONSTRAINT [FK_ReimbursmentClaim_Responses] FOREIGN KEY([ResponseId])
REFERENCES [dbo].[d_Responses] ([ResponseId])
GO
IF  EXISTS (SELECT * FROM sys.foreign_keys WHERE object_id = OBJECT_ID(N'[dbo].[FK_ReimbursmentClaim_Responses]') AND parent_object_id = OBJECT_ID(N'[dbo].[f_ReimbursmentClaim]'))
ALTER TABLE [dbo].[f_ReimbursmentClaim] CHECK CONSTRAINT [FK_ReimbursmentClaim_Responses]
GO