m_account_transfer_transaction

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
account_transfer_details_id BIGINT 19 null
m_account_transfer_details.id FK_m_account_transfer_transaction_account_detailR
from_savings_transaction_id BIGINT 19 √ NULL
m_savings_account_transaction.id FK_m_account_transfer_transaction_from_m_savings_transactionR
from_loan_transaction_id BIGINT 19 √ NULL
m_loan_transaction.id FK_m_account_transfer_transaction_from_m_loan_transactionR
to_savings_transaction_id BIGINT 19 √ NULL
m_savings_account_transaction.id FK_m_account_transfer_transaction_to_m_savings_transactionR
to_loan_transaction_id BIGINT 19 √ NULL
m_loan_transaction.id FK_m_account_transfer_transaction_to_m_loan_transactionR
is_reversed BIT 1 null
transaction_date DATE 10 null
currency_code VARCHAR 3 null
currency_digits SMALLINT 5 null
currency_multiplesof SMALLINT 5 √ NULL
amount DECIMAL 19,6 null
description VARCHAR 200 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY 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_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