NOTES table

 

NOTES – This table is used to store notes for various object in the Track-IT pro database.

Ÿ      ID – The unique ID for a note. (PK)

Ÿ      LINKID – The unique ID of the item the note is attached to.

Ÿ      LINKTYPE – The type of item the note is attached to. "P" for Project, "E" for Employee etc.

Ÿ      NOTE – The note or memo.

Ÿ      DATE – The date the note was created.