Database – SBT Message Log (sbt_message_log)
Updated 1 month ago
Description
This table holds records of SBT messaging.
Table Fields
Feld | Data Type | Column Info | Value Notes |
id | int(11) | The id of the entity | |
customer_id | int(11) | ID for the customer | |
customer_phone_id | int(11) | associated customer phone id | |
loan_id | int(11) | The id of the associated loan account | |
loan_type | varchar(100) | The loan type | Default is set to: Entity.Loan |
loan_display_id | char(50) | associated display id | |
phone | char(20) | Phone number text was sent to | |
outbound | tinyint(1) | Whether or not was outbound | 1 - yes, 0 - no |
inbound | tinyint(1) | Whether or not was inbound | 1 - yes, 0 - no |
status | int(11) | Status code of the entity | |
status_text | varchar(255) | status text | |
time | datetime | time of message | |
type | char(20) | Message type | |
template | int(11) | report template | |
message | varchar(1000) | sms message | |
sbt_tx_ticket | varchar(255) | sbt transaction ticket | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |
lastUpdated | timestamp | Timestamp of when the entity was last updated |