Core database

The core database contains all the authentication information needed to connect or reconnect to a device.

ER diagram

The following entity-relationship (ER) diagram shows the relationships among the tables in the core database:



Figure 1. ER diagram for core database

Sample schema file

The database schema is specified in /db/bluetoothdb.sql, which looks like this:

CREATE TABLE bluetooth_general(
    recordid INTEGER PRIMARY KEY AUTOINCREMENT,
    record_type INTEGER,
    address TEXT,
    data BLOB
);

CREATE TABLE bluetooth_devices(
    deviceid INTEGER PRIMARY KEY AUTOINCREMENT,
    address TEXT,
    cod INTEGER,
    nameFound INTEGER,
    name TEXT,
    call BLOB,
    media BLOB,
    pim BLOB,
    message BLOB,
    network BLOB
);