Notes Table

Applies to QAComplete 12.93 SaaS, last modified on November 01, 2021

Description

For any item that has the Notes tab, the Notes table stores information on notes. The values of the FKId and EntityCode columns specify the item to which a note is attached.

Columns

The table contains the following columns:

DateCreated  :  datetime, allows null: no

The date and time when the note was created.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

DateUpdated  :  datetime, allows null: no

The date and time when the note was last updated.

The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.

Description  :  text (max 2,147,483,647 chars), allows null: no

The note content.

This column corresponds to a field that can be available for rich editing.

EntityCode  :  varchar (max 100 chars), allows null: no

The module name of the related item.

You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.

FKId  :  int, allows null: no

The ID of the item to which the note is attached.

NotesId  :  int, allows null: no, default: auto-generated

The unique numeric identifier of the note.

NotesTypeCode  :  varchar (max 100 chars), allows null: no

The column is reserved for system use only.

Seq  :  int, allows null: no

The ordinal number of the note among others notes attached to the same item.

UpdateUserId  :  int, allows null: no

The ID of the user who posted the note.

See Also

Notes View
Crossmodules

Highlight search results