Chapter 5. Database description

Table of Contents
account table
service table
user table
user_alias table
service_instance table
data_supplier table
loneuser table
sms_provider table

Figure 5-1. Tracepack database schema.

account table

Abstract: Login names and passwords for user and data_supplier authorization. Used by PHPlib

Fields:

ID - Key field.

username - name of the service.

password - POSIX crypt() encoded password.

level - User level: "user", "supplier" or "admin"