m_loanproduct_provisioning_entry

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
history_id BIGINT 19 null
m_provisioning_history.id m_loanproduct_provisioning_entry_ibfk_1R
criteria_id BIGINT 19 null
m_provisioning_criteria.id m_loanproduct_provisioning_entry_ibfk_2R
currency_code VARCHAR 3 null
office_id BIGINT 19 null
m_office.id m_loanproduct_provisioning_entry_ibfk_3R
product_id BIGINT 19 null
m_product_loan.id m_loanproduct_provisioning_entry_ibfk_4R
category_id BIGINT 19 null
m_provision_category.id m_loanproduct_provisioning_entry_ibfk_5R
overdue_in_days BIGINT 19 √ 0
reseve_amount DECIMAL 20,6 √ 0.000000
liability_account BIGINT 19 √ NULL
acc_gl_account.id m_loanproduct_provisioning_entry_ibfk_6R
expense_account BIGINT 19 √ NULL
acc_gl_account.id m_loanproduct_provisioning_entry_ibfk_7R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
category_id Performance Asc category_id
expense_account Performance Asc expense_account
fk_loanproduct_provisioning_entry_criteria Performance Asc criteria_id
history_id Performance Asc history_id
loanproduct_provisioning_entry_liability_account Performance Asc liability_account
loanproduct_provisioning_entry_office_id Performance Asc office_id
loanproduct_provisioning_entry_product_id Performance Asc product_id

Relationships

Close relationships within degrees of separation