CREATE TABLE [dbo].[prov_prac_address_link] (
    [prov_prac_address_key] INT              IDENTITY (1, 1) NOT NULL,
    [address_key]           INT              NOT NULL,
    [address_type_key]      NVARCHAR(20)     NOT NULL,
    [prov_prac_key]         INT              NOT NULL,
    [address_from]          DATETIME         NOT NULL,
    [address_to]            DATETIME         NULL,
    [modified_dt]           DATETIME         NULL,
    [modified_by_key]       UNIQUEIDENTIFIER NULL,
    CONSTRAINT [prov_prac_address_link_PK] PRIMARY KEY CLUSTERED ([prov_prac_address_key] ASC),
    CONSTRAINT [address_main_prov_prac_address_FK] FOREIGN KEY ([address_key]) REFERENCES [dbo].[address_main] ([address_key]),
    CONSTRAINT [prov_prac_provider_address_FK1] FOREIGN KEY ([prov_prac_key]) REFERENCES [dbo].[prov_practice] ([prov_prac_key])
);

