Database schema

Table of Contents Tables call_forwarding Description List of columns call_state Description List of columns cell_location Description List of columns Possible modifications data_connection_state Description List of columns service_state Description List of columns Possible modifications signal_strength Description List of columns Possible modifications wifi_onoff Description List of columns wifi_networks Description List of columns bt_state Description List of columns bt_devices Description List of columns light_data Description List of columns headset events Description List of columns

Tables

call_forwarding

Description

Shows whether call forwarding is enabled on the phone

List of columns

• time NUMERIC
• forwarding_enabled NUMERIC

call_state

Description

Used to store the call state. Information is stored according to information at http://developer.android.com/reference/android/telephony/PhoneStateListener.html#onCallStateChanged(int,%20java.lang.String)

List of columns

• time NUMERIC
• state NUMERIC

cell_location

Description

Used to store the cell location. The cell id is stored

List of columns

• time NUMERIC
• cellLocation TEXT

Possible modifications

Store both the cell id and the cell location area code.

data_connection_state

Description

Stored the data connection state along with the network type. Network type is stored according to http://developer.android.com/reference/android/net/ConnectivityManager.html#TYPE_MOBILE. State is stored according to http://developer.android.com/reference/android/telephony/PhoneStateListener.html#onDataConnectionStateChanged(int)

List of columns

• time NUMERIC
• state NUMERIC
• type NUMERIC

service_state

Description

Stores service state information is stored according to http://developer.android.com/reference/android/telephony/PhoneStateListener.html#onServiceStateChanged(android.telephony.ServiceState)

List of columns

• time NUMERIC
• value NUMERIC

Possible modifications

• log whether the phone is in roaming

signal_strength

Description

Used to store logged information related to signal strengths. The information stored is according to TS 27.007 8.5 (see http://m10.home.xs4all.nl/mac/downloads/3GPP-27007-630.pdf)

List of columns

• time NUMERIC
• gsmSignal NUMERIC
• gsmBitErrorRate NUMERIC

Possible modifications

• add columns for other networks that are supported by Android such as: CDMA and EVDO

wifi_onoff

Description

Stores the state of the wifi radio. Information is stored according to http://developer.android.com/reference/android/net/wifi/WifiManager.html#EXTRA_WIFI_STATE

List of columns

• time NUMERIC
• value NUMERIC

wifi_networks

Description

Stores information about the WiFi networks around the device

List of columns

• time NUMERIC
• ssid TEXT
• capabilities TEXT - textual representation of the network encryption
• signalStrength NUMERIC - decibels
• bssid TEXT
• frequency TEXT

bt_state

Description

Stores information about whether the Bt radion is up or down and who caused the change

List of columns

• time NUMERIC
• state TEXT - according to http://developer.android.com/reference/android/bluetooth/BluetoothAdapter.html#EXTRA_STATE
• capabilities TEXT - textual representation of the network encryption
• byUser NUMERIC - 0 or 1 depending on whether it was the user or CL that changed the state of the radio

bt_devices

Description

List of Bt devices in the vicinity of CL

List of columns

• time NUMERIC
• deviceAddress TEXT - Mac address for the Bt device
• deviceName TEXT - textual representation of the device's name

light_data

Description

Recorded values for light strength.

List of columns

• time NUMERIC
• value NUMERIC - luminosity value

headset events

Description

Log of headset plug or unplug events, see http://developer.android.com/reference/android/content/Intent.html#ACTION_HEADSET_PLUG

List of columns

• time NUMERIC
• status NUMERIC - whether headsets are plugged in or not
• microphone NUMERIC - whether the headset has a microphone or not
• name TEXT - headset type, human readable