Android Telephony Message
Tables (6)
MMS (BaseMmsColumns)
- _ID (_id) — long — Primary key — NOT NULL
- THREAD_ID (thread_id) — long — Foreign key → Thread table._ID — NOT NULL
- DATE (date) — long
- DATE_SENT (date_sent) — long
- MESSAGE_BOX (msg_box) — INTEGER
- READ (read) — INTEGER(bool)
- TEXT_ONLY (text_only) — INTEGER(bool)
- SUBJECT (sub) — String
- SUBJECT_CHARSET (sub_cs) — INTEGER
- CONTENT_TYPE (ct_t) — String
- CONTENT_LOCATION (ct_l) — String
- EXPIRY (exp) — long
- MESSAGE_TYPE (m_type) — INTEGER
- STATUS (st) — INTEGER
- SUBSCRIPTION_ID (sub_id) — long
MMS Addr (Addr)
- _ID (_id) — long — Primary key — NOT NULL
- MSG_ID (mid) — long — Foreign key → MMS._ID — NOT NULL
- ADDRESS (address) — String
- TYPE (type) — INTEGER
MMS Part (part)
- _ID (_id) — long — Primary key — NOT NULL
- MSG_ID (mid) — long — Foreign key → MMS._ID — NOT NULL
- CONETNT_TYPE (Field) — String
- TEXT (text) — String
- _DATA (_data) — INTEGER
Recipient (CanonicalAddressColumn)
- _ID (_id) — long — Primary key — NOT NULL
- ADDRESS (address) — String
SMS (TextBasedSmsColumns)
- _ID (_id) — long — Primary key — NOT NULL
- THREAD_ID (thread_id) — long — Foreign key → Thread table._ID — NOT NULL
- _COUNT (_count) — INTEGER
- TYPE (type) — INTEGER
- ADDRESS (address) — String
- READ (read) — INTEGER(bool)
- STATUS (status) — INTEGER
- BODY (body) — String
- SUBSCRIPTION_ID (sub_id) — long
- DATE_SENT (date_sent) — long
- DATE (date) — long
Thread table (ThreadsColumn)
- _ID (_id) — long — Primary key — NOT NULL
- RECIPIIENT_IDS (recipient_ids) — String — Foreign key → Recipient._ID — NOT NULL
- DATE (date) — long
- MESSAGE_COUNT (message_count) — INTEGER
- READ (read) — INTEGER(bool)
- SNIPPET (snippet) — String
- SNIPPET_CHARSET (snippet_charset) — INTEGER
- TYPE (type) — INTEGER
- HAS_ATTACHMENT (has_attachment) — INTEGER
- ARCHIVED (archived) — INTEGER(bool)