CREATE TABLE [dbo].[Lender]
(
	[Id]			  INT NOT NULL PRIMARY KEY, 
	[LenderNumber]    NVARCHAR (50) NOT NULL,
	[ProfileTypeId]   INT           NOT NULL,
	--[IsActive]		  BIT			NOT NULL DEFAULT(0),
	[StatusId] INT NOT NULL DEFAULT 1, 
    CONSTRAINT [FK_Lender_Profile] FOREIGN KEY ([Id]) REFERENCES [Profile]([Id]),
    CONSTRAINT [FK_Lender_ProfileType] FOREIGN KEY ([ProfileTypeId]) REFERENCES [ProfileType]([Id]),
	CONSTRAINT [FK_Lender_ProfileStatus] FOREIGN KEY ([StatusId]) REFERENCES [ProfileStatus]([Id]),

)
