ejuser Table (299)
•
Environment: onsite, online
Some tooltip text!
• 8 minutes to read
• 8 minutes to read
This table contains entries for the users of the system.
Fields
| Name | Description | Type | Null |
|---|---|---|---|
| id | The primary key (auto-incremented) | PK | |
| loginname | The unique loginname for this user. | String(63) | |
| usergroup | The group this user is member of | FK hierarchy | |
| username | The unique username for this user. | String(63) | |
| password | The encrypted password for this user. | String(127) | ● |
| firstname | The firstname for this user. | String(127) | ● |
| middlename | The middlename for this user. | String(127) | ● |
| lastname | The lastname for this user. | String(127) | ● |
| The email address for this user. | String(255) | ||
| access_level | The access level for this user. | Int | ● |
| status | The status (enum) for this user. | status | ● |
| signature | The users signature. | Clob | ● |
| notify_mask | A bitmask indicating to which extent the user should recieve pop-up warnings for various events. | Int | ● |
| email_mask | A bitmask indicated to which extent the user should recieve email warnings for various events. | Int | ● |
| sms_mask | A bitmask indicated to which extent the user should recieve sms warnings for various events. | Int | ● |
| language | A string indicating the user's language ('no' or 'en'). | String(5) | ● |
| dictionary | A string indicating the user's prefered dictionary language ('no' or 'en'). | String(5) | ● |
| default_category | The default category for this user when posting tickets and use_last_category is false. | FK ej_category | |
| textareasize | Size of textarea for each user, example '80x40' | String(31) | ● |
| flags | A bitmask indicating flags for this entry. | Int | ● |
| last_category | The last chosen category for this user when posting tickets. | FK ej_category | ● |
| profile_id | Reference to the profile connected to this ejuser | FK profile | ● |
| hidden_bag_bitset | Each character represent a bit to set a HtmlBagHideable to default open or closed (1=open 0=closed) | String(255) | ● |
| notify_external_lock | A datetime lock to make sure notifications are only displayed by one notifcation system (ejournal or external programs) | DateTime | ● |
| notify_external_source | A name (id) of the external notifications system (ejournal or external programs) | String(255) | ● |
| login_attempts | The number of times the user has attempted to login with the wrong password | Int | ● |
| last_login_attempt | The last time the user tried to log in without success | DateTime | ● |
| idle_time | Number of seconds the user has been idle. Updated by TrayIcon or simular external programs. | Int | |
| default_user | The default user to set on new tickets in this category (1=automatically, 2=unasigned, 3=the owner | Int | ● |
| sms | The SMS number for this user | String(64) | ● |
| new_gui | Whether to use the new gui or not | Bool | |
| dbi_agent_id | Integration agent (eJournal) | FK dbi_agent | |
| dbi_key | The primary key for the integrated entry in the external datasource. | String(255) | |
| dbi_last_syncronized | Last external syncronization. | DateTime | |
| dbi_last_modified | When the entry was last modified. | DateTime | |
| minute_offset | Offset in hours between server and ejuser timezone. | Int | |
| date_format | The preferred format of dates and datetimes (enum) for this user. | date_format | |
| simultaneous_login | A boolean telling if the user is counted as one of the simultaneous ones, or one who alway may log in | Bool | |
| picture_id | The attachment.id this reference is connected to. | FK attachment | ● |
| not_present | Comment to add for user when status is not present. | String(255) | ● |
| default_status_new_ticket | Default status on new requests. | FK ticket_status | ● |
| default_status_add_message | Default status on add message. | FK ticket_status | ● |
| num_expanded_messages | The number of expanded messages in show-ticket view. | Int | |
| date_format_string | Chosen date format as a string for this user | String(64) | ● |
| time_format_string | Chosen time format as a string for this user | String(64) | ● |
| date_format_long_string | Chosen date format for lists as a string for this user | String(64) | ● |
| chat_status | Various chat statuses for an agent | Enum ChatStatus | ● |
| ejuser status type | DD |
|---|---|
| None | 0 |
| Normal | 1 |
| Not Available | 2 |
| Deleted | 3 |
| ReadOnly | 4 |
| Spm | 5 |
| System | 127 |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
| loginname | String(63) | Index |
| usergroup | FK | Index |
| username | String(63) | Index |
| String(255) | Index | |
| default_category | FK | Index |
| last_category | FK | Index |
| profile_id | FK | Index |
| dbi_agent_id | FK | Index |
| dbi_key | String(255) | Index |
| dbi_last_syncronized | DateTime | Index |
| dbi_last_modified | DateTime | Index |
| picture_id | FK | Index |
| default_status_new_ticket | FK | Index |
| default_status_add_message | FK | Index |
Relationships
| Table | Description |
|---|---|
| associate | Employees, resources and other users - except for External persons |
| attachment | This table contains metadata for attachments. The actual attachments are stored directly on disk, with filenames based on the the primary key for this table. |
| category_membership | This table connects users to categories (many-to-many). |
| chat_message | This table contains messages in a chat session. |
| chat_session | This table contains chat sessions. |
| chat_topic_user | This table connected the chat topics with the users (i.e. the membership). |
| dbi_agent | DBI agent settings |
| dictionary | User added dictionary words |
| doc_document | This table contains documents. |
| doc_folder | A document folder. |
| ej_category | This table contains categories, in which tickets are categorized. The categories are organized in a hierarchial manner. |
| ej_message | This table contains the messages listed under tickets. |
| ejpackage | This table stores packages on the system. |
| ejsel_meta_result | This table stores result meta data |
| ejselection | This table stores selections, dynamic groups. |
| element_profile | The new (4.0) profile table. Contains profile for a single Html-element. Connected through element_profile_link |
| external_document | This table stores documents which can be viewed externaly, through the customer module |
| hierarchy | This table contains folders used to group the extra tables in the system. |
| hotlist | The table is used by the hotlist to store the relationship between tickets and users |
| kb_category | Knowledge base folder hierarchy |
| kb_category_log | Who and when, if somebody edits a knowledge base folder |
| kb_entry | This table contains FAQ entries. |
| kb_entry_log | Who and when, if somebody edits a knowledge base entry |
| kb_workflow_access | Control of who can do what in a knowledge base workflow step |
| login | This table contains entries for the user sessions. |
| ms_filter | This table contains email filters. These are the filters allowing you to do advanced parsing of incomming emails. |
| notify | This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc. |
| profile | Deprecated. This table contains entries for the user profiles. |
| reply_template | Templates for automatic and manual replies to emails/sms organized hierachically |
| role_member | Users linked to a role. Deprecated. |
| s_link | Links in messages to measure success rate of a campaign. |
| ticket | This table contains the tickets (requests) of the system. Its purpose should be evident. |
| ticket_alert | This table will contain ticket escalation levels. A ticket will be escalated along a 'chain' of these levels. |
| ticket_log_action | This table contains actions for the tickets. |
| ticket_status | This table user defined ticket status values. |
| user_attribute | This table is used for storing various attributes for users. |
Replication Flags
- None
Security Flags
- No access control via user's Role.