Class ExtraFieldsTableInfo

Table 'extra_fields': This table contains entries for the extra fields in the system.

Inheritance

Object

TableInfo

ExtraFieldsTableInfo

Implements

ICloneable

Inherited Members

TableInfo.ToString()

TableInfo.RegisterFields(FieldInfo[])

TableInfo.FieldInfoFromSoField(SoField)

TableInfo.Clone()

TableInfo.IsSameTable(TableInfo)

TableInfo.FindField(String)

TableInfo.ProtAll

TableInfo.HashCheckFields

TableInfo.TableName

TableInfo.DbName

TableInfo.IsDictionaryTable

TableInfo.All

TableInfo.Item[String]

TableInfo.PrimaryKeyField

Namespace: SuperOffice.CRM.Data

Assembly: SoDataBase.dll

Syntax

[DatabaseTable("extra_fields")]
public class ExtraFieldsTableInfo : 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 ExtraFields in the database dictionary: extra_fields

Declaration

public const string DictionaryTableName = "extra_fields"

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

DefaultValue

Field 'default_value' in table 'extra_fields': Dictionary type String[256], .NET type: String

The default value of this extra field.

Declaration

public StringFieldInfo DefaultValue { 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 .

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration

public override SoTable Definition { get; }

Property Value

Type	Description
SoTable

Overrides

TableInfo.Definition

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_fields': Dictionary type String[2048], .NET type: String

Optional description of what this field 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 ExtraFields 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 .

Domain

Field 'domain' in table 'extra_fields': Dictionary type Enum, .NET type: Int16

Enum indicating for what table this is an extra field (ticket, customer, company, etc).

Declaration

public UInt16FieldInfo Domain { get; }

Property Value

Type	Description
UInt16FieldInfo

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 .

ExtraFieldsId

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

The primary key (auto-incremented)

Declaration

public Int32FieldInfo ExtraFieldsId { 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 .

ExtraTable

Field 'extra_table' in table 'extra_fields': Dictionary type FK, target: ExtraTables, .NET type: Int32

The reference to the extra_table if this table is related to an extra_table. NULL or -1 if not set.

Declaration

public Int32FieldInfo ExtraTable { 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 .

ExtraTable_InnerJoin_ExtraTables

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

Declaration

public TargetedInnerJoin<ExtraTablesTableInfo> ExtraTable_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 .

FieldName

Field 'field_name' in table 'extra_fields': Dictionary type String[65], .NET type: String

The database name of this extra field.

Declaration

public StringFieldInfo FieldName { 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 .

Flags

Field 'flags' in table 'extra_fields': Dictionary type Int, .NET type: Int32

A bitmask for flags for this extra field.

Declaration

public Int32FieldInfo Flags { 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_ExtraTables_DisplayField

Generated left outer join from the primary key ExtraFieldsId on this table, to ExtraTables.DisplayField.

Declaration

public TargetedLeftOuterJoin<ExtraTablesTableInfo> LeftOuterJoin_ExtraTables_DisplayField { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<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 .

LeftOuterJoin_TicketLogChange_ExtraFieldId

Generated left outer join from the primary key ExtraFieldsId on this table, to TicketLogChange.ExtraFieldId.

Declaration

public TargetedLeftOuterJoin<TicketLogChangeTableInfo> LeftOuterJoin_TicketLogChange_ExtraFieldId { get; }

Property Value

Type	Description
TargetedLeftOuterJoin<TicketLogChangeTableInfo>

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_fields': Dictionary type String[129], .NET type: String

The name of this extra field.

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 .

OrderPos

Field 'order_pos' in table 'extra_fields': Dictionary type Int, .NET type: Int32

Used to order elements when listed.

Declaration

public Int32FieldInfo OrderPos { 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 .

Params

Field 'params' in table 'extra_fields': Dictionary type Clob, .NET type: String

A string contaning various parameters for this extra field, stored in an arbitrary format.

Declaration

public StringFieldInfo Params { 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 .

TargetExtraTable

Field 'target_extra_table' in table 'extra_fields': Dictionary type FK, target: ExtraTables, .NET type: Int32

If this extra field is a extra table relation, then this is the id of the extra table this entry points to.

Declaration

public Int32FieldInfo TargetExtraTable { 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 .

TargetExtraTable_InnerJoin_ExtraTables

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

Declaration

public TargetedInnerJoin<ExtraTablesTableInfo> TargetExtraTable_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 .

Type

Field 'type' in table 'extra_fields': Dictionary type Enum, .NET type: Int16

Enum indicating the type for this extra field (string, int, date, etc).

Declaration

public UInt16FieldInfo Type { get; }

Property Value

Type	Description
UInt16FieldInfo

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

System.ICloneable

Extension Methods

EnumUtil.MapEnums<From, To>(From)

Converters.MapEnums<From, To>(From)