id customer_id account_type balance interest_rate created_at
id account_id transaction_type amount transaction_date
id customer_id loan_amount interest_rate duration_months start_date
customer_id full_name id_type id_number date_of_birth address phone email created_at
type_id type_name interest_rate min_balance monthly_fee
account_id customer_id type_id account_number current_balance opened_date status last_interest_date branch_id
transaction_id account_id transaction_date amount transaction_type description reference_id created_at
product_id product_name base_interest_rate
loan_id customer_id product_id principal_amount interest_rate start_date end_date status outstanding_principal
payment_id loan_id due_date paid_date installment_amount principal_part interest_part status
entry_id entry_date account_code description debit credit transaction_ref created_at
account_code name account_type
currency_code exchange_rate_to_base updated_at
account_id customer_id ownership_percentage is_primary_holder
customer_address_history4 rows address_id customer_id street_address effective_from effective_to is_current
teller_id user_id branch_id
audit_id action old_address new_address changed_by changed_at
employee_id full_name manager_id role
transaction_id account_id text_date description amount