Class EjpackageItemTableInfo
Table 'ejpackage_item': This table stores info on installed packages in the system
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("ejpackage_item")]
public class EjpackageItemTableInfo : 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.GetEjpackageItemInfo().
Fields
DictionaryTableName
Conceptual name of table EjpackageItem in the database dictionary: ejpackage_item
Declaration
public const string DictionaryTableName = "ejpackage_item"
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.GetEjpackageItemInfo().
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.GetEjpackageItemInfo().
DictionaryTableNumber
Table number for table EjpackageItem 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.GetEjpackageItemInfo().
Domain
Field 'domain' in table 'ejpackage_item': Dictionary type Int, .NET type: int
The domain for which this item belongs (domains are defined in PackageLib.h)Declaration
public Int32FieldInfo Domain { 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.GetEjpackageItemInfo().
Ejpackage
Field 'ejpackage' in table 'ejpackage_item': Dictionary type FK, target: Ejpackage, .NET type: int
The id of the package for which this item belongsDeclaration
public Int32FieldInfo Ejpackage { 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.GetEjpackageItemInfo().
EjpackageItemId
Field 'id' in table 'ejpackage_item': Dictionary type PK, .NET type: int
Primary keyDeclaration
public Int32FieldInfo EjpackageItemId { 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.GetEjpackageItemInfo().
Ejpackage_InnerJoin_Ejpackage
Generated join from the foreign key Ejpackage in this table, to its target table EjpackageTableInfo.
Declaration
public TargetedInnerJoin<EjpackageTableInfo> Ejpackage_InnerJoin_Ejpackage { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjpackageTableInfo> |
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.GetEjpackageItemInfo().
Idx
Field 'idx' in table 'ejpackage_item': Dictionary type Int, .NET type: int
The index in the packageDeclaration
public Int32FieldInfo Idx { 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.GetEjpackageItemInfo().
ItemId
Field 'item_id' in table 'ejpackage_item': Dictionary type Int, .NET type: int
The id of the element for which this item belongsDeclaration
public Int32FieldInfo ItemId { 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.GetEjpackageItemInfo().
ParentId
Field 'parent_id' in table 'ejpackage_item': Dictionary type FK, target: EjpackageItem, .NET type: int
The parent for this package item link. -1 if this is a toplevel item link.Declaration
public Int32FieldInfo ParentId { 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.GetEjpackageItemInfo().
ParentId_InnerJoin_EjpackageItem
Generated join from the foreign key ParentId in this table, to its target table EjpackageItemTableInfo.
Declaration
public TargetedInnerJoin<EjpackageItemTableInfo> ParentId_InnerJoin_EjpackageItem { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjpackageItemTableInfo> |
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.GetEjpackageItemInfo().
RefName
Field 'ref_name' in table 'ejpackage_item': Dictionary type String[256], .NET type: string
Used to reference the item in installscriptDeclaration
public StringFieldInfo RefName { 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.GetEjpackageItemInfo().
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.GetEjpackageItemInfo().