| UpdatedInDB |
timestamp |
|
|
|
|
| InsertIntoDB |
timestamp |
|
|
|
|
| SendingDateTime |
timestamp |
|
|
|
|
| DeliveryDateTime |
timestamp |
|
|
|
|
| Text |
text |
utf8_general_ci |
|
|
|
| DestinationNumber |
varchar(20) |
utf8_general_ci |
|
|
|
| Coding |
enum('Default_No_Compression', 'Unicode_No_Compression', '8bit', 'Default_Compression', 'Unicode_Compression') |
utf8_general_ci |
|
|
|
| UDH |
text |
utf8_general_ci |
|
|
|
| SMSCNumber |
varchar(20) |
utf8_general_ci |
|
|
|
| Class |
int(11) |
|
|
|
|
| TextDecoded |
text |
utf8_general_ci |
|
|
|
| ID |
int(10) |
|
|
|
|
| SenderID |
varchar(255) |
utf8_general_ci |
|
|
|
| SequencePosition |
int(11) |
|
|
|
|
| Status |
enum('SendingOK', 'SendingOKNoReport', 'SendingError', 'DeliveryOK', 'DeliveryFailed', 'DeliveryPending', 'DeliveryUnknown', 'Error') |
utf8_general_ci |
|
|
|
| StatusError |
int(11) |
|
|
|
|
| TPMR |
int(11) |
|
|
|
|
| RelativeValidity |
int(11) |
|
|
|
|
| CreatorID |
text |
utf8_general_ci |
|
|
|
| CollectionLoanItem_id |
double |
|
|
|
|