android常用数据库字段描述
1.短信数据库
StringstrUriInbox="content://sms";
UriuriSms=Uri.parse(strUriInbox);
Cursorc_groups=managedQuery(uriSms,newString[]{"date","person"},select,null,"dateDESC");
strColumnName=_idstrColumnValue=48//短消息序号
strColumnName=thread_idstrColumnValue=16//对话的序号（conversation）
strColumnName=addressstrColumnValue=+8613411884805//发件人地址，手机号
strColumnName=personstrColumnValue=null//发件人，返回一个数字就是联系人列表里的序号，陌生人为null
strColumnName=datestrColumnValue=1256539465022//日期long型，想得到具体日期自己转换吧！
strColumnName=protocolstrColumnValue=0//协议
strColumnName=readstrColumnValue=1//是否阅读
strColumnName=statusstrColumnValue=-1//状态
strColumnName=typestrColumnValue=1//类型1是接收到的，2是发出的
strColumnName=reply_path_presentstrColumnValue=0//
strColumnName=subjectstrColumnValue=null//主题
strColumnName=bodystrColumnValue=您好//短消息内容
strColumnName=service_centerstrColumnValue=+8613800755500//短信服务中心号码编号，可以得知该短信是从哪里发过来的见下表
2.联系人数据库
strColumnName=_sync_idstrColumnValue=null
strColumnName=primary_organizationstrColumnValue=null
strColumnName=notesstrColumnValue=null
strColumnName=primary_phonestrColumnValue=1
strColumnName=statusstrColumnValue=null
strColumnName=im_handlestrColumnValue=null
strColumnName=_sync_local_idstrColumnValue=null
strColumnName=im_accountstrColumnValue=null
strColumnName=_sync_timestrColumnValue=null
strColumnName=im_protocolstrColumnValue=null
strColumnName=modestrColumnValue=null
strColumnName=labelstrColumnValue=null
strColumnName=times_contactedstrColumnValue=0
strColumnName=namestrColumnValue=é??è?3
strColumnName=send_to_voicemailstrColumnValue=null
strColumnName=primary_emailstrColumnValue=null
strColumnName=custom_ringtonestrColumnValue=null
strColumnName=sort_stringstrColumnValue=í?¤í2?í??ío3à?
strColumnName=_sync_versionstrColumnValue=null
strColumnName=last_time_contactedstrColumnValue=null
strColumnName=_sync_accountstrColumnValue=null
strColumnName=display_namestrColumnValue=é??è?3
strColumnName=number_keystrColumnValue=77681111831
strColumnName=numberstrColumnValue=13811118677
strColumnName=phonetic_namestrColumnValue=null
strColumnName=_idstrColumnValue=1
strColumnName=typestrColumnValue=2
strColumnName=_sync_dirtystrColumnValue=1
strColumnName=starredstrColumnValue=0
4.其他数据库
//AvailableUristring
content://contacts/people//本地联系人列表信息
content://contacts/phones//本地联系人列表信息
content://call_log/calls///本地通话记录
content://mms彩信
content://mms-sms/threadID
content://mms-sms/conversations
content://mms-sms/messages/byphone
content://mms-sms/undelivered
content://mms-sms/draft

StringstrUriInbox="content://sms/inbox";//SMS_INBOX:1
StringstrUriFailed="content://sms/failed";//SMS_FAILED:2
StringstrUriQueued="content://sms/queued";//SMS_QUEUED:3
StringstrUriSent="content://sms/sent";//SMS_SENT:4
StringstrUriDraft="content://sms/draft";//SMS_DRAFT:5
StringstrUriOutbox="content://sms/outbox";//SMS_OUTBOX:6
StringstrUriUndelivered="content://sms/undelivered";//SMS_UNDELIVERED
StringstrUriAll="content://sms/all";//SMS_ALL
StringstrUriConversations="content://sms/conversations";//youcandeleteoneconversationbythread_id
StringstrUriAll="content://sms"//youcandeleteonemessageby_id

Android查询短信数据库