m_account_transfer_details

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_account_transfer_standing_instructions.account_transfer_details_id FK_m_standing_instructions_account_transfer_detailsR
m_account_transfer_transaction.account_transfer_details_id FK_m_account_transfer_transaction_account_detailR
m_loan_topup.account_transfer_details_id m_loan_topup_FK_account_transfer_details_idR
from_office_id BIGINT 19 null
m_office.id FK_m_account_transfer_details_from_officeR
to_office_id BIGINT 19 null
m_office.id FK_m_account_transfer_details_to_officeR
from_client_id BIGINT 19 √ NULL
m_client.id FK_m_account_transfer_details_from_clientR
to_client_id BIGINT 19 √ NULL
m_client.id FK_m_account_transfer_details_to_clientR
from_savings_account_id BIGINT 19 √ NULL
m_savings_account.id FK_m_account_transfer_details_from_savings_accountR
to_savings_account_id BIGINT 19 √ NULL
m_savings_account.id FK_m_account_transfer_details_to_savings_accountR
from_loan_account_id BIGINT 19 √ NULL
m_loan.id FK_m_account_transfer_details_from_loan_accountR
to_loan_account_id BIGINT 19 √ NULL
m_loan.id FK_m_account_transfer_details_to_loan_accountR
transfer_type SMALLINT 5 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_m_account_transfer_details_from_client Performance Asc from_client_id
FK_m_account_transfer_details_from_loan_account Performance Asc from_loan_account_id
FK_m_account_transfer_details_from_office Performance Asc from_office_id
FK_m_account_transfer_details_from_savings_account Performance Asc from_savings_account_id
FK_m_account_transfer_details_to_client Performance Asc to_client_id
FK_m_account_transfer_details_to_loan_account Performance Asc to_loan_account_id
FK_m_account_transfer_details_to_office Performance Asc to_office_id
FK_m_account_transfer_details_to_savings_account Performance Asc to_savings_account_id

Relationships

Close relationships within degrees of separation