CREATE TABLE [dbo].[patient] (
    [pt_key]                 INT              IDENTITY (1, 1) NOT NULL,
    [pt_external_reference]  NVARCHAR (50)    NULL,
    [pt_id_no]               NVARCHAR (38)    NULL,
    [pt_passport_country_cd] NVARCHAR (3)     NULL,
    [pt_title]               NVARCHAR (10)    NULL,
    [pt_full_name]           NVARCHAR (100)   NULL,
    [pt_first_name]          NVARCHAR (100)   NULL,
    [pt_middle_name]         NVARCHAR (100)   NULL,
    [pt_surname]             NVARCHAR (100)   NULL,
    [pt_initials]            NVARCHAR (5)     NULL,
    [pt_gender]              NVARCHAR (1)     NULL,
    [pt_birth_dt]            DATE             NULL,
    [pt_deceased_dt]         DATE             NULL,
    [pt_deceased_ind]        BIT              NULL,
    [pt_pdi_status_cd]       CHAR (1)         default 'Z' NOT NULL,
    [pt_email]               NVARCHAR (100)   NULL,
	[pt_tel_no]              NVARCHAR (15)    NULL,
	[pt_mobile_no]           NVARCHAR (15)    NULL,
    --[mem_no]                 NVARCHAR (50)    NULL,
    --[mem_dep_no]             CHAR (2)         NULL,
    --[scheme_opt_key]         NVARCHAR (10)    NULL,
    [modified_dt]            DATETIME         NULL,
    [modified_by_key]        UNIQUEIDENTIFIER NULL,
    [pt_is_deleted]          BIT              NULL default 0,
    [pt_passport_no]         NVARCHAR (20)    NULL,
    CONSTRAINT [patient_PK] PRIMARY KEY CLUSTERED ([pt_key] ASC)
);

