CREATE TABLE [dbo].[prov_ipa_link] (
    [ipa_key]           INT      NOT NULL,
    [prov_key]          INT      NOT NULL,
    [prov_ipa_from_dt]  DATETIME NULL,
    [prov_ipa_till_dt]  DATETIME NULL,
    [prov_ipa_link_key] INT      IDENTITY (1, 1) NOT NULL,
    CONSTRAINT [prov_ipa_link_PK] PRIMARY KEY CLUSTERED ([prov_ipa_link_key] ASC),
    CONSTRAINT [prov_ipa_prov_ipa_link_FK1] FOREIGN KEY ([ipa_key]) REFERENCES [dbo].[prov_ipa] ([ipa_key]),
    CONSTRAINT [provider_prov_ipa_link_FK1] FOREIGN KEY ([prov_key]) REFERENCES [dbo].[provider] ([prov_key])
);

