CREATE TABLE [dbo].[EmploymentDetail] (
	[ProfileId]             INT	 PRIMARY KEY NOT NULL,
	[EmploymentTypeId]		INT		NULL,
	[EmployerName]          NVARCHAR (50) NULL,
	[EmployerContactNumber] NVARCHAR (50) NULL,
	[EmploymentStartDate]   DATETIME      NULL,
	[EmploymentEndDate]     DATETIME      NULL,
	[GrossMonthlyIncome]    FLOAT (53)    NULL,
	[NetMonthlyIncome]      FLOAT (53)    NULL,
	[EmployerNumber]        NVARCHAR (50) NULL,
	[SalaryDay]             INT      NULL,
	[BillingDay]			INT		 NULL
	CONSTRAINT [FK_EmploymentDetail_EmploymentType] FOREIGN KEY ([EmploymentTypeId]) REFERENCES [EmploymentType]([Id]), 
	CONSTRAINT [FK_EmploymentDetail_ProfileId] FOREIGN KEY ([ProfileId]) REFERENCES [Profile]([Id])
);

