Database – Loan SMS Queue Item Entity (loan_sms_queue_item_entity)
Represents a loan in an SMS queue.
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 | ||
template_id | int(11) | Associated template ID | ||
template_type | char(64) | Template type | ||
primary_customer_primary_phone | tinyint(1) | Whether or not to send to primary customer's primary phone | 1 - yes, 0 - no | |
primary_customer_secondary_phone | tinyint(1) | Whether or not to send to primary customer's secondary phone | 1 - yes, 0 - no | |
secondary_customer_primary_phone | tinyint(1) | Whether or not to send to secondary customer's primary phone | 1 - yes, 0 - no | |
secondary_customer_secondary_phone | tinyint(1) | Whether or not to send to secondary customer's secondary phone | 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 |