Database – Loan Promise Info (loan_promise_entity)
Description
Holds promise information for a loan
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
loan_id | int(11) | The id of the associated loan account | ||
subject | varchar(100) | Promise subject | ||
note | varchar(1000) | Attached note | ||
amount | decimal(8,2) | promise amount | Default 0.00, not null | |
fulfilled | tinyint(1) | whether or not it has been fulfileed | 1 - yes, 0 - no | |
due_date | date | Promise due date | ||
fulfillment_date | date | Promise fullfilment date | ||
type | varchar(100) | Loan Promise type | loanpromise.type.* | |
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 | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
logged_by | varchar(255) | Who the promise was logged by | ||
fulfilled_date | datetime | When the promise was marked as fulfilled | ||
fulfilled_by | varchar(255) | Who marked the promise as fulfilled | ||
logged_date | datetime |