Class UserGroupLinkTableInfo

Table 'UserGroupLink': Link table between associate and usergroup, specifies secondary group membership. From SIX an associate may belong to more than one usergroup. Http://techdoc.superoffice.com has more information about how roles are implemented.

Inheritance
Object
TableInfo
UserGroupLinkTableInfo
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("UserGroupLink")]
public class UserGroupLinkTableInfo : 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 UserGroupLink in the database dictionary: UserGroupLink

Declaration
public const string DictionaryTableName = "UserGroupLink"
Field Value
Type Description
String

Properties

AssocId

Field 'assoc_id' in table 'UserGroupLink': Dictionary type FK, .NET type: Int32

Link to associate

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

AssocId_InnerJoin_Associate

Generated join from the foreign key AssocId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> AssocId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

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

EncryptedCheck

Field 'encryptedCheck' in table 'UserGroupLink': Dictionary type String[255], .NET type: String

Encrypted data, to detect unwanted changes

Declaration
public StringFieldInfo EncryptedCheck { get; }
Property Value
Type Description
StringFieldInfo

Registered

Field 'registered' in table 'UserGroupLink': Dictionary type UtcDateTime, .NET type: DateTime

Registered when

Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type Description
DateTimeFieldInfo

RegisteredAssociateId

Field 'registered_associate_id' in table 'UserGroupLink': Dictionary type FK, .NET type: Int32

Registered by whom

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

RegisteredAssociateId_InnerJoin_Associate

Generated join from the foreign key RegisteredAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> RegisteredAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

Remark

Field 'remark' in table 'UserGroupLink': Dictionary type String[255], .NET type: String

Comment on why the assoc is linked to the group

Declaration
public StringFieldInfo Remark { get; }
Property Value
Type Description
StringFieldInfo

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

Updated

Field 'updated' in table 'UserGroupLink': Dictionary type UtcDateTime, .NET type: DateTime

Last updated when

Declaration
public DateTimeFieldInfo Updated { get; }
Property Value
Type Description
DateTimeFieldInfo

UpdatedAssociateId

Field 'updated_associate_id' in table 'UserGroupLink': Dictionary type FK, .NET type: Int32

Last updated by whom

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

UpdatedAssociateId_InnerJoin_Associate

Generated join from the foreign key UpdatedAssociateId in this table, to its target table AssociateTableInfo.

Declaration
public TargetedInnerJoin<AssociateTableInfo> UpdatedAssociateId_InnerJoin_Associate { get; }
Property Value
Type Description
TargetedInnerJoin<AssociateTableInfo>

UpdatedCount

Field 'updatedCount' in table 'UserGroupLink': Dictionary type UShort, .NET type: Int16

Number of updates made to this record

Declaration
public UInt16FieldInfo UpdatedCount { get; }
Property Value
Type Description
UInt16FieldInfo

UserGroupId

Field 'UserGroup_id' in table 'UserGroupLink': Dictionary type FK, .NET type: Int32

Link to group

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

UserGroupId_InnerJoin_UserGroup

Generated join from the foreign key UserGroupId in this table, to its target table UserGroupTableInfo.

Declaration
public TargetedInnerJoin<UserGroupTableInfo> UserGroupId_InnerJoin_UserGroup { get; }
Property Value
Type Description
TargetedInnerJoin<UserGroupTableInfo>

UserGroupLinkId

Field 'UserGroupLink_id' in table 'UserGroupLink': Dictionary type PK, .NET type: Int32

Primary key

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

ValidFrom

Field 'validFrom' in table 'UserGroupLink': Dictionary type DateTime, .NET type: DateTime

When the membership becomes valid

Declaration
public DateTimeFieldInfo ValidFrom { get; }
Property Value
Type Description
DateTimeFieldInfo

ValidTo

Field 'validTo' in table 'UserGroupLink': Dictionary type DateTime, .NET type: DateTime

Last datetime this membership is valid

Declaration
public DateTimeFieldInfo ValidTo { get; }
Property Value
Type Description
DateTimeFieldInfo

Implements

Extension Methods

EnumUtil.MapEnums<From, To>(From)