Table: Note

Database schema and system attributes for Note.


ApprovalsSent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

ApprovalStatus

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ApprovedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ApprovedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

Caption

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 400

CreatedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

CreatedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

EditedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

EditedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

EntityId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignGuid

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

ForeignId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ForeignKey

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = 200

Guid

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: uniqueidentifier
  • Property Values:
    • MaxLength = 16

Id

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

IsAlert

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsPinned

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsPrivateNote

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

IsSystem

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

ModifiedByPersonAliasId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

ModifiedDateTime

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: datetime
  • Property Values:
    • MaxLength = 8

NoteTypeId

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

NoteUrl

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

NotificationsSent

  • Required Property: true
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: bit
  • Property Values:
    • MaxLength = 1

ParentNoteId

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: int
  • Property Values:
    • MaxLength = 4

Text

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: true
  • Data Type: nvarchar
  • Property Values:
    • MaxLength = -1

DigestSent

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean

DigestSent

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean

NoticeSent

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean

NoticeSent

  • Required Property: false
  • Lava Supported Property: true
  • Database Property: false
  • Data Type: Boolean