Table: Loan Promise info

Table: Loan Promise info

Holds promise information for a loan

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
loan_idint(11)The id of the associated loan account
subjectvarchar(100)Promise subject
notevarchar(1000)Attched note
amountdecimal(6,2)promise amount
fulfilledtinyint(1)whether or not it has been fulfileed1 - yes, 0 - no
due_datedatePromise due date
fulfillment_datedatePromise fullfilment date
typevarchar(100)Loan Promise typeloanpromise.type.*
activetinyint(1)Whether or not the entity is active1 - yes, 0 - no
deletedtinyint(1)Whether or not the entity was deleted1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
logged_byvarchar(255)Who the promise was logged by
fulfilled_datedatetimeWhen the promise was marked as fulfilled
fulfilled_byvarchar(255)Who marked the promise as fulfilled

< Back to List