s45045
/
hurtownie-danych-gr4
3
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
hurtownie-danych-gr4/ClaimDWH.sql

366 lines
45 KiB
Transact-SQL
Raw Permalink Blame History

This file contains invisible Unicode characters

This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

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
Reference in New Issue View Git Blame Copy Permalink