Class RoleElementTableInfo

Table 'role_element': Profiles associated with a role

Inheritance
object
TableInfo
RoleElementTableInfo
Implements
Inherited Members
Namespace: SuperOfficeCRMData
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("role_element")]
public class RoleElementTableInfo : 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.GetRoleElementInfo().

Fields

DictionaryTableName

Conceptual name of table RoleElement in the database dictionary: role_element

Declaration
public const string DictionaryTableName = "role_element"
Field Value
Type Description
string

Properties

CrmRole

Field 'crm_role' in table 'role_element': Dictionary type FK, target: Role, .NET type: int

Link to Role

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

CrmRole_InnerJoin_Role

Generated join from the foreign key CrmRole in this table, to its target table RoleTableInfo.

Declaration
public TargetedInnerJoin<RoleTableInfo> CrmRole_InnerJoin_Role { get; }
Property Value
Type Description
TargetedInnerJoinRoleTableInfo

Definition

Definition of the table as described in the deployed runtime dictionary

Declaration
public override SoTable Definition { get; }
Property Value
Type Description
SoTable
Overrides

DictionaryTableNumber

Table number for table RoleElement 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

ElementProfile

Field 'element_profile' in table 'role_element': Dictionary type FK, target: ElementProfile, .NET type: int

The id of the element_profile.

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

ElementProfile_InnerJoin_ElementProfile

Generated join from the foreign key ElementProfile in this table, to its target table ElementProfileTableInfo.

Declaration
public TargetedInnerJoin<ElementProfileTableInfo> ElementProfile_InnerJoin_ElementProfile { get; }
Property Value
Type Description
TargetedInnerJoinElementProfileTableInfo

Role

Field 'role' in table 'role_element': Dictionary type FK, target: EjRole, .NET type: int

The id of the group. Deprecated.

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

RoleElementId

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

The primary key (auto-incremented)

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

Role_InnerJoin_EjRole

Generated join from the foreign key Role in this table, to its target table EjRoleTableInfo.

Declaration
public TargetedInnerJoin<EjRoleTableInfo> Role_InnerJoin_EjRole { get; }
Property Value
Type Description
TargetedInnerJoinEjRoleTableInfo

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

Implements

Extension Methods