loan_promise_entity - Loan Promise info

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)

Attched note

amount

decimal(6,2)

promise amount

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


How did we do?


Powered by HelpDocs (opens in a new tab)