CREATE TABLE [dbo].[patient_funder]
(
	[pt_funder_key] INT NOT NULL IDENTITY (1,1) PRIMARY KEY, 
    [pt_key] INT NOT NULL, 
    [mem_no] NVARCHAR(50) NULL, 
    [mem_dep_no] NVARCHAR(2) NULL,
    [scheme_opt_key] NVARCHAR(10) NOT NULL, 
    [mem_first_name] NVARCHAR(50) NOT NULL, 
    [mem_surname] NVARCHAR(50) NOT NULL, 
    [mem_initials] NVARCHAR(5) NULL, 
	[mem_email] NVARCHAR(50) NULL,
	[mem_country_code] VARCHAR(2) NULL,
    [mem_id_no] NVARCHAR(13) NOT NULL, 
    [modified_dt] DATETIME NULL, 
    [modified_by] UNIQUEIDENTIFIER NULL
)
