Class InboxTableInfo
Table 'inbox': Info and status for safe email import
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("inbox")]
public class InboxTableInfo : 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 Inbox in the database dictionary: inbox
Declaration
public const string DictionaryTableName = "inbox"
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
Created
Field 'created' in table 'inbox': Dictionary type DateTime, .NET type: DateTime
When the mail was createdDeclaration
public DateTimeFieldInfo Created { 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
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
DictionaryTableNumber
Table number for table Inbox 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
Format
Field 'format' in table 'inbox': Dictionary type String[256], .NET type: String
Format of the inbox entryDeclaration
public StringFieldInfo Format { 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
Imported
Field 'imported' in table 'inbox': Dictionary type DateTime, .NET type: DateTime
When the mail was importedDeclaration
public DateTimeFieldInfo Imported { 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
InboxId
Field 'id' in table 'inbox': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo InboxId { 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
LeftOuterJoin_EjMessage_Inbox
Generated left outer join from the primary key InboxId on this table, to EjMessage.Inbox.
Declaration
public TargetedLeftOuterJoin<EjMessageTableInfo> LeftOuterJoin_EjMessage_Inbox { 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
LockingId
Field 'locking_id' in table 'inbox': Dictionary type FK, target: Locking, .NET type: Int32
A reference to the id of lockDeclaration
public Int32FieldInfo LockingId { 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
LockingId_InnerJoin_Locking
Generated join from the foreign key LockingId in this table, to its target table LockingTableInfo.
Declaration
public TargetedInnerJoin<LockingTableInfo> LockingId_InnerJoin_Locking { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<LockingTableInfo> |
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
MailInFilter
Field 'mail_in_filter' in table 'inbox': Dictionary type FK, target: MailInFilter, .NET type: Int32
A reference to the id of the mail boxDeclaration
public Int32FieldInfo MailInFilter { 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
MailInFilter_InnerJoin_MailInFilter
Generated join from the foreign key MailInFilter in this table, to its target table MailInFilterTableInfo.
Declaration
public TargetedInnerJoin<MailInFilterTableInfo> MailInFilter_InnerJoin_MailInFilter { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<MailInFilterTableInfo> |
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
MailSize
Field 'mail_size' in table 'inbox': Dictionary type Int, .NET type: Int32
The size of the mail in bytesDeclaration
public Int32FieldInfo MailSize { 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
NextRetry
Field 'next_retry' in table 'inbox': Dictionary type DateTime, .NET type: DateTime
When is the next time we should try again?Declaration
public DateTimeFieldInfo NextRetry { 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
Plugin
Field 'plugin' in table 'inbox': Dictionary type String[256], .NET type: String
Name of plugin that created this inbox entryDeclaration
public StringFieldInfo Plugin { 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
Status
Field 'status' in table 'inbox': Dictionary type Int, .NET type: Int32
Status enumDeclaration
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
Uidl
Field 'uidl' in table 'inbox': Dictionary type String[2048], .NET type: String
The uidl of the message. Stored before the retrieval starts to prevent double import. For locking purposesDeclaration
public StringFieldInfo Uidl { 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