m_account_transfer_transaction

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
account_transfer_details_id int8 19 null
m_account_transfer_details.id FK_m_account_transfer_transaction_account_detail R
from_savings_transaction_id int8 19 √ null
m_savings_account_transaction.id FK_m_account_transfer_transaction_from_m_savings_transaction R
from_loan_transaction_id int8 19 √ null
m_loan_transaction.id FK_m_account_transfer_transaction_from_m_loan_transaction R
to_savings_transaction_id int8 19 √ null
m_savings_account_transaction.id FK_m_account_transfer_transaction_to_m_savings_transaction R
to_loan_transaction_id int8 19 √ null
m_loan_transaction.id FK_m_account_transfer_transaction_to_m_loan_transaction R
is_reversed bool 1 null
transaction_date date 13 null
currency_code varchar 3 null
currency_digits int2 5 null
currency_multiplesof int2 5 √ null
amount numeric 19,6 null
description varchar 200 null
payment_detail_id int8 19 √ null
m_payment_detail.id FK_m_account_transfer_transaction_m_payment_detail R

Indexes

Constraint Name Type Sort Column(s)
m_account_transfer_transaction_pkey Primary key Asc id
FK_m_account_transfer_transaction_account_detail Performance Asc account_transfer_details_id
FK_m_account_transfer_transaction_from_m_loan_transaction Performance Asc from_loan_transaction_id
FK_m_account_transfer_transaction_from_m_savings_transaction Performance Asc from_savings_transaction_id
FK_m_account_transfer_transaction_m_payment_detail Performance Asc payment_detail_id
FK_m_account_transfer_transaction_to_m_loan_transaction Performance Asc to_loan_transaction_id
FK_m_account_transfer_transaction_to_m_savings_transaction Performance Asc to_savings_transaction_id

Relationships

Close relationships within degrees of separation