Sheet cc10_batchcontacts save the target phone number, sender’s account, and send status.
batchcontact_archive_id,Relate the data id of sheet cc10_batchcontact_archives to batchcontact_archive_id and the latter is for save the specific text of SMS.
target,The phone number of receivers.
status,The send status of SMS.
The original status is “new”, means a new one to be sent. And you system needs SMS like this and send them.
Once the SMS is being sending, please change the value into “pending” in the system.
When it is sent, change the status into “error”, “failed” or “success” according to the third party return value.
schedulertime,Preset the sending time, “0000-00-00 00:00:00”maens sending right now. And you can also set the sending time. The system would search the data field that is less than this time.
contacttime,The time to push the SMS to the third party. You can update the status field and the return value after the latter is been returned by the third party.
creby,The account of the SMS creator.
created,The time of the SMS’s creation.
error_msg,Add the reason here when the message sending result in failure or meet error.
responsenote,The reply message from the receiver, provided by the third party. When the system received the message, you can update in this field.