The note table holds comments that you can store about the components that are used for loads and unloads. You can store notes about all of the onpload components: projects, devices, formats, maps, queries, filters, and load and unload jobs. For information about creating a note, see Notes Button.
| Column | Type | Description |
|---|---|---|
| type | CHAR(18) | Specifies the type of component to which this note is attached |
| formid | INTEGER | Corresponds to the formid of the component specified in the type column (The two columns together uniquely identify the component to which the note is attached.) |
| projectid | INTEGER | ID of project to which this note belongs (foreign key to the project table) |
| createdate | DATE | Date that the note was created |
| modifydate | DATE | Date that the note was last modified |
| note | TEXT | Text of the note |