CREATE TABLE [dbo].[prov_address_link] (
    [prov_address_key]  INT              IDENTITY (1, 1) NOT NULL,
    [address_key]       INT              NOT NULL,
    [address_type_key]  INT              NOT NULL,
    [prov_key]          INT              NOT NULL,
    [prov_address_from] DATETIME         NOT NULL,
    [prov_address_to]   DATETIME         NULL,
    [modified_dt]       DATETIME         NULL,
    [modified_by_key]   UNIQUEIDENTIFIER NULL,
    CONSTRAINT [provider_address_link_PK] PRIMARY KEY CLUSTERED ([prov_address_key] ASC),
    CONSTRAINT [address_main_provider_address_FK] FOREIGN KEY ([address_key]) REFERENCES [dbo].[address_main] ([address_key]),
    CONSTRAINT [provider_provider_address_FK1] FOREIGN KEY ([prov_key]) REFERENCES [dbo].[provider] ([prov_key])
);

