Table: System Notes Entity

Table: System Notes Entity

Holds system generated note information.

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
entity_typechar(50)Type of the associated entity
entity_idint(11)ID of the associated entity
reference_typechar(50)reference type
reference_idint(11)reference id
operation_typeenumoperation type
  • CREATE
  • UPDATE
  • DELETE
  • SERVICE_CALL
operation_sub_typechar(100)operation sub typesystemNote.operationSubtype.*
create_userint(11)ID of the user that created the entity
create_user_namevarchar(255)creating user 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
note_titlevarchar(255)note title
note_datatextnote data
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no

< Back to List