CREATE TABLE [dbo].[provider] (
    [prov_key]                 INT              IDENTITY (1, 1) NOT NULL,
    [prov_discipline_code]     INT              NULL,
    [prov_sub_discipline_key] INT              NULL,
    [prov_title]               VARCHAR (7)      NULL,
    [prov_initials]            VARCHAR (5)      NULL,
    [prov_first_name]          VARCHAR (45)     NULL,
    [prov_middle_name]         VARCHAR (45)     NULL,
    [prov_surname]             VARCHAR (60)     NULL,
    [prov_id_no]               VARCHAR (38)     NULL,
    [prov_id_type_key]         INT              NULL,
    [prov_country_code]        VARCHAR (2)      NULL,
    [prov_gender_code]         VARCHAR (1)      NULL,
    [prov_vat_no]              VARCHAR (15)     NULL,
    [prov_pdi_status_code]     VARCHAR (1)      NULL,
    [prov_hpcsa_no]            VARCHAR (20)     NULL,
    [prov_email]               VARCHAR (50)     NULL,
    [prov_tel_dialling_code]   VARCHAR (5)      NULL,
    [prov_tel_no]              VARCHAR (15)     NULL,
    [prov_fax_no]              VARCHAR (15)     NULL,
    [prov_cell_no]             VARCHAR (15)     NULL,
    [prov_speciality_code]     VARCHAR (3)      NULL,
    [prov_disp_lic_ind]        BIT      NULL,
    [prov_disp_lic_no]         VARCHAR (20)     NULL,
    [prov_no_of_locations]     INT              NULL,
    [prov_registered]          DATETIME         NULL,
    [prov_deregistered]        DATETIME         NULL,
    [modified_dt]              DATETIME         NULL,
    [modified_by_key]          NVARCHAR(200) NULL,
    [registration_complete] BIT NULL, 
    CONSTRAINT [provider_PK] PRIMARY KEY CLUSTERED ([prov_key] ASC)
);

