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)