m_loan_amortization_allocation_mapping

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
loan_id int8 19 null
m_loan.id FK_laam_loan_id R
base_loan_transaction_id int8 19 null
m_loan_transaction.id FK_laam_base_transaction_id R
date date 13 null
amortization_loan_transaction_id int8 19 null
m_loan_transaction.id FK_laam_amortization_transaction_id R
amortization_type varchar 20 null
amount numeric 19,6 null
created_by int8 19 √ null
m_appuser.id FK_laam_created_by R
created_on_utc timestamptz 35,6 √ null
last_modified_by int8 19 √ null
m_appuser.id FK_laam_last_modified_by R
last_modified_on_utc timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
pk_m_loan_amortization_allocation_mapping Primary key Asc id
idx_m_loan_am_all_map_amort_loan_txn_id Performance Asc amortization_loan_transaction_id
idx_m_loan_am_all_map_base_loan_id Performance Asc loan_id
idx_m_loan_am_all_map_base_loan_txn_id Performance Asc base_loan_transaction_id

Relationships

Close relationships within degrees of separation