call_history.db is an SQLite 3 database file which contains the call history from MobilePhone.app on iOS.
In the folder
/var/wireless/Library/CallHistory the file
call_history.db is located.
The iTunes Backup filename of
call_history.db SQLite 3 database has the following tables:
All date fields is shown as number of seconds since Jan 1st, 2001.
This is general-purpose table to store some configuration values.
These values are stored in the table:
|call_history_limit||100||Sets the limit on the number of entries in the call history, increasing this value has no effect however.|
|timer_lifetime||431337||A call time counter which counts the number of seconds for all phone calls ever made (both incoming and outgoing)|
|data_up_all||1337.72234523||A data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), since last statistics reset.|
|data_down_all||31337.56235627||A data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), since last statistics reset.|
|data_up_lifetime||1337.72234523||A lifetime data counter which counts the number of megabytes sent via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.|
|data_down_lifetime||31337.56235627||A lifetime data counter which counts the number of megabytes received via Cellular Network Data (i.e. not WiFi), doesn't get reset on a statistics reset.|
|_UniqueIdentifier||CAFEBABE-F00D-DEAD-BEEF-31337ABFDEDA||An unique identifier for this phone|
|_ClientVersion||11||The version of this database
|timer_last||1337||The length of the last phone call (in seconds)|
|timer_outgoing||31337||The total length of all outgoing phone calls, since last statistics reset|
|timer_ingoing||41337||The total length of all incoming phone calls, since last statistics reset|
|timer_all||72674||The total length of all incoming/outgoing phone calls, since last statistics reset|
|timer_last_reset||232345655.1842||The date the call timer statics was last reset, usally (almost) the same as data_last_reset.|
|data_last_reset||232345655.1942444||The date the data statics was last reset, usally (almost) the same as timer_last_reset.|
This is the main table where the call history is stored:
|field name||type||value / description|
|ROWID||INTEGER PRIMARY KEY AUTOINCREMENT||primary key|
|address||TEXT||Phone number or FaceTime ID of contact that has been called/has received call from.|
|date||INTEGER||the date of the phone call|
|duration||INTEGER||number of seconds the phone call lasted|
|flags||INTEGER||flag is 4 for incoming calls, 5 for outgoing calls, 8 for blocked calls|
|id||INTEGER||Contacts or Address Book ID of the contact being called. This column would be -1 if the contact is unknown (e.g. not in address book). This column is always -1 on incoming calls.|
|country_code||TEXT||The mobile country code (MCC) of the country the phone was in when the call was placed. Example: 234 for United Kingdom. (list of MCC/MNC)|
|network_code||TEXT||The mobile network code (MNC) of the network the phone was on when the call was placed. Example: 30 for T-Mobile (UK) (list of MCC/MNC)|
|read||INTEGER DEFAULT '1'||read=0 if the call is an missed call, which hasn't been "read". Example there is a (number) on the Phone icon, showing number of missed calls. read=1 if the missed calls has been checked.|
|assisted||INTEGER DEFAULT '0'||?|
|originalAddress||TEXT DEFAULT ''||?|
Note: name, country_code, network_code where added in iOS 5, while read, assisted, face_time_data, originalAddress where added in iOS 6.