View: core.bank_account_view

 CREATE OR REPLACE VIEW core.bank_account_view
 AS
 SELECT accounts.account_id,
    accounts.account_number,
    accounts.account_name,
    users.user_name AS maintained_by,
    bank_accounts.bank_name,
    bank_accounts.bank_branch,
    bank_accounts.bank_contact_number,
    bank_accounts.bank_address,
    bank_accounts.bank_account_number,
    bank_accounts.bank_account_type,
    bank_accounts.relationship_officer_name AS relation_officer
   FROM core.bank_accounts
   JOIN core.accounts ON accounts.account_id = bank_accounts.account_id
   JOIN office.users ON bank_accounts.maintained_by_user_id = users.user_id;