note_entity - Notes Entity

Note information for notes created by agent users.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

parent_type

char(100)

Type of parent

parent_id

int(11)

ID of parent category

category_id

int(11)

Note category ID

subject

varchar(255)

Note subject

body

text

Note body

author_id

int(11)

author ID

author_name

varchar(255)

author Name

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated

remote_addr

char(20)

IP address of the client machine

deleted

tinyint(4)

Whether or not the entity was deleted

1 - yes, 0 - no

type

enum

expiration_date

datetime


How did we do?


Powered by HelpDocs (opens in a new tab)