• Share
    • Twitter
    • LinkedIn
    • Facebook
    • Email
  • Feedback
  • Edit
Show / Hide Table of Contents

ejuser Table (299)

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) ●
email 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 table relationship diagram

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
email 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.
© SuperOffice. All rights reserved.
SuperOffice |  Community |  Release Notes |  Privacy |  Site feedback |  Search Docs |  About Docs |  Contribute |  Back to top