Class NotifyTableInfo
Table 'notify': This table contains the pop-up messages displayed for users for various events, such as 'new ticket', etc.
Implements
Inherited Members
Namespace: SuperOffice.CRM.Data
Assembly: SoDataBase.dll
Syntax
[DatabaseTable("notify")]
public class NotifyTableInfo : 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 Notify in the database dictionary: notify
Declaration
public const string DictionaryTableName = "notify"
Field Value
Type | Description |
---|---|
System.String |
Properties
CategoryId
Field 'category_id' in table 'notify': Dictionary type FK, target: EjCategory, .NET type: System.Int32
The category involed in this notification
Declaration
public Int32FieldInfo CategoryId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
CategoryId_InnerJoin_EjCategory
Generated join from the foreign key CategoryId in this table, to its target table EjCategoryTableInfo.
Declaration
public TargetedInnerJoin<EjCategoryTableInfo> CategoryId_InnerJoin_EjCategory { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjCategoryTableInfo> |
ChatNickName
Field 'chat_nick_name' in table 'notify': Dictionary type String[256], .NET type: System.String
Chat customer nick name in this notification
Declaration
public StringFieldInfo ChatNickName { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
ChatTopicId
Field 'chat_topic_id' in table 'notify': Dictionary type FK, target: ChatTopic, .NET type: System.Int32
Chat topic involed in this notification
Declaration
public Int32FieldInfo ChatTopicId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
ChatTopicId_InnerJoin_ChatTopic
Generated join from the foreign key ChatTopicId in this table, to its target table ChatTopicTableInfo.
Declaration
public TargetedInnerJoin<ChatTopicTableInfo> ChatTopicId_InnerJoin_ChatTopic { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<ChatTopicTableInfo> |
CustomMessage
Field 'custom_message' in table 'notify': Dictionary type String[256], .NET type: System.String
Text for custom notify messages
Declaration
public StringFieldInfo CustomMessage { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
CustomUrl
Field 'custom_url' in table 'notify': Dictionary type String[2049], .NET type: System.String
An URL which can be set with custom notification messages
Declaration
public StringFieldInfo CustomUrl { get; }
Property Value
Type | Description |
---|---|
StringFieldInfo |
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 Notify 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 |
---|---|
System.Int32 |
Expires
Field 'expires' in table 'notify': Dictionary type DateTime, .NET type: System.DateTime
When the notification expires, if it has not yet been displayed.
Declaration
public DateTimeFieldInfo Expires { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
NotifyId
Field 'id' in table 'notify': Dictionary type PK, .NET type: System.Int32
The primary key (auto-incremented)
Declaration
public Int32FieldInfo NotifyId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
OwnerId
Field 'owner_id' in table 'notify': Dictionary type FK, target: Ejuser, .NET type: System.Int32
The id of the user who is the original owner of this notification.
Declaration
public Int32FieldInfo OwnerId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
OwnerId_InnerJoin_Ejuser
Generated join from the foreign key OwnerId in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> OwnerId_InnerJoin_Ejuser { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjuserTableInfo> |
Registered
Field 'registered' in table 'notify': Dictionary type UtcDateTime, .NET type: System.DateTime
Registered when
Declaration
public DateTimeFieldInfo Registered { get; }
Property Value
Type | Description |
---|---|
DateTimeFieldInfo |
RegisteredAssociateId
Field 'registered_associate_id' in table 'notify': Dictionary type FK, target: Associate, .NET type: System.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> |
RuntimeDefinition
Definition of the table as described in the deployed runtime dictionary
Declaration
public static SoTable RuntimeDefinition { get; }
Property Value
Type | Description |
---|---|
SoTable |
TicketAlertId
Field 'ticket_alert_id' in table 'notify': Dictionary type FK, target: TicketAlert, .NET type: System.Int32
Ticket alert used when tickets are escalated
Declaration
public Int32FieldInfo TicketAlertId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
TicketAlertId_InnerJoin_TicketAlert
Generated join from the foreign key TicketAlertId in this table, to its target table TicketAlertTableInfo.
Declaration
public TargetedInnerJoin<TicketAlertTableInfo> TicketAlertId_InnerJoin_TicketAlert { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TicketAlertTableInfo> |
TicketId
Field 'ticket_id' in table 'notify': Dictionary type FK, target: Ticket, .NET type: System.Int32
The id of the ticket this notification message affects.
Declaration
public Int32FieldInfo TicketId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
TicketId_InnerJoin_Ticket
Generated join from the foreign key TicketId in this table, to its target table TicketTableInfo.
Declaration
public TargetedInnerJoin<TicketTableInfo> TicketId_InnerJoin_Ticket { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<TicketTableInfo> |
Type
Field 'type' in table 'notify': Dictionary type Int, .NET type: System.Int32
A number (enum) indicating the type of the notification.
Declaration
public Int32FieldInfo Type { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
User2Id
Field 'user2_id' in table 'notify': Dictionary type FK, target: Ejuser, .NET type: System.Int32
A second user involved in this notification
Declaration
public Int32FieldInfo User2Id { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
User2Id_InnerJoin_Ejuser
Generated join from the foreign key User2Id in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> User2Id_InnerJoin_Ejuser { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjuserTableInfo> |
UserId
Field 'user_id' in table 'notify': Dictionary type FK, target: Ejuser, .NET type: System.Int32
The id of the user who should be notified.
Declaration
public Int32FieldInfo UserId { get; }
Property Value
Type | Description |
---|---|
Int32FieldInfo |
UserId_InnerJoin_Ejuser
Generated join from the foreign key UserId in this table, to its target table EjuserTableInfo.
Declaration
public TargetedInnerJoin<EjuserTableInfo> UserId_InnerJoin_Ejuser { get; }
Property Value
Type | Description |
---|---|
TargetedInnerJoin<EjuserTableInfo> |