Project
>
Touchworks
>
User databases
>
Works
>
Tables
> dbo.NoteForm_NAW_Instance
Touchworks 25.2
[dbo].[NoteForm_NAW_Instance]
MS_Description
Child of Instance_Header. (This is where each version of the note body is stored)
Columns
Key
Name
Data Type
Max Length (Bytes)
Nullability
Description
InstanceID
[dbo].[uniqueid]
9
NOT NULL
Key to the Noteform_NAW_Instance table
InstanceBody
varchar(max)
max
NULL allowed
Obsolete (use InstanceBodyCompressed)
HeaderID
[dbo].[uniqueid]
9
NULL allowed
Points to NoteForm_NAW_Instance_Header.HeaderID
CreateDTTM
datetime
8
NOT NULL
When the row was inserted.
CreateByID
[dbo].[uniqueid]
9
NOT NULL
The user who added the row. Link to IDX_User.ID
OwnerID
[dbo].[uniqueid]
9
NOT NULL
The owner of the note. link to IDX_User.ID
InstanceBodyCompressed
varbinary(max)
max
NULL allowed
The XML payload of the note content
IsArchived
bit
1
NULL allowed
Is BLOB data moved to Archive Database(0/1)?