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. |