| Column Name | Ordinal Position |
|---|
| Column Name | Ordinal Position | Referenced Table |
|---|
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | LKNOTETYPEID | INT | ||||||||
|
Description: The unique Id for the LkNoteType table
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | NOTETYPE | NVARCHAR | ||||||||
|
Description: Text value of the note type (Annotation, Comment, etc)
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 4 | CREATED | DATETIME2 | ||||||||
|
Description: Record created time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 5 | CREATEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Time zone Offset for Created time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 7 | LASTMODIFIED | DATETIME2 | ||||||||
|
Description: Record Last Modified time
|
||||||||||
| Name | Type | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| 8 | LASTMODIFIEDTIMEZONEOFFSET | INT | ||||||||
|
Description: Time zone Offset for Modified time
|
||||||||||