Class DbiAgentScheduleTableInfo
Table 'dbi_agent_schedule': DBI agent schedule settings
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("dbi_agent_schedule")]
public class DbiAgentScheduleTableInfo : 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 DbiAgentSchedule in the database dictionary: dbi_agent_schedule
Declaration
public const string DictionaryTableName = "dbi_agent_schedule"
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
AgentId
Field 'agent_id' in table 'dbi_agent_schedule': Dictionary type FK, target: DbiAgent, .NET type: Int32
AgentDeclaration
public Int32FieldInfo AgentId { 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
AgentId_InnerJoin_DbiAgent
Generated join from the foreign key AgentId in this table, to its target table DbiAgentTableInfo.
Declaration
public TargetedInnerJoin<DbiAgentTableInfo> AgentId_InnerJoin_DbiAgent { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<DbiAgentTableInfo> |
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
DbiAgentScheduleId
Field 'id' in table 'dbi_agent_schedule': Dictionary type PK, .NET type: Int32
Primary keyDeclaration
public Int32FieldInfo DbiAgentScheduleId { 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
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
DictionaryTableNumber
Table number for table DbiAgentSchedule 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
IdString
Field 'id_string' in table 'dbi_agent_schedule': Dictionary type String[256], .NET type: String
A field for an id_string which may be used to access the agent scheduleDeclaration
public StringFieldInfo IdString { 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
ReceivedObjects
Field 'received_objects' in table 'dbi_agent_schedule': Dictionary type Int, .NET type: Int32
Number of objects received during the last syncronizationDeclaration
public Int32FieldInfo ReceivedObjects { 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
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
ScheduleId
Field 'schedule_id' in table 'dbi_agent_schedule': Dictionary type FK, target: Schedule, .NET type: Int32
Update scheduleDeclaration
public Int32FieldInfo ScheduleId { 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
ScheduleId_InnerJoin_Schedule
Generated join from the foreign key ScheduleId in this table, to its target table ScheduleTableInfo.
Declaration
public TargetedInnerJoin<ScheduleTableInfo> ScheduleId_InnerJoin_Schedule { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ScheduleTableInfo> |
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
ScriptId
Field 'script_id' in table 'dbi_agent_schedule': Dictionary type FK, target: Ejscript, .NET type: Int32
Communication scriptDeclaration
public Int32FieldInfo ScriptId { 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
ScriptId_InnerJoin_Ejscript
Generated join from the foreign key ScriptId in this table, to its target table EjscriptTableInfo.
Declaration
public TargetedInnerJoin<EjscriptTableInfo> ScriptId_InnerJoin_Ejscript { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjscriptTableInfo> |
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
SentObjects
Field 'sent_objects' in table 'dbi_agent_schedule': Dictionary type Int, .NET type: Int32
Number of objects sent during the last syncronizationDeclaration
public Int32FieldInfo SentObjects { 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