CREATE TABLE [dbo].[Borrower]
(
	[Id] INT NOT NULL PRIMARY KEY, 
	[BorrowerNumber]    NVARCHAR (50) NOT NULL, 
	[ProfileTypeId]   INT           NOT NULL,
	--[IsActive]		  BIT			NOT NULL DEFAULT(0),
	[StatusId] INT NOT NULL DEFAULT 1, 
	CONSTRAINT [FK_Borrower_ProfileStatus] FOREIGN KEY ([StatusId]) REFERENCES [ProfileStatus]([Id]),

    CONSTRAINT [FK_Borrower_Profile] FOREIGN KEY ([Id]) REFERENCES [Profile]([Id]), 
    CONSTRAINT [FK_Borrower_ProfileType] FOREIGN KEY ([ProfileTypeId]) REFERENCES [ProfileType]([Id])
)
