CREATE TABLE [dbo].[prov_unit_link] (
    [prov_unit_link_key]    INT      IDENTITY (1, 1) NOT NULL,
    [prov_key]              INT      NOT NULL,
    [prov_unit_key]         INT      NOT NULL,
    [prov_location_no]      INT      NOT NULL,
    [prov_location_from_dt] DATETIME NULL,
    [prov_location_till_dt] DATETIME NULL,
    [prov_location_key]     INT      NULL,
    [prov_prac_key]         INT      NULL,
    CONSTRAINT [PK_prov_unit_link] PRIMARY KEY CLUSTERED ([prov_unit_link_key] ASC),
    CONSTRAINT [practice_prov_unit_link_FK1] FOREIGN KEY ([prov_prac_key]) REFERENCES [dbo].[prov_practice] ([prov_prac_key]),
    CONSTRAINT [prov_unit_prov_unit_link_FK1] FOREIGN KEY ([prov_unit_key]) REFERENCES [dbo].[prov_unit] ([prov_unit_key]),
    CONSTRAINT [provider_prov_unit_link_FK1] FOREIGN KEY ([prov_key]) REFERENCES [dbo].[provider] ([prov_key])
);

