Each SQLite file corresponds to a database that can contain many tables. Each table contains rows of data.

In order to successfully perform a query on a database, it is important to become familiar with some of the SQLite terminology.

1) Identify a database of interest from the device.

2) Each database is made up of a series of items:

a) Tables are the different categories of data contained in the database. In this example, tables contain categories like ZKIKCHAT, ZKIKUSER, and ZKIKMESSAGE.

b) Each table or category consists of multiple columns. The columns describe the data in each category. They are descriptions or properties. In this example, some of the columns that make up the ZKIKMESSAGE table are ZUSER, ZRECEIVEDTIMESTAMP, ZTIMESTAMP, and ZBODY.

c) Finally, the user data that is categorized in tables and defined by column descriptors can be found in each row or record.

3) Identify items of interest by looking at the contents of each table and their associated columns.