Class LoginTableInfo

Table 'login': This table contains entries for the user sessions.

Inheritance
Object
TableInfo
LoginTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("login")]
public class LoginTableInfo : 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 Login in the database dictionary: login

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

Properties

ActiveMenu

Field 'active_menu' in table 'login': Dictionary type Int, .NET type: Int32

The currently active (open) left-menu for this session.

Declaration
public Int32FieldInfo ActiveMenu { get; }
Property Value
Type Description
Int32FieldInfo

AuthenticationType

Field 'authentication_type' in table 'login': Dictionary type Enum, .NET type: Int16

The authentication type (enum) for this session.

Declaration
public UInt16FieldInfo AuthenticationType { get; }
Property Value
Type Description
UInt16FieldInfo

Definition

Definition of the table as described in the deployed runtime dictionary

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

DictionaryTableNumber

Table number for table Login 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

ErrorMessage

Field 'error_message' in table 'login': Dictionary type String[256], .NET type: String

Stores the last error message recorded on this session

Declaration
public StringFieldInfo ErrorMessage { get; }
Property Value
Type Description
StringFieldInfo

Flags

Field 'flags' in table 'login': Dictionary type Enum, .NET type: LoginFlags

Bitmask of flags for a service login session

Declaration
public LoginFlagsFieldInfo Flags { get; }
Property Value
Type Description
LoginFlagsFieldInfo

Idle

Field 'idle' in table 'login': Dictionary type DateTime, .NET type: DateTime

The last time this session was active.

Declaration
public DateTimeFieldInfo Idle { get; }
Property Value
Type Description
DateTimeFieldInfo

LeftOuterJoin_ExtraTablesResult_LoginId

Generated left outer join from the primary key LoginId on this table, to ExtraTablesResult.LoginId.

Declaration
public TargetedLeftOuterJoin<ExtraTablesResultTableInfo> LeftOuterJoin_ExtraTablesResult_LoginId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtraTablesResultTableInfo>

LeftOuterJoin_InvoiceSum_LoginId

Generated left outer join from the primary key LoginId on this table, to InvoiceSum.LoginId.

Declaration
public TargetedLeftOuterJoin<InvoiceSumTableInfo> LeftOuterJoin_InvoiceSum_LoginId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<InvoiceSumTableInfo>

LeftOuterJoin_SessionObject_LoginId

Generated left outer join from the primary key LoginId on this table, to SessionObject.LoginId.

Declaration
public TargetedLeftOuterJoin<SessionObjectTableInfo> LeftOuterJoin_SessionObject_LoginId { get; }
Property Value
Type Description
TargetedLeftOuterJoin<SessionObjectTableInfo>

LoggedIn

Field 'logged_in' in table 'login': Dictionary type DateTime, .NET type: DateTime

When this session started.

Declaration
public DateTimeFieldInfo LoggedIn { get; }
Property Value
Type Description
DateTimeFieldInfo

LoginId

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

The primary key (auto-incremented)

Declaration
public Int32FieldInfo LoginId { get; }
Property Value
Type Description
Int32FieldInfo

LoginOrigin

Field 'origin' in table 'login': Dictionary type Int, .NET type: Int32

1=soap call, 2=web pages

Declaration
public Int32FieldInfo LoginOrigin { get; }
Property Value
Type Description
Int32FieldInfo

NsSecret

Field 'ns_secret' in table 'login': Dictionary type String[256], .NET type: String

Netserver login secret.

Declaration
public StringFieldInfo NsSecret { get; }
Property Value
Type Description
StringFieldInfo

RemoteAddr

Field 'remote_addr' in table 'login': Dictionary type String[65], .NET type: String

The IP address of the client for this session.

Declaration
public StringFieldInfo RemoteAddr { get; }
Property Value
Type Description
StringFieldInfo

RemoteHost

Field 'remote_host' in table 'login': Dictionary type String[65], .NET type: String

The hostname (depending on whether reverse lookup is enabled in httpd) or IP address of the client for this session.

Declaration
public StringFieldInfo RemoteHost { get; }
Property Value
Type Description
StringFieldInfo

RuntimeDefinition

Definition of the table as described in the deployed runtime dictionary

Declaration
[Obsolete("Use instance property Definition or static member DictionaryTableNumber", true)]
public static SoTable RuntimeDefinition { get; }
Property Value
Type Description
SoTable

SessionKey

Field 'session_key' in table 'login': Dictionary type String[33], .NET type: String

A random 32 characters value used as authentication key for the session.

Declaration
public StringFieldInfo SessionKey { get; }
Property Value
Type Description
StringFieldInfo

Status

Field 'status' in table 'login': Dictionary type Int, .NET type: Int32

The status (enum) for this session.

Declaration
public Int32FieldInfo Status { get; }
Property Value
Type Description
Int32FieldInfo

UserId

Field 'user_id' in table 'login': Dictionary type FK, .NET type: Int32

The id of the user this entry references.

Declaration
public Int32FieldInfo UserId { get; }
Property Value
Type Description
Int32FieldInfo

UserId_InnerJoin_Ejuser

Generated join from the foreign key UserId in this table, to its target table EjuserTableInfo.

Declaration
public TargetedInnerJoin<EjuserTableInfo> UserId_InnerJoin_Ejuser { get; }
Property Value
Type Description
TargetedInnerJoin<EjuserTableInfo>

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)