m_account_transfer_details

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
m_account_transfer_standing_instructions.account_transfer_details_id FK_m_standing_instructions_account_transfer_details R
m_account_transfer_transaction.account_transfer_details_id FK_m_account_transfer_transaction_account_detail R
m_loan_topup.account_transfer_details_id m_loan_topup_FK_account_transfer_details_id R
from_office_id int8 19 null
m_office.id FK_m_account_transfer_details_from_office R
to_office_id int8 19 null
m_office.id FK_m_account_transfer_details_to_office R
from_client_id int8 19 √ null
m_client.id FK_m_account_transfer_details_from_client R
to_client_id int8 19 √ null
m_client.id FK_m_account_transfer_details_to_client R
from_savings_account_id int8 19 √ null
m_savings_account.id FK_m_account_transfer_details_from_savings_account R
to_savings_account_id int8 19 √ null
m_savings_account.id FK_m_account_transfer_details_to_savings_account R
from_loan_account_id int8 19 √ null
m_loan.id FK_m_account_transfer_details_from_loan_account R
to_loan_account_id int8 19 √ null
m_loan.id FK_m_account_transfer_details_to_loan_account R
transfer_type int2 5 √ null

Indexes

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