Android Address Book database detailed

View mobile phone Library Export This file actually uses four sheets,

Note:

1.contacts Table

_ID: The ID of the table, mainly used for other tables through the ID in the Contacts table can be found in the corresponding data.
Display_name: Contact Name
PHOTO_ID: The ID of the avatar, if the contact picture is not set, this field is empty
times_contacted: Number of call logs
Last_time_contacted: Last Call time
Lookup: is a persistent store because the user may rename the child but it can't change the lookup

2.data table

RAW_CONTACT_ID: The relative data in the Raw_contact table can be found by raw_contact_id.

Data1 to DATA15 here is a contact person's information contact name contact Phone number Email memo and so on.

3.PHONE_LOOK_UP table

data_id: The relative data in the Datat table can be found through data_id.
raw_contact_id: The relative data in the Raw_contact_ table can be found through raw_contact_id.
Normalized_number: This field is more interesting, it is the reverse order of each phone number.

4.raw_contact table

version: Revision number, for listening for changes
deleted: Delete flag, 0 is the default 1 indicates that this row of data has been deleted
Display_name: Contact name
Last_time_contacts: Last contact time