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 |
---|---|
String |
Properties
CategoryId
Field 'category_id' in table 'notify': Dictionary type FK, .NET type: 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: 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, .NET type: 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: String
Text for custom notify messages
Declaration
public StringFieldInfo CustomMessage { 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 |
---|---|
Int32 |
Expires
Field 'expires' in table 'notify': Dictionary type DateTime, .NET type: 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: 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, .NET type: 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> |
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 |
TicketAlertId
Field 'ticket_alert_id' in table 'notify': Dictionary type FK, .NET type: 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, .NET type: 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: 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, .NET type: 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, .NET type: 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> |