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.


How did we do?


Powered by HelpDocs (opens in a new tab)