Information for the NoteType

Columns

  • Id (datatype: int) Required Primary Key
  • IsSystem (datatype: bit) Required Primary Key
  • EntityTypeId (datatype: int) Required Primary Key
  • Name (datatype: nvarchar(100)) Required Primary Key
  • EntityTypeQualifierColumn (datatype: nvarchar(50)) Required Primary Key
  • EntityTypeQualifierValue (datatype: nvarchar(200)) 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
  • UserSelectable (datatype: bit) Required Primary Key
  • IconCssClass (datatype: nvarchar(100)) Required Primary Key
  • Order (datatype: int) Required Primary Key
  • ForeignGuid (datatype: uniqueidentifier) Required Primary Key
  • ForeignId (datatype: int) Required Primary Key
  • RequiresApprovals (datatype: bit) Required Primary Key
  • AllowsWatching (datatype: bit) Required Primary Key
  • AllowsReplies (datatype: bit) Required Primary Key
  • MaxReplyDepth (datatype: int) Required Primary Key
  • BackgroundColor (datatype: nvarchar(100)) Required Primary Key
  • FontColor (datatype: nvarchar(100)) Required Primary Key
  • BorderColor (datatype: nvarchar(100)) Required Primary Key
  • SendApprovalNotifications (datatype: bit) Required Primary Key
  • AutoWatchAuthors (datatype: bit) Required Primary Key
  • ApprovalUrlTemplate (datatype: nvarchar(max)) Required Primary Key
  • AllowsAttachments (datatype: bit) Required Primary Key
  • BinaryFileTypeId (datatype: int) Required Primary Key
  • Color (datatype: nvarchar(100)) Required Primary Key
  • FormatType (datatype: int) Required Primary Key
  • IsMentionEnabled (datatype: bit) Required Primary Key