Database – Notes Entity (note_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 |