CREATE TABLE [dbo].[prov_association_link]
(
prov_assoc_key int,
prov_key int NOT NULL,
prov_key_assoc int NOT NULL,
modified_dt datetime not null,
modified_by_key UNIQUEIDENTIFIER not null,
CONSTRAINT [prov_assoc_PK] PRIMARY KEY CLUSTERED (prov_assoc_key ASC),
CONSTRAINT [provider_prov_association_link_FK1] FOREIGN KEY ([prov_key]) REFERENCES [dbo].provider ([prov_key])
)
