| id | The primary key (auto-incremented) | PK | No |
| loginname | The unique loginname for this user. | String(63) | No |
| usergroup | The group this user is member of | FK hierarchy | No |
| username | The unique username for this user. | String(63) | No |
| password | The encrypted password for this user. | String(127) | Yes |
| firstname | The firstname for this user. | String(127) | Yes |
| middlename | The middlename for this user. | String(127) | Yes |
| lastname | The lastname for this user. | String(127) | Yes |
| email | The email address for this user. | String(255) | No |
| access_level | The access level for this user. | Int | Yes |
| status | The status (enum) for this user. | status | Yes |
| signature | The users signature. | Clob | Yes |
| notify_mask | A bitmask indicating to which extent the user should recieve pop-up warnings for various events. | Int | Yes |
| email_mask | A bitmask indicated to which extent the user should recieve email warnings for various events. | Int | Yes |
| sms_mask | A bitmask indicated to which extent the user should recieve sms warnings for various events. | Int | Yes |
| language | A string indicating the user's language ('no' or 'en'). | String(5) | Yes |
| dictionary | A string indicating the user's prefered dictionary language ('no' or 'en'). | String(5) | Yes |
| default_category | The default category for this user when posting tickets and use_last_category is false. | FK ej_category | No |
| textareasize | Size of textarea for each user, example '80x40' | String(31) | Yes |
| flags | A bitmask indicating flags for this entry. | Int | Yes |
| last_category | The last chosen category for this user when posting tickets. | FK ej_category | Yes |
| profile_id | Reference to the profile connected to this ejuser | FK profile | Yes |
| hidden_bag_bitset | Each character represent a bit to set a HtmlBagHideable to default open or closed (1=open 0=closed) | String(255) | Yes |
| notify_external_lock | A datetime lock to make sure notifications are only displayed by one notifcation system (ejournal or external programs) | DateTime | Yes |
| notify_external_source | A name (id) of the external notifications system (ejournal or external programs) | String(255) | Yes |
| login_attempts | The number of times the user has attempted to login with the wrong password | Int | Yes |
| last_login_attempt | The last time the user tried to log in without success | DateTime | Yes |
| idle_time | Number of seconds the user has been idle. Updated by TrayIcon or simular external programs. | Int | No |
| default_user | The default user to set on new tickets in this category (1=automatically, 2=unasigned, 3=the owner | Int | Yes |
| sms | The SMS number for this user | String(64) | Yes |
| new_gui | Whether to use the new gui or not | Bool | No |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | No |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | No |
| dbi_last_syncronized | Last external syncronization. | DateTime | No |
| dbi_last_modified | When the entry was last modified. | DateTime | No |
| minute_offset | Offset in hours between server and ejuser timezone. | Int | No |
| date_format | The preferred format of dates and datetimes (enum) for this user. | date_format | No |
| simultaneous_login | A boolean telling if the user is counted as one of the simultaneous ones, or one who alway may log in | Bool | No |
| picture_id | The attachment.id this reference is connected to. | FK attachment | Yes |
| not_present | Comment to add for user when status is not present. | String(255) | Yes |
| default_status_new_ticket | Default status on new requests. | FK ticket_status | Yes |
| default_status_add_message | Default status on add message. | FK ticket_status | Yes |
| num_expanded_messages | The number of expanded messages in show-ticket view. | Int | No |
| date_format_string | Chosen date format as a string for this user | String(64) | Yes |
| time_format_string | Chosen time format as a string for this user | String(64) | Yes |
| date_format_long_string | Chosen date format for lists as a string for this user | String(64) | Yes |
| chat_status | Various chat statuses for an agent | Enum ChatStatus | Yes |
