CREATE TABLE [dbo].[patient_contact_numbers] (
    [pt_contact_number_key] INT              IDENTITY (1, 1) NOT NULL,
    [pt_key]                INT              NOT NULL,
    [pt_number]             VARCHAR (20)     NOT NULL,
    [pt_number_type]        VARCHAR (20)     NOT NULL,
    [pt_prefered_number]    BIT              NULL,
    [pt_number_note]        VARCHAR (100)    NULL,
    [modified_dt]           DATETIME         NULL,
    [modified_by_key]       UNIQUEIDENTIFIER NULL,
    CONSTRAINT [patient_contact_numbers_PK] PRIMARY KEY CLUSTERED ([pt_contact_number_key] ASC),
    CONSTRAINT [patient_patient_contact_numbers_FK1] FOREIGN KEY ([pt_key]) REFERENCES [dbo].[patient] ([pt_key])
);

