Table: Loan SMS Queue Item Entity

Table: Loan SMS Queue Item Entity

Represents a loan in an SMS queue.

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
template_idint(11)Associated template ID
template_typechar(64)Template type
primary_customer_primary_phonetinyint(1)Whether or not to send to primary customer's primary phone1 - yes, 0 - no
primary_customer_secondary_phonetinyint(1)Whether or not to send to primary customer's secondary phone1 - yes, 0 - no
secondary_customer_primary_phonetinyint(1)Whether or not to send to secondary customer's primary phone1 - yes, 0 - no
secondary_customer_secondary_phonetinyint(1)Whether or not to send to secondary customer's secondary phone1 - 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

< Back to List