Table: Notes Entity

Table: Notes Entity

Note information for notes created by agent users.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
parent_typechar(100)Type of parent
parent_idint(11)ID of parent category
category_idint(11)Note category ID
subjectvarchar(255)Note subject
bodytextNote body
author_idint(11)author ID
author_namevarchar(255)author Name
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated
remote_addrchar(20)IP address of the client machine
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List