Information for the Note

Columns

• Id (datatype: int) Required Primary Key
• IsSystem (datatype: bit) Required Primary Key
• NoteTypeId (datatype: int) Required Primary Key
• EntityId (datatype: int) Required Primary Key
• Caption (datatype: nvarchar(200)) Required Primary Key
• IsAlert (datatype: bit) Required Primary Key
• Text (datatype: nvarchar(max)) Required Primary Key
• Guid (datatype: uniqueidentifier) Required Primary Key
• CreatedDateTime (datatype: datetime) Required Primary Key
• ModifiedDateTime (datatype: datetime) Required Primary Key
• CreatedByPersonAliasId (datatype: int) Required Primary Key
• ModifiedByPersonAliasId (datatype: int) Required Primary Key
• ForeignKey (datatype: nvarchar(100)) Required Primary Key
• ForeignGuid (datatype: uniqueidentifier) Required Primary Key
• ForeignId (datatype: int) Required Primary Key
• IsPrivateNote (datatype: bit) Required Primary Key
• ParentNoteId (datatype: int) Required Primary Key
• ApprovalStatus (datatype: int) Required Primary Key
• ApprovedByPersonAliasId (datatype: int) Required Primary Key
• ApprovedDateTime (datatype: datetime) Required Primary Key
• NotificationsSent (datatype: bit) Required Primary Key
• ApprovalsSent (datatype: bit) Required Primary Key
• NoteUrl (datatype: nvarchar(max)) Required Primary Key
• EditedDateTime (datatype: datetime) Required Primary Key
• EditedByPersonAliasId (datatype: int) Required Primary Key
• IsPinned (datatype: bit) Required Primary Key