Class EjuserTableInfo

Table 'ejuser': This table contains entries for the users of the system.

Inheritance
Object
TableInfo
EjuserTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ejuser")]
public class EjuserTableInfo : TableInfo, ICloneable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Fields

DictionaryTableName

Conceptual name of table Ejuser in the database dictionary: ejuser

Declaration
public const string DictionaryTableName = "ejuser"
Field Value
Type Description
String
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Properties

AccessLevel

Field 'access_level' in table 'ejuser': Dictionary type Int, .NET type: Int32

The access level for this user.
Declaration
public Int32FieldInfo AccessLevel { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

ChatStatus

Field 'chat_status' in table 'ejuser': Dictionary type Enum, .NET type: ChatStatus

Various chat statuses for an agent
Declaration
public ChatStatusFieldInfo ChatStatus { get; }
Property Value
Type Description
ChatStatusFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DateFormat

Field 'date_format' in table 'ejuser': Dictionary type Enum, .NET type: Int16

The preferred format of dates and datetimes (enum) for this user.
Declaration
public UInt16FieldInfo DateFormat { get; }
Property Value
Type Description
UInt16FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DateFormatLongString

Field 'date_format_long_string' in table 'ejuser': Dictionary type String[65], .NET type: String

Chosen date format for lists as a string for this user
Declaration
public StringFieldInfo DateFormatLongString { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DateFormatString

Field 'date_format_string' in table 'ejuser': Dictionary type String[65], .NET type: String

Chosen date format as a string for this user
Declaration
public StringFieldInfo DateFormatString { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DbiAgentId

Field 'dbi_agent_id' in table 'ejuser': Dictionary type FK, target: DbiAgent, .NET type: Int32

Integration agent (eJournal)
Declaration
public Int32FieldInfo DbiAgentId { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DbiAgentId_InnerJoin_DbiAgent

Generated join from the foreign key DbiAgentId in this table, to its target table DbiAgentTableInfo.

Declaration
public TargetedInnerJoin<DbiAgentTableInfo> DbiAgentId_InnerJoin_DbiAgent { get; }
Property Value
Type Description
TargetedInnerJoin<DbiAgentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DbiKey

Field 'dbi_key' in table 'ejuser': Dictionary type String[256], .NET type: String

The primary key for the integrated entry in the external datasource.
Declaration
public StringFieldInfo DbiKey { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DbiLastModified

Field 'dbi_last_modified' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

When the entry was last modified.
Declaration
public DateTimeFieldInfo DbiLastModified { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DbiLastSyncronized

Field 'dbi_last_syncronized' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

Last external syncronization.
Declaration
public DateTimeFieldInfo DbiLastSyncronized { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultCategory

Field 'default_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: Int32

The default category for this user when posting tickets and use_last_category is false.
Declaration
public Int32FieldInfo DefaultCategory { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultCategory_InnerJoin_EjCategory

Generated join from the foreign key DefaultCategory in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> DefaultCategory_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultStatusAddMessage

Field 'default_status_add_message' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: Int32

Default status on add message.
Declaration
public Int32FieldInfo DefaultStatusAddMessage { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultStatusAddMessage_InnerJoin_TicketStatus

Generated join from the foreign key DefaultStatusAddMessage in this table, to its target table TicketStatusTableInfo.

Declaration
public TargetedInnerJoin<TicketStatusTableInfo> DefaultStatusAddMessage_InnerJoin_TicketStatus { get; }
Property Value
Type Description
TargetedInnerJoin<TicketStatusTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultStatusNewTicket

Field 'default_status_new_ticket' in table 'ejuser': Dictionary type FK, target: TicketStatus, .NET type: Int32

Default status on new requests.
Declaration
public Int32FieldInfo DefaultStatusNewTicket { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultStatusNewTicket_InnerJoin_TicketStatus

Generated join from the foreign key DefaultStatusNewTicket in this table, to its target table TicketStatusTableInfo.

Declaration
public TargetedInnerJoin<TicketStatusTableInfo> DefaultStatusNewTicket_InnerJoin_TicketStatus { get; }
Property Value
Type Description
TargetedInnerJoin<TicketStatusTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DefaultUser

Field 'default_user' in table 'ejuser': Dictionary type Int, .NET type: Int32

The default user to set on new tickets in this category (1=automatically, 2=unasigned, 3=the owner
Declaration
public Int32FieldInfo DefaultUser { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Dictionary

Field 'dictionary' in table 'ejuser': Dictionary type String[6], .NET type: String

A string indicating the user's prefered dictionary language ('no' or 'en').
Declaration
public StringFieldInfo Dictionary { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

DictionaryTableNumber

Table number for table Ejuser in the database dictionary; potentially changes between databases, but always the same over the lifetime of any single database

Declaration
public int DictionaryTableNumber { get; }
Property Value
Type Description
Int32
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

EjuserId

Field 'id' in table 'ejuser': Dictionary type PK, .NET type: Int32

The primary key (auto-incremented)
Declaration
public Int32FieldInfo EjuserId { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Email

Field 'email' in table 'ejuser': Dictionary type String[256], .NET type: String

The email address for this user.
Declaration
public StringFieldInfo Email { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

EmailMask

Field 'email_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32

A bitmask indicated to which extent the user should recieve email warnings for various events.
Declaration
public Int32FieldInfo EmailMask { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Firstname

Field 'firstname' in table 'ejuser': Dictionary type String[128], .NET type: String

The firstname for this user.
Declaration
public StringFieldInfo Firstname { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Flags

Field 'flags' in table 'ejuser': Dictionary type Int, .NET type: Int32

A bitmask indicating flags for this entry.
Declaration
public Int32FieldInfo Flags { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

HiddenBagBitset

Field 'hidden_bag_bitset' in table 'ejuser': Dictionary type String[256], .NET type: String

Each character represent a bit to set a HtmlBagHideable to default open or closed (1=open 0=closed)
Declaration
public StringFieldInfo HiddenBagBitset { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

IdleTime

Field 'idle_time' in table 'ejuser': Dictionary type Int, .NET type: Int32

Number of seconds the user has been idle. Updated by TrayIcon or simular external programs.
Declaration
public Int32FieldInfo IdleTime { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Language

Field 'language' in table 'ejuser': Dictionary type String[6], .NET type: String

A string indicating the user's language ('no' or 'en').
Declaration
public StringFieldInfo Language { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LastCategory

Field 'last_category' in table 'ejuser': Dictionary type FK, target: EjCategory, .NET type: Int32

The last chosen category for this user when posting tickets.
Declaration
public Int32FieldInfo LastCategory { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LastCategory_InnerJoin_EjCategory

Generated join from the foreign key LastCategory in this table, to its target table EjCategoryTableInfo.

Declaration
public TargetedInnerJoin<EjCategoryTableInfo> LastCategory_InnerJoin_EjCategory { get; }
Property Value
Type Description
TargetedInnerJoin<EjCategoryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LastLoginAttempt

Field 'last_login_attempt' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

The last time the user tried to log in without success
Declaration
public DateTimeFieldInfo LastLoginAttempt { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Lastname

Field 'lastname' in table 'ejuser': Dictionary type String[128], .NET type: String

The lastname for this user.
Declaration
public StringFieldInfo Lastname { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Associate_EjUserId

Generated left outer join from the primary key EjuserId on this table, to Associate.EjUserId.

Declaration
public TargetedLeftOuterJoin<AssociateTableInfo> LeftOuterJoin_Associate_EjUserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<AssociateTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_CategoryMembership_UserId

Generated left outer join from the primary key EjuserId on this table, to CategoryMembership.UserId.

Declaration
public TargetedLeftOuterJoin<CategoryMembershipTableInfo> LeftOuterJoin_CategoryMembership_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<CategoryMembershipTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ChatMessage_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to ChatMessage.CreatedBy.

Declaration
public TargetedLeftOuterJoin<ChatMessageTableInfo> LeftOuterJoin_ChatMessage_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatMessageTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ChatSession_TransferTo

Generated left outer join from the primary key EjuserId on this table, to ChatSession.TransferTo.

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_TransferTo { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ChatSession_UserId

Generated left outer join from the primary key EjuserId on this table, to ChatSession.UserId.

Declaration
public TargetedLeftOuterJoin<ChatSessionTableInfo> LeftOuterJoin_ChatSession_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatSessionTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ChatTopicUser_UserId

Generated left outer join from the primary key EjuserId on this table, to ChatTopicUser.UserId.

Declaration
public TargetedLeftOuterJoin<ChatTopicUserTableInfo> LeftOuterJoin_ChatTopicUser_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ChatTopicUserTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Dictionary_UserId

Generated left outer join from the primary key EjuserId on this table, to Dictionary.UserId.

Declaration
public TargetedLeftOuterJoin<DictionaryTableInfo> LeftOuterJoin_Dictionary_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DictionaryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_DocDocument_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to DocDocument.ChangedBy.

Declaration
public TargetedLeftOuterJoin<DocDocumentTableInfo> LeftOuterJoin_DocDocument_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocDocumentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_DocDocument_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to DocDocument.CreatedBy.

Declaration
public TargetedLeftOuterJoin<DocDocumentTableInfo> LeftOuterJoin_DocDocument_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocDocumentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_DocFolder_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to DocFolder.CreatedBy.

Declaration
public TargetedLeftOuterJoin<DocFolderTableInfo> LeftOuterJoin_DocFolder_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<DocFolderTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_EjCategory_CategoryMaster

Generated left outer join from the primary key EjuserId on this table, to EjCategory.CategoryMaster.

Declaration
public TargetedLeftOuterJoin<EjCategoryTableInfo> LeftOuterJoin_EjCategory_CategoryMaster { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjCategoryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_EjMessage_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to EjMessage.ChangedBy.

Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjMessageTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_EjMessage_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to EjMessage.CreatedBy.

Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjMessageTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Ejpackage_UploadedBy

Generated left outer join from the primary key EjuserId on this table, to Ejpackage.UploadedBy.

Declaration
public TargetedLeftOuterJoin<EjpackageTableInfo> LeftOuterJoin_Ejpackage_UploadedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjpackageTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Ejselection_Creator

Generated left outer join from the primary key EjuserId on this table, to Ejselection.Creator.

Declaration
public TargetedLeftOuterJoin<EjselectionTableInfo> LeftOuterJoin_Ejselection_Creator { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjselectionTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_EjselMetaResult_Owner

Generated left outer join from the primary key EjuserId on this table, to EjselMetaResult.Owner.

Declaration
public TargetedLeftOuterJoin<EjselMetaResultTableInfo> LeftOuterJoin_EjselMetaResult_Owner { get; }
Property Value
Type Description
TargetedLeftOuterJoin<EjselMetaResultTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ElementProfile_OwnedByUser

Generated left outer join from the primary key EjuserId on this table, to ElementProfile.OwnedByUser.

Declaration
public TargetedLeftOuterJoin<ElementProfileTableInfo> LeftOuterJoin_ElementProfile_OwnedByUser { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ElementProfileTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ExternalDocument_ChangedBy

Generated left outer join from the primary key EjuserId on this table, to ExternalDocument.ChangedBy.

Declaration
public TargetedLeftOuterJoin<ExternalDocumentTableInfo> LeftOuterJoin_ExternalDocument_ChangedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExternalDocumentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ExternalDocument_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to ExternalDocument.CreatedBy.

Declaration
public TargetedLeftOuterJoin<ExternalDocumentTableInfo> LeftOuterJoin_ExternalDocument_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExternalDocumentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Hotlist_UserId

Generated left outer join from the primary key EjuserId on this table, to Hotlist.UserId.

Declaration
public TargetedLeftOuterJoin<HotlistTableInfo> LeftOuterJoin_Hotlist_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<HotlistTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_KbCategory_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to KbCategory.CreatedBy.

Declaration
public TargetedLeftOuterJoin<KbCategoryTableInfo> LeftOuterJoin_KbCategory_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbCategoryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_KbCategoryLog_UserId

Generated left outer join from the primary key EjuserId on this table, to KbCategoryLog.UserId.

Declaration
public TargetedLeftOuterJoin<KbCategoryLogTableInfo> LeftOuterJoin_KbCategoryLog_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbCategoryLogTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_KbEntry_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to KbEntry.CreatedBy.

Declaration
public TargetedLeftOuterJoin<KbEntryTableInfo> LeftOuterJoin_KbEntry_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbEntryTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_KbEntryLog_UserId

Generated left outer join from the primary key EjuserId on this table, to KbEntryLog.UserId.

Declaration
public TargetedLeftOuterJoin<KbEntryLogTableInfo> LeftOuterJoin_KbEntryLog_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbEntryLogTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_KbWorkflowAccess_UserId

Generated left outer join from the primary key EjuserId on this table, to KbWorkflowAccess.UserId.

Declaration
public TargetedLeftOuterJoin<KbWorkflowAccessTableInfo> LeftOuterJoin_KbWorkflowAccess_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<KbWorkflowAccessTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Login_UserId

Generated left outer join from the primary key EjuserId on this table, to Login.UserId.

Declaration
public TargetedLeftOuterJoin<LoginTableInfo> LeftOuterJoin_Login_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<LoginTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_MsFilter_NewOwner

Generated left outer join from the primary key EjuserId on this table, to MsFilter.NewOwner.

Declaration
public TargetedLeftOuterJoin<MsFilterTableInfo> LeftOuterJoin_MsFilter_NewOwner { get; }
Property Value
Type Description
TargetedLeftOuterJoin<MsFilterTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Notify_OwnerId

Generated left outer join from the primary key EjuserId on this table, to Notify.OwnerId.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_OwnerId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Notify_User2Id

Generated left outer join from the primary key EjuserId on this table, to Notify.User2Id.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_User2Id { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Notify_UserId

Generated left outer join from the primary key EjuserId on this table, to Notify.UserId.

Declaration
public TargetedLeftOuterJoin<NotifyTableInfo> LeftOuterJoin_Notify_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<NotifyTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Profile_UserId

Generated left outer join from the primary key EjuserId on this table, to Profile.UserId.

Declaration
public TargetedLeftOuterJoin<ProfileTableInfo> LeftOuterJoin_Profile_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ProfileTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_ReplyTemplate_OwnedBy

Generated left outer join from the primary key EjuserId on this table, to ReplyTemplate.OwnedBy.

Declaration
public TargetedLeftOuterJoin<ReplyTemplateTableInfo> LeftOuterJoin_ReplyTemplate_OwnedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ReplyTemplateTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_RoleMember_Ejuser

Generated left outer join from the primary key EjuserId on this table, to RoleMember.Ejuser.

Declaration
public TargetedLeftOuterJoin<RoleMemberTableInfo> LeftOuterJoin_RoleMember_Ejuser { get; }
Property Value
Type Description
TargetedLeftOuterJoin<RoleMemberTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Generated left outer join from the primary key EjuserId on this table, to SLink.TicketOwnedBy.

Declaration
public TargetedLeftOuterJoin<SLinkTableInfo> LeftOuterJoin_SLink_TicketOwnedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SLinkTableInfo>

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Ticket_CreatedBy

Generated left outer join from the primary key EjuserId on this table, to Ticket.CreatedBy.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_CreatedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_Ticket_OwnedBy

Generated left outer join from the primary key EjuserId on this table, to Ticket.OwnedBy.

Declaration
public TargetedLeftOuterJoin<TicketTableInfo> LeftOuterJoin_Ticket_OwnedBy { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_TicketAlert_DelegateTo

Generated left outer join from the primary key EjuserId on this table, to TicketAlert.DelegateTo.

Declaration
public TargetedLeftOuterJoin<TicketAlertTableInfo> LeftOuterJoin_TicketAlert_DelegateTo { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketAlertTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_TicketLogAction_UserId

Generated left outer join from the primary key EjuserId on this table, to TicketLogAction.UserId.

Declaration
public TargetedLeftOuterJoin<TicketLogActionTableInfo> LeftOuterJoin_TicketLogAction_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<TicketLogActionTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LeftOuterJoin_UserAttribute_UserId

Generated left outer join from the primary key EjuserId on this table, to UserAttribute.UserId.

Declaration
public TargetedLeftOuterJoin<UserAttributeTableInfo> LeftOuterJoin_UserAttribute_UserId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<UserAttributeTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

LoginAttempts

Field 'login_attempts' in table 'ejuser': Dictionary type Int, .NET type: Int32

The number of times the user has attempted to login with the wrong password
Declaration
public Int32FieldInfo LoginAttempts { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Loginname

Field 'loginname' in table 'ejuser': Dictionary type String[64], .NET type: String

The unique loginname for this user.
Declaration
public StringFieldInfo Loginname { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Middlename

Field 'middlename' in table 'ejuser': Dictionary type String[128], .NET type: String

The middlename for this user.
Declaration
public StringFieldInfo Middlename { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

MinuteOffset

Field 'minute_offset' in table 'ejuser': Dictionary type Int, .NET type: Int32

Offset in hours between server and ejuser timezone.
Declaration
public Int32FieldInfo MinuteOffset { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NewGui

Field 'new_gui' in table 'ejuser': Dictionary type Bool, .NET type: Int16

Whether to use the new gui or not
Declaration
public UInt16FieldInfo NewGui { get; }
Property Value
Type Description
UInt16FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NotifyExternalLock

Field 'notify_external_lock' in table 'ejuser': Dictionary type DateTime, .NET type: DateTime

A datetime lock to make sure notifications are only displayed by one notifcation system (ejournal or external programs)
Declaration
public DateTimeFieldInfo NotifyExternalLock { get; }
Property Value
Type Description
DateTimeFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NotifyExternalSource

Field 'notify_external_source' in table 'ejuser': Dictionary type String[256], .NET type: String

A name (id) of the external notifications system (ejournal or external programs)
Declaration
public StringFieldInfo NotifyExternalSource { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NotifyMask

Field 'notify_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32

A bitmask indicating to which extent the user should recieve pop-up warnings for various events.
Declaration
public Int32FieldInfo NotifyMask { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NotPresent

Field 'not_present' in table 'ejuser': Dictionary type String[256], .NET type: String

Comment to add for user when status is not present.
Declaration
public StringFieldInfo NotPresent { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

NumExpandedMessages

Field 'num_expanded_messages' in table 'ejuser': Dictionary type Int, .NET type: Int32

The number of expanded messages in show-ticket view.
Declaration
public Int32FieldInfo NumExpandedMessages { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Password

Field 'password' in table 'ejuser': Dictionary type String[128], .NET type: String

The encrypted password for this user.
Declaration
public StringFieldInfo Password { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

PictureId

Field 'picture_id' in table 'ejuser': Dictionary type FK, target: Attachment, .NET type: Int32

The attachment.id this reference is connected to.
Declaration
public Int32FieldInfo PictureId { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

PictureId_InnerJoin_Attachment

Generated join from the foreign key PictureId in this table, to its target table AttachmentTableInfo.

Declaration
public TargetedInnerJoin<AttachmentTableInfo> PictureId_InnerJoin_Attachment { get; }
Property Value
Type Description
TargetedInnerJoin<AttachmentTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

ProfileId

Field 'profile_id' in table 'ejuser': Dictionary type FK, target: Profile, .NET type: Int32

Reference to the profile connected to this ejuser
Declaration
public Int32FieldInfo ProfileId { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

ProfileId_InnerJoin_Profile

Generated join from the foreign key ProfileId in this table, to its target table ProfileTableInfo.

Declaration
public TargetedInnerJoin<ProfileTableInfo> ProfileId_InnerJoin_Profile { get; }
Property Value
Type Description
TargetedInnerJoin<ProfileTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Signature

Field 'signature' in table 'ejuser': Dictionary type Clob, .NET type: String

The users signature.
Declaration
public StringFieldInfo Signature { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

SimultaneousLogin

Field 'simultaneous_login' in table 'ejuser': Dictionary type Bool, .NET type: Int16

A boolean telling if the user is counted as one of the simultaneous ones, or one who alway may log in
Declaration
public UInt16FieldInfo SimultaneousLogin { get; }
Property Value
Type Description
UInt16FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Sms

Field 'sms' in table 'ejuser': Dictionary type String[65], .NET type: String

The SMS number for this user
Declaration
public StringFieldInfo Sms { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

SmsMask

Field 'sms_mask' in table 'ejuser': Dictionary type Int, .NET type: Int32

A bitmask indicated to which extent the user should recieve sms warnings for various events.
Declaration
public Int32FieldInfo SmsMask { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Status

Field 'status' in table 'ejuser': Dictionary type Enum, .NET type: Int16

The status (enum) for this user.
Declaration
public UInt16FieldInfo Status { get; }
Property Value
Type Description
UInt16FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Textareasize

Field 'textareasize' in table 'ejuser': Dictionary type String[32], .NET type: String

Size of textarea for each user, example '80x40'
Declaration
public StringFieldInfo Textareasize { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

TimeFormatString

Field 'time_format_string' in table 'ejuser': Dictionary type String[65], .NET type: String

Chosen time format as a string for this user
Declaration
public StringFieldInfo TimeFormatString { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Usergroup

Field 'usergroup' in table 'ejuser': Dictionary type FK, target: Hierarchy, .NET type: Int32

The group this user is member of
Declaration
public Int32FieldInfo Usergroup { get; }
Property Value
Type Description
Int32FieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Usergroup_InnerJoin_Hierarchy

Generated join from the foreign key Usergroup in this table, to its target table HierarchyTableInfo.

Declaration
public TargetedInnerJoin<HierarchyTableInfo> Usergroup_InnerJoin_Hierarchy { get; }
Property Value
Type Description
TargetedInnerJoin<HierarchyTableInfo>
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Username

Field 'username' in table 'ejuser': Dictionary type String[64], .NET type: String

The unique username for this user.
Declaration
public StringFieldInfo Username { get; }
Property Value
Type Description
StringFieldInfo
Remarks

An instance of this class represents one instance of this table in an SQL statement. In most cases each table appears only once in a SELECT, but in cases where you need to self-join, or there are multiple occurrences for other reasons (typically additional restrictions in the joins), then you will need multiple instances.
Instances of this class are created by calling .

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)