Database – SBT Message Log (sbt_message_log)
Holds a log of SBT messaging
Column | Data Type | Column Info | Value Notes | Other |
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_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 |