ContactsContract.ContactsColumns

CONTACT_LAST_UPDATED_TIMESTAMP

String CONTACT_LAST_UPDATED_TIMESTAMP

Timestamp (milliseconds since epoch) of when this contact was last updated. This includes updates to all data associated with this contact including raw contacts. Any modification (including deletes and inserts) of underlying contact data are also reflected in this timestamp.

Constant Value: "contact_last_updated_timestamp"

DISPLAY_NAME

String DISPLAY_NAME

The display name for the contact.

Type: TEXT

Constant Value: "display_name"

HAS_PHONE_NUMBER

String HAS_PHONE_NUMBER

An indicator of whether this contact has at least one phone number. "1" if there is at least one phone number, "0" otherwise.

Type: INTEGER

Constant Value: "has_phone_number"

IN_DEFAULT_DIRECTORY

String IN_DEFAULT_DIRECTORY

Flag that reflects whether the contact exists inside the default directory. Ie, whether the contact is designed to only be visible outside search.

Constant Value: "in_default_directory"

IN_VISIBLE_GROUP

String IN_VISIBLE_GROUP

Flag that reflects the GROUP_VISIBLE state of any ContactsContract.CommonDataKinds.GroupMembership for this contact.

Constant Value: "in_visible_group"

IS_USER_PROFILE

String IS_USER_PROFILE

Flag that reflects whether this contact represents the user's personal profile entry.

Constant Value: "is_user_profile"

LOOKUP_KEY

String LOOKUP_KEY

An opaque value that contains hints on how to find the contact if its row id changed as a result of a sync or aggregation.

Constant Value: "lookup"

NAME_RAW_CONTACT_ID

String NAME_RAW_CONTACT_ID

Reference to the row in the RawContacts table holding the contact name.

Type: INTEGER REFERENCES raw_contacts(_id)

Constant Value: "name_raw_contact_id"

PHOTO_FILE_ID

String PHOTO_FILE_ID

Photo file ID of the full-size photo. If present, this will be used to populate PHOTO_URI. The ID can also be used with CONTENT_URI to create a URI to the photo. If this is present, PHOTO_ID is also guaranteed to be populated.

Type: INTEGER

Constant Value: "photo_file_id"

PHOTO_ID

String PHOTO_ID

Reference to the row in the data table holding the photo. A photo can be referred to either by ID (this field) or by URI (see PHOTO_THUMBNAIL_URI and PHOTO_URI). If PHOTO_ID is null, consult PHOTO_URI or PHOTO_THUMBNAIL_URI, which is a more generic mechanism for referencing the contact photo, especially for contacts returned by non-local directories (see ContactsContract.Directory).

Type: INTEGER REFERENCES data(_id)

Constant Value: "photo_id"

PHOTO_THUMBNAIL_URI

String PHOTO_THUMBNAIL_URI

A URI that can be used to retrieve a thumbnail of the contact's photo. A photo can be referred to either by a URI (this field or PHOTO_URI) or by ID (see PHOTO_ID). If PHOTO_ID is not null, PHOTO_URI and PHOTO_THUMBNAIL_URI shall not be null (but not necessarily vice versa). If the content provider does not differentiate between full-size photos and thumbnail photos, PHOTO_THUMBNAIL_URI and PHOTO_URI can contain the same value, but either both shall be null or both not null.

Type: TEXT

Constant Value: "photo_thumb_uri"

PHOTO_URI

String PHOTO_URI

A URI that can be used to retrieve the contact's full-size photo. If PHOTO_FILE_ID is not null, this will be populated with a URI based off CONTENT_URI. Otherwise, this will be populated with the same value as PHOTO_THUMBNAIL_URI. A photo can be referred to either by a URI (this field) or by ID (see PHOTO_ID). If either PHOTO_FILE_ID or PHOTO_ID is not null, PHOTO_URI and PHOTO_THUMBNAIL_URI shall not be null (but not necessarily vice versa). Thus using PHOTO_URI is a more robust method of retrieving contact photos.

Type: TEXT

Constant Value: "photo_uri"