Class EabEntryTableInfo
Table 'eab_entry': This table contains eab (email address book) entries, i.e. an alias ('Ola Hansen') and an address ('ola@hansen.as').
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("eab_entry")]
public class EabEntryTableInfo : 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 TablesInfo.GetEabEntryInfo().
Fields
DictionaryTableName
Conceptual name of table EabEntry in the database dictionary: eab_entry
Declaration
public const string DictionaryTableName = "eab_entry"
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 TablesInfo.GetEabEntryInfo().
Properties
DbiAgentId
Field 'dbi_agent_id' in table 'eab_entry': Dictionary type FK, target: DbiAgent, .NET type: int
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 TablesInfo.GetEabEntryInfo().
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 TablesInfo.GetEabEntryInfo().
DbiDelete
Field 'dbi_delete' in table 'eab_entry': Dictionary type Short, .NET type: short
This field is used for determin which entry to delete during a synchronizationDeclaration
public Int16FieldInfo DbiDelete { get; }
Property Value
| Type | Description |
|---|---|
| Int16FieldInfo |
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 TablesInfo.GetEabEntryInfo().
DbiKey
Field 'dbi_key' in table 'eab_entry': 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 TablesInfo.GetEabEntryInfo().
DbiLastModified
Field 'dbi_last_modified' in table 'eab_entry': 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 TablesInfo.GetEabEntryInfo().
DbiLastSyncronized
Field 'dbi_last_syncronized' in table 'eab_entry': 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 TablesInfo.GetEabEntryInfo().
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 TablesInfo.GetEabEntryInfo().
DictionaryTableNumber
Table number for table EabEntry 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 |
|---|---|
| int |
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 TablesInfo.GetEabEntryInfo().
EabEntryId
Field 'id' in table 'eab_entry': Dictionary type PK, .NET type: int
The primary key (auto-incremented)Declaration
public Int32FieldInfo EabEntryId { 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 TablesInfo.GetEabEntryInfo().
EmailAddress
Field 'email_address' in table 'eab_entry': Dictionary type String[256], .NET type: string
The actual email address.Declaration
public StringFieldInfo EmailAddress { 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 TablesInfo.GetEabEntryInfo().
FolderId
Field 'folder_id' in table 'eab_entry': Dictionary type FK, target: EabFolder, .NET type: int
The id of the folder in which this entry is located.Declaration
public Int32FieldInfo FolderId { 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 TablesInfo.GetEabEntryInfo().
FolderId_InnerJoin_EabFolder
Generated join from the foreign key FolderId in this table, to its target table EabFolderTableInfo.
Declaration
public TargetedInnerJoin<EabFolderTableInfo> FolderId_InnerJoin_EabFolder { get; }
Property Value
| Type | Description |
|---|---|
| TargetedInnerJoin<EabFolderTableInfo> |
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 TablesInfo.GetEabEntryInfo().
Name
Field 'name' in table 'eab_entry': Dictionary type String[65], .NET type: string
The name of this email addressDeclaration
public StringFieldInfo Name { 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 TablesInfo.GetEabEntryInfo().
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 |
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 TablesInfo.GetEabEntryInfo().
SmsNumber
Field 'sms_number' in table 'eab_entry': Dictionary type String[256], .NET type: string
The sms number for this personDeclaration
public StringFieldInfo SmsNumber { 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 TablesInfo.GetEabEntryInfo().