Database – SBT Message Log (sbt_message_log)
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 |