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

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

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

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

DisplayField

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

The default field to display for this extra table.

Declaration
public Int32FieldInfo DisplayField { get; }
Property Value
Type Description
Int32FieldInfo

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>

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

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

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

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

FullnameField

Field 'fullname_field' in table 'extra_tables': Dictionary type FK, .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

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>

HierarchyId

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

This extra table is inside this hierarchy folder

Declaration
public Int32FieldInfo HierarchyId { get; }
Property Value
Type Description
Int32FieldInfo

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>

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>

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>

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>

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>

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

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

ParentField

Field 'parent_field' in table 'extra_tables': Dictionary type FK, .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

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>

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

ScreenChooserAll

Field 'screen_chooser_all' in table 'extra_tables': Dictionary type FK, .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

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>

ScreenChooserEdit

Field 'screen_chooser_edit' in table 'extra_tables': Dictionary type FK, .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

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>

ScreenChooserEntry

Field 'screen_chooser_entry' in table 'extra_tables': Dictionary type FK, .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

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>

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

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

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

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)