Class ExtraTablesTableInfo

Table 'extra_tables': This table contains entries for the extra tables in the system.

Inheritance
object
TableInfo
ExtraTablesTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("extra_tables")]
public class ExtraTablesTableInfo : 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.GetExtraTablesInfo().

Fields

DictionaryTableName

Conceptual name of table ExtraTables in the database dictionary: extra_tables

Declaration
public const string DictionaryTableName = "extra_tables"
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.GetExtraTablesInfo().

Properties

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.GetExtraTablesInfo().

Description

Field 'description' in table 'extra_tables': Dictionary type String[2048], .NET type: string

Optional description of what this table is used for
Declaration
public StringFieldInfo Description { 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.GetExtraTablesInfo().

DictionaryTableNumber

Table number for table ExtraTables 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.GetExtraTablesInfo().

DisplayField

Field 'display_field' in table 'extra_tables': Dictionary type FK, target: ExtraFields, .NET type: int

The default field to display for this extra table.
Declaration
public Int32FieldInfo DisplayField { 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.GetExtraTablesInfo().

DisplayField_InnerJoin_ExtraFields

Generated join from the foreign key DisplayField in this table, to its target table ExtraFieldsTableInfo.

Declaration
public TargetedInnerJoin<ExtraFieldsTableInfo> DisplayField_InnerJoin_ExtraFields { get; }
Property Value
Type Description
TargetedInnerJoin<ExtraFieldsTableInfo>
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.GetExtraTablesInfo().

EditEntryHeader

Field 'edit_entry_header' in table 'extra_tables': Dictionary type String[256], .NET type: string

The header when editing an entry in this table.
Declaration
public StringFieldInfo EditEntryHeader { 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.GetExtraTablesInfo().

ExtraTableName

Field 'table_name' in table 'extra_tables': Dictionary type String[65], .NET type: string

The database name of this extra table.
Declaration
public StringFieldInfo ExtraTableName { 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.GetExtraTablesInfo().

ExtraTablesId

Field 'id' in table 'extra_tables': Dictionary type PK, .NET type: int

The primary key (auto-incremented)
Declaration
public Int32FieldInfo ExtraTablesId { 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.GetExtraTablesInfo().

Flags

Field 'flags' in table 'extra_tables': Dictionary type UInt, .NET type: uint

Bitmap for flags for this entry.
Declaration
public FieldInfo Flags { get; }
Property Value
Type Description
FieldInfo
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.GetExtraTablesInfo().

FullnameField

Field 'fullname_field' in table 'extra_tables': Dictionary type FK, target: ExtraTables, .NET type: int

If this table is hierarchically organized, then this field can contain a field which will be assigned a fullname, such as 'Support/Hardware/Keyboards'.
Declaration
public Int32FieldInfo FullnameField { 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.GetExtraTablesInfo().

FullnameField_InnerJoin_ExtraTables

Generated join from the foreign key FullnameField in this table, to its target table ExtraTablesTableInfo.

Declaration
public TargetedInnerJoin<ExtraTablesTableInfo> FullnameField_InnerJoin_ExtraTables { get; }
Property Value
Type Description
TargetedInnerJoin<ExtraTablesTableInfo>
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.GetExtraTablesInfo().

HierarchyId

Field 'hierarchy_id' in table 'extra_tables': Dictionary type FK, target: Hierarchy, .NET type: int

This extra table is inside this hierarchy folder
Declaration
public Int32FieldInfo HierarchyId { 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.GetExtraTablesInfo().

HierarchyId_InnerJoin_Hierarchy

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

Declaration
public TargetedInnerJoin<HierarchyTableInfo> HierarchyId_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 TablesInfo.GetExtraTablesInfo().

IconId

Field 'icon_id' in table 'extra_tables': Dictionary type FK, target: BinaryObject, .NET type: int

The id of the binary object entry
Declaration
public Int32FieldInfo IconId { 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.GetExtraTablesInfo().

IconId_InnerJoin_BinaryObject

Generated join from the foreign key IconId in this table, to its target table BinaryObjectTableInfo.

Declaration
public TargetedInnerJoin<BinaryObjectTableInfo> IconId_InnerJoin_BinaryObject { get; }
Property Value
Type Description
TargetedInnerJoin<BinaryObjectTableInfo>
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.GetExtraTablesInfo().

LeftOuterJoin_ExtraFields_ExtraTable

Generated left outer join from the primary key ExtraTablesId on this table, to ExtraFields.ExtraTable.

Declaration
public TargetedLeftOuterJoin<ExtraFieldsTableInfo> LeftOuterJoin_ExtraFields_ExtraTable { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtraFieldsTableInfo>
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.GetExtraTablesInfo().

LeftOuterJoin_ExtraFields_TargetExtraTable

Generated left outer join from the primary key ExtraTablesId on this table, to ExtraFields.TargetExtraTable.

Declaration
public TargetedLeftOuterJoin<ExtraFieldsTableInfo> LeftOuterJoin_ExtraFields_TargetExtraTable { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtraFieldsTableInfo>
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.GetExtraTablesInfo().

LeftOuterJoin_ExtraMenus_ExtraTable

Generated left outer join from the primary key ExtraTablesId on this table, to ExtraMenus.ExtraTable.

Declaration
public TargetedLeftOuterJoin<ExtraMenusTableInfo> LeftOuterJoin_ExtraMenus_ExtraTable { get; }
Property Value
Type Description
TargetedLeftOuterJoin<ExtraMenusTableInfo>
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.GetExtraTablesInfo().

LeftOuterJoin_ExtraTablesResult_ExtraTable

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

Declaration
public TargetedLeftOuterJoin<ExtraTablesResultTableInfo> LeftOuterJoin_ExtraTablesResult_ExtraTable { 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 TablesInfo.GetExtraTablesInfo().

Name

Field 'name' in table 'extra_tables': Dictionary type String[129], .NET type: string

The name of this extra table.
Declaration
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.GetExtraTablesInfo().

NewEntryHeader

Field 'new_entry_header' in table 'extra_tables': Dictionary type String[256], .NET type: string

The header when creating a new entry in this table.
Declaration
public StringFieldInfo NewEntryHeader { 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.GetExtraTablesInfo().

ParentField

Field 'parent_field' in table 'extra_tables': Dictionary type FK, target: ExtraTables, .NET type: int

If this table is hierarchically organized, then this field can contain a field which is a parent-field, creating a hierarchy.
Declaration
public Int32FieldInfo ParentField { 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.GetExtraTablesInfo().

ParentField_InnerJoin_ExtraTables

Generated join from the foreign key ParentField in this table, to its target table ExtraTablesTableInfo.

Declaration
public TargetedInnerJoin<ExtraTablesTableInfo> ParentField_InnerJoin_ExtraTables { get; }
Property Value
Type Description
TargetedInnerJoin<ExtraTablesTableInfo>
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.GetExtraTablesInfo().

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.GetExtraTablesInfo().

ScreenChooserAll

Field 'screen_chooser_all' in table 'extra_tables': Dictionary type FK, target: ScreenChooser, .NET type: int

The screen chooser to use for this extra table when viewing the table.
Declaration
public Int32FieldInfo ScreenChooserAll { 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.GetExtraTablesInfo().

ScreenChooserAll_InnerJoin_ScreenChooser

Generated join from the foreign key ScreenChooserAll in this table, to its target table ScreenChooserTableInfo.

Declaration
public TargetedInnerJoin<ScreenChooserTableInfo> ScreenChooserAll_InnerJoin_ScreenChooser { get; }
Property Value
Type Description
TargetedInnerJoin<ScreenChooserTableInfo>
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.GetExtraTablesInfo().

ScreenChooserEdit

Field 'screen_chooser_edit' in table 'extra_tables': Dictionary type FK, target: ScreenChooser, .NET type: int

The screen chooser to use for this extra table when editing the table.
Declaration
public Int32FieldInfo ScreenChooserEdit { 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.GetExtraTablesInfo().

ScreenChooserEdit_InnerJoin_ScreenChooser

Generated join from the foreign key ScreenChooserEdit in this table, to its target table ScreenChooserTableInfo.

Declaration
public TargetedInnerJoin<ScreenChooserTableInfo> ScreenChooserEdit_InnerJoin_ScreenChooser { get; }
Property Value
Type Description
TargetedInnerJoin<ScreenChooserTableInfo>
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.GetExtraTablesInfo().

ScreenChooserEntry

Field 'screen_chooser_entry' in table 'extra_tables': Dictionary type FK, target: ScreenChooser, .NET type: int

The screen chooser to use for this extra table when viewing an entry.
Declaration
public Int32FieldInfo ScreenChooserEntry { 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.GetExtraTablesInfo().

ScreenChooserEntry_InnerJoin_ScreenChooser

Generated join from the foreign key ScreenChooserEntry in this table, to its target table ScreenChooserTableInfo.

Declaration
public TargetedInnerJoin<ScreenChooserTableInfo> ScreenChooserEntry_InnerJoin_ScreenChooser { get; }
Property Value
Type Description
TargetedInnerJoin<ScreenChooserTableInfo>
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.GetExtraTablesInfo().

SearchHeader

Field 'search_header' in table 'extra_tables': Dictionary type String[256], .NET type: string

The header when searching this table.
Declaration
public StringFieldInfo SearchHeader { 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.GetExtraTablesInfo().

SortOrder

Field 'sort_order' in table 'extra_tables': Dictionary type String[256], .NET type: string

The default sort_order for this extra table.
Declaration
public StringFieldInfo SortOrder { 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.GetExtraTablesInfo().

ViewEntryHeader

Field 'view_entry_header' in table 'extra_tables': Dictionary type String[256], .NET type: string

The header when viewing entries in this table.
Declaration
public StringFieldInfo ViewEntryHeader { 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.GetExtraTablesInfo().

Implements

Extension Methods