Android短信Messaging数据库字段分析

字段分析"/>

Android短信Messaging数据库字段分析

数据库提取

• 在 Android Studio 中点击 Device File Explorer按钮。
• 选择/data/data/com.xxx.xxx/databases/bugle_db右键 Save As 保存到本地。
• 注：com.xxx.xxx 为当前自己的工程目录

数据库说明

• Messaging创建了数据库bugle_db用于同步mms/sms.db的数据，短信查询时直接从bugle_db数据库进行查询。

数据库内表和视图：

• conversation_list_view：主界面的视图，是把conversations、messages和participants三个表的数据糅合起来的视图，方便主界面的各项数据显示。
• conversation_participants：记录conversation和它的联系人participatant的关联。
• messages：记录每一条短彩信的数据，包括远程uri和已读状态等。
• parts：记录短彩信的实际内容，比如文本或者图片uri，跟messages关联能得到完整的短彩信数据。

数据库中数据表有： conversations、messages、parts、participants、conversation_participants等。

视图有： draft_parts_view 、coversation_image_parts_view 、conversation_list_view。

数据表

数据表 conversation_participants

数据表 conversations

数据表 messages

数据表 parts

数据表 participants

视图

conversation_list_view
查询对话列表

SELECT conversations._id AS _id,conversations.name AS name,conversations.current_self_id AS current_self_id,conversations.archive_status AS archive_status,messages.read AS read,conversations.icon AS icon,conversations.participant_contact_id AS participant_contact_id,conversations.participant_lookup_key AS participant_lookup_key,conversations.participant_normalized_destination AS participant_normalized_destination,conversations.sort_timestamp AS sort_timestamp,conversations.show_draft AS show_draft,conversations.draft_snippet_text AS draft_snippet_text,conversations.draft_preview_uri AS draft_preview_uri,conversations.draft_subject_text AS draft_subject_text,conversations.draft_preview_content_type AS draft_preview_content_type,conversations.preview_uri AS preview_uri,conversations.preview_content_type AS preview_content_type,conversations.participant_count AS participant_count,conversations.notification_enabled AS notification_enabled,conversations.notification_sound_uri AS notification_sound_uri,conversations.notification_vibration AS notification_vibration,conversations.include_email_addr AS include_email_addr,messages.message_status AS message_status,messages.raw_status AS raw_status,messages._id AS message_id,participants.first_name AS snippet_sender_first_name,participants.display_destination AS snippet_sender_display_destination,conversations.IS_ENTERPRISE AS IS_ENTERPRISE,conversations.is_top AS is_top,conversations.snippet_text AS snippet_text,conversations.subject_text AS subject_textFROM conversationsLEFT JOINmessages ON (conversations.latest_message_id = messages._id) LEFT JOINparticipants ON (messages.sender_id = participants._id) ORDER BY conversations.sort_timestamp DESC;

coversation_image_parts_view
查询图片列表

SELECT messages.conversation_id AS conversation_id,parts.uri AS uri,participants.full_name AS _display_name,parts.uri AS contentUri,NULL AS thumbnailUri,parts.content_type AS contentType,participants.display_destination AS display_destination,messages.received_timestamp AS received_timestamp,messages.message_status AS message_statusFROM messagesLEFT JOINparts ON (messages._id = parts.message_id) LEFT JOINparticipants ON (messages.sender_id = participants._id) WHERE parts.content_type LIKE image/%ORDER BY messages.received_timestamp ASC,parts._id ASC;

draft_parts_view
查询草稿附件

SELECT parts._id AS _id,parts.message_id AS message_id,parts.text AS text,parts.uri AS uri,parts.content_type AS content_type,parts.width AS width,parts.height AS height,messages.conversation_id AS conversation_idFROM messagesLEFT JOINparts ON (messages._id = parts.message_id) WHERE messages.message_status = 3;

参考：
        安卓短信Messaging数据库表格整理与字段分析