Class TimestampsTableInfo
Table 'timestamps': Timestamp information
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("timestamps")]
public class TimestampsTableInfo : 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.GetTimestampsInfo().
Fields
DictionaryTableName
Conceptual name of table Timestamps in the database dictionary: timestamps
Declaration
public const string DictionaryTableName = "timestamps"
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.GetTimestampsInfo().
Properties
ActivateTickets
Field 'activate_tickets' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when tickets should be checked for activation.Declaration
public DateTimeFieldInfo ActivateTickets { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
ActiveTickets
Field 'active_tickets' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Declaration
public DateTimeFieldInfo ActiveTickets { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
Autologout
Field 'autologout' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when users should be checked for automatic logout.Declaration
public DateTimeFieldInfo Autologout { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
BuildFaq
Field 'build_faq' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when the FAQ search tree was last rebuilt.Declaration
public DateTimeFieldInfo BuildFaq { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
CriticalEmail
Field 'critical_email' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when we last emailed a critical email to panic_email (usually error@superoffice.com).Declaration
public DateTimeFieldInfo CriticalEmail { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
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.GetTimestampsInfo().
DeleteTempTicket
Field 'delete_temp_ticket' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when tickets should be checked for deletion.Declaration
public DateTimeFieldInfo DeleteTempTicket { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
DictionaryTableNumber
Table number for table Timestamps 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.GetTimestampsInfo().
EjournalCron
Field 'ejournal_cron' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for the last time ejournalCron was started.Declaration
public DateTimeFieldInfo EjournalCron { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
LastTicketdel
Field 'last_ticketdel' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when we last physically removed tickets tagged for deletion.Declaration
public DateTimeFieldInfo LastTicketdel { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
MailFilter
Field 'mail_filter' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for the last time importMail was started.Declaration
public DateTimeFieldInfo MailFilter { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
MailSender
Field 'mail_sender' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for the last time mailSender was started.Declaration
public DateTimeFieldInfo MailSender { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
Mailsync
Field 'mailsync' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for syncing crm inbox2 email accountsDeclaration
public DateTimeFieldInfo Mailsync { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
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.GetTimestampsInfo().
TicketAlert
Field 'ticket_alert' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when tickets should be checked for escalation.Declaration
public DateTimeFieldInfo TicketAlert { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().
TimestampsId
Field 'id' in table 'timestamps': Dictionary type PK, .NET type: int
The primary key (auto-incremented)Declaration
public Int32FieldInfo TimestampsId { 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.GetTimestampsInfo().
WeekStat
Field 'week_stat' in table 'timestamps': Dictionary type DateTime, .NET type: DateTime
Timestamp for when the week statistics was last sent.Declaration
public DateTimeFieldInfo WeekStat { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
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.GetTimestampsInfo().