
CREATE TABLE [dbo].[prov_unit_address_link] (
    [prov_unit_address_key] INT              IDENTITY (1, 1) NOT NULL,
    [address_key]           INT              NOT NULL,
    [address_type_key]      INT              NOT NULL,
    [prov_unit_key]         INT              NOT NULL,
	[same_as_practice]		BIT Default 0    NOT NULL,
    [address_from]          DATETIME         NOT NULL,
    [address_to]            DATETIME         NULL,
    [modified_dt]           DATETIME         NULL,
    [modified_by_key]       UNIQUEIDENTIFIER NULL,
    CONSTRAINT [prov_unit_address_link_PK] PRIMARY KEY CLUSTERED ([prov_unit_address_key] ASC)
);

