Database – Loan Sub Status Entity (loan_sub_status_entity)
Description
Loan sub-status information.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(255) | The name/title of the entity instance | ||
color | char(32) | |||
rule | text | |||
parent | int(11) | parent status id | ||
late_fees | tinyint(1) | Whether or not late fees are enabled | 1 - yes, 0 - no | |
email_enroll | tinyint(1) | whether or not emails are enabled | 1 - yes, 0 - no | |
web_access | tinyint(1) | Whether or not web access is active | 1 - yes, 0 - no | |
sms_enroll | tinyint(1) | whether or not sms is enabled | 1 - yes, 0 - no | |
display_order | int(11) | Sort order used when displaying on the UI | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
lastUpdated | timestamp | Timestamp of when the entity was last updated |