09:37:09.817 LL_I D msgstore/checkhealth/journal/delete false 09:37:09.785 LL_I D media-state-manager/refresh-media-state/writable-media
09:37:09.782 LL_I D statistics Text Messages: 59 sent, 82 received / Media Messages: 1 sent (0 bytes), 0 received (9850158 bytes) / Offline Messages: 81 received (19522 msec average delay) / Message Service: 116075 bytes sent, 211729 bytes received / Voip Calls: 1 outgoing calls, 0 incoming calls, 2492 bytes sent, 1530 bytes received / Google Drive: 0 bytes sent, 0 bytes received / Roaming: 1524 bytes sent, 1826 bytes received / Total Data: 118567 bytes sent, 10063417 bytes received
09:37:09.772 LL_I D password file missing or unreadable 09:37:09.758 LL_I D missedcallnotification/update cancel true 09:37:09.757 LL_I D missedcallnotification/init count:0 timestamp:0 log file) and backup copies of program operation logs (files with the names in the format whatsapp-yyyy-mm-dd.1.log.gz). whatsapp / files / Logs /.Ĭontains a program operation log (the whatsapp. j extension, but are actually JPEG (JPG) files.Ĭontains graphics files: the profile picture and its thumbnail set as an avatar by the account owner.
Quoted_row_id Unknown, usually contains the value ‘0’ Participant_hash Used in geodata transmittal Recipient_count Number of recipients (broadcast message) Media_url URL of the transmitted file (when media_wa_type= Timestamp Contains a timestamp in the Unix Epoch Time (ms) format, the value is taken from the device clock Need_push ‘2’ if broadcast message, ‘0’ otherwiseĭata Message content when media_wa_type = ‘0’ ‘6’=control message, ‘13’=message opened by the recipient (read) Status Message status: ‘0’=received, ‘4’=waiting on the Key_from_me Message direction: ‘0’=incoming, ‘1’=outgoing Key_remote_jid WhatsApp ID of the communication partner Title Title (Mr/Ms/Mrs as set in the contact's profile) Nickname WhatsApp nickname of the contact (as set in their profile)Ĭompany Company (as set in the contact’s profile)
Sort_name Name of the contact used in sorting operations Wa_name WhatsApp name of the contact (as set in their profile) Given_name The field value is the same as in display_name for each contact Photo_id_timestamp Contains a timestamp in the Unix Epoch Time (ms) format Thumb_ts Contains a timestamp in the Unix Epoch Time format Photo_ts Contains a timestamp in the Unix Epoch Time format Unseen_msg_count Number of messages sent by the contact that have been Phone_label Label associated with the phone number Raw_contact_id Sequence number of the contact Number Phone number associated with the contact Status_timestamp Contains a timestamp in the Unix Epoch Time (ms) format Status Text in the status line of the contact Is_whatsapp_user Contains ’1’ if the contact corresponds to an actual WhatsApp user, ’0’ otherwise Jid WhatsApp ID of the contact (a string structured where ’x’ is the phone number of the _id Sequence number of the record (set by SQLite)