Class KbWorkflowTableInfo
Table 'kb_workflow': Knowledge base workflow steps
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("kb_workflow")]
public class KbWorkflowTableInfo : 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.GetKbWorkflowInfo().
Fields
DictionaryTableName
Conceptual name of table KbWorkflow in the database dictionary: kb_workflow
Declaration
public const string DictionaryTableName = "kb_workflow"
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.GetKbWorkflowInfo().
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.GetKbWorkflowInfo().
DictionaryTableNumber
Table number for table KbWorkflow 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.GetKbWorkflowInfo().
KbWorkflowId
Field 'id' in table 'kb_workflow': Dictionary type PK, .NET type: int
The primary key (auto-incremented)Declaration
public Int32FieldInfo KbWorkflowId { 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.GetKbWorkflowInfo().
LeftOuterJoin_KbEntry_WorkflowPhase
Generated left outer join from the primary key KbWorkflowId on this table, to KbEntry.WorkflowPhase.
Declaration
public TargetedLeftOuterJoin<KbEntryTableInfo> LeftOuterJoin_KbEntry_WorkflowPhase { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<KbEntryTableInfo> |
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.GetKbWorkflowInfo().
LeftOuterJoin_KbWorkflowAccess_KbWorkflow
Generated left outer join from the primary key KbWorkflowId on this table, to KbWorkflowAccess.KbWorkflow.
Declaration
public TargetedLeftOuterJoin<KbWorkflowAccessTableInfo> LeftOuterJoin_KbWorkflowAccess_KbWorkflow { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<KbWorkflowAccessTableInfo> |
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.GetKbWorkflowInfo().
LeftOuterJoin_RoleWorkflow_WorkflowId
Generated left outer join from the primary key KbWorkflowId on this table, to RoleWorkflow.WorkflowId.
Declaration
public TargetedLeftOuterJoin<RoleWorkflowTableInfo> LeftOuterJoin_RoleWorkflow_WorkflowId { get; }
Property Value
Type | Description |
---|---|
TargetedLeftOuterJoin<RoleWorkflowTableInfo> |
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.GetKbWorkflowInfo().
Name
Field 'name' in table 'kb_workflow': Dictionary type String[256], .NET type: string
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.GetKbWorkflowInfo().
Next
Field 'next' in table 'kb_workflow': Dictionary type FK, target: KbWorkflow, .NET type: int
The next workflow phase.Declaration
public Int32FieldInfo Next { 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.GetKbWorkflowInfo().
Next_InnerJoin_KbWorkflow
Generated join from the foreign key Next in this table, to its target table KbWorkflowTableInfo.
Declaration
public TargetedInnerJoin<KbWorkflowTableInfo> Next_InnerJoin_KbWorkflow { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<KbWorkflowTableInfo> |
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.GetKbWorkflowInfo().
Previous
Field 'previous' in table 'kb_workflow': Dictionary type FK, target: KbWorkflow, .NET type: int
The previous workflow phase.Declaration
public Int32FieldInfo Previous { 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.GetKbWorkflowInfo().
Previous_InnerJoin_KbWorkflow
Generated join from the foreign key Previous in this table, to its target table KbWorkflowTableInfo.
Declaration
public TargetedInnerJoin<KbWorkflowTableInfo> Previous_InnerJoin_KbWorkflow { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<KbWorkflowTableInfo> |
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.GetKbWorkflowInfo().
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.GetKbWorkflowInfo().