Table users

Table users holds the login information for the users of PhreeBooks. User accounts can be linked to employee accounts.

Table Type: InnoDB

Field Type Default Description
admin_id int (11) NOT NULL PRIMARY KEY - Auto increment field to hold unique ID
admin_name varchar(32) NULL The login name of the user. Must be unique
display_name varchar(32) NULL The name to display in welcome screens
admin_email varchar(96) NULL user email address
admin_pass varchar(40) NULL user password
account_id int(11) 0 This field links the user account to the employee (Contact) account.
admin_prefs text NULL  
admin_security text NULL This field holds the encoded security information for the user defining what modules are accessble and which are not.