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


How did we do?


Powered by HelpDocs (opens in a new tab)