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 .

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 .

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 .

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 .

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

DisplayField

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

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 .

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 .

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 .

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 .

ExtraTablesId

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

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 .

Flags

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

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 .

FullnameField

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

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 .

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 .

HierarchyId

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

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 .

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 .

IconId

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

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 .

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 .

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 .

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 .

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 .

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 .

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 .

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 .

ParentField

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

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 .

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 .

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 .

ScreenChooserAll

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

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 .

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 .

ScreenChooserEdit

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

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 .

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 .

ScreenChooserEntry

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

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 .

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 .

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 .

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 .

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 .

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)