CREATE TABLE [dbo].[prov_contract]
(
	[prov_contract_key] INT NOT NULL  IDENTITY, 
    [prov_key] INT NOT NULL, 
    [contract_type] NVARCHAR(50) NULL, 
    [contract_status] NVARCHAR(50) NULL, 
    [modified_dt] DATETIME NULL, 
    [modified_by_key] UNIQUEIDENTIFIER NULL, 
    [file_key] INT NULL, 
    CONSTRAINT [FK_prov_contract_provider] FOREIGN KEY ([prov_key]) REFERENCES [dbo].[provider]([prov_key]), 
    CONSTRAINT [PK_prov_contract] PRIMARY KEY ([prov_contract_key])
)
