Database – Loan Promise Info (loan_promise_entity)
Description
This table holds information for promises made on a loan.
Column | Data Type | Column Info | Value Notes |
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 it has been fulfilled | 1 - yes, 0 - no |
due_date | date | Promise due date | |
fulfillment_date | date | Promise fulfillment date | |
type | varchar(100) | Loan Promise type | loanpromise.type.* |
active | tinyint(1) | Whether the entity is active | 1 - yes, 0 - no |
deleted | tinyint(1) | Whether 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 | When the promise was logged. |