CREATE TABLE [dbo].[NextOfKin]
(
	[ProfileId] INT NOT NULL PRIMARY KEY,
	[Name] NVARCHAR(100) NULL,
	[RelationshipType] NVARCHAR(100) NULL,
	[ContactNumber] NVARCHAR(20) NULL,
	[Income] FLOAT NULL, 
	CONSTRAINT [FK_NextOfKin_Profile] FOREIGN KEY ([ProfileId]) REFERENCES [Profile]([Id])
)
