CREATE TABLE [dbo].[prov_practice_link] (
    [prov_key]               INT      NOT NULL,
    [prov_prac_key]          INT      NOT NULL,
	[prov_prac_admin]		 BIT      NOT NULL default 0,
    [prov_prac_from_dt]      DATETIME NULL,
    [prov_prac_till_dt]      DATETIME NULL,
    [prov_prac_link_key] INT      IDENTITY (1, 1) NOT NULL,
	[prov_prac_link_is_deleted]		 BIT      NOT NULL default 0,
    CONSTRAINT [prov_practice_link_PK] PRIMARY KEY CLUSTERED ([prov_prac_link_key] ASC),
    CONSTRAINT [prov_practice_prov_practice_link_FK1] FOREIGN KEY ([prov_prac_key]) REFERENCES [dbo].[prov_practice] ([prov_prac_key]),
    CONSTRAINT [provider_prov_practice_link_FK1] FOREIGN KEY ([prov_key]) REFERENCES [dbo].[provider] ([prov_key])
);

