m_portfolio_account_associations

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
m_guarantor_funding_details.account_associations_id FK_m_guarantor_fund_details_account_associations_idR
loan_account_id BIGINT 19 √ NULL
m_loan.id account_association_loan_fkR
savings_account_id BIGINT 19 √ NULL
m_savings_account.id account_association_savings_fkR
linked_loan_account_id BIGINT 19 √ NULL
m_loan.id linked_loan_fkR
linked_savings_account_id BIGINT 19 √ NULL
m_savings_account.id linked_savings_fkR
association_type_enum SMALLINT 5 1
is_active BIT 1 b'1'

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
account_association_loan_fk Performance Asc loan_account_id
account_association_savings_fk Performance Asc savings_account_id
linked_loan_fk Performance Asc linked_loan_account_id
linked_savings_fk Performance Asc linked_savings_account_id

Relationships

Close relationships within degrees of separation