CREATE TABLE [dbo].[prov_company_link] (
    [prov_prac_key]        INT      NOT NULL,
    [prov_company_key]     INT      NOT NULL,
    [prov_company_from_dt] DATETIME NULL,
    [prov_company_till_dt] DATETIME NULL,
    CONSTRAINT [prov_company_prov_company_link_FK1] FOREIGN KEY ([prov_company_key]) REFERENCES [dbo].[prov_company] ([prov_company_key]),
    CONSTRAINT [prov_practice_prov_company_link_FK1] FOREIGN KEY ([prov_prac_key]) REFERENCES [dbo].[prov_practice] ([prov_prac_key]), 
    CONSTRAINT [PK_prov_company_link] PRIMARY KEY ([prov_prac_key], [prov_company_key])
);

