CREATE TABLE [dbo].[prov_bank_details] (
    [prov_bank_details_key] INT IDENTITY (1, 1) NOT NULL,
    [bank_key]       NVARCHAR (10)  NULL,
    [branch_key]     NVARCHAR (10)  NULL,
    [account_number] NVARCHAR (50)  NULL,
    [account_name]   NVARCHAR (100) NULL,
    [bank_name]      NVARCHAR (100) NULL,
    [branch_name]    NVARCHAR (100) NULL,
    [prov_key] INT NULL, 
    CONSTRAINT [PK_prov_bank_details] PRIMARY KEY ([prov_bank_details_key]), 
    CONSTRAINT [FK_prov_bank_details_provider] FOREIGN KEY ([prov_key]) REFERENCES [provider]([prov_key]) 
);