Class LoginTableInfo

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

Inheritance

Object

TableInfo

LoginTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

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

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

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

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 .

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

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

TableInfo.Definition

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 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

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 .

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

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 '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

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 .

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

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_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>

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_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>

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_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>

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 .

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

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 .

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

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 .

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

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 .

NsSecret

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

Netserver login secret.

Declaration

public StringFieldInfo NsSecret { 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 .

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

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 .

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

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 .

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

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 'login': Dictionary type Int, .NET type: Int32

The status (enum) for this session.

Declaration

public Int32FieldInfo Status { 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 .

UserId

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

The id of the user this entry references.

Declaration

public Int32FieldInfo UserId { 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 .

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>

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

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)