Notification.

Show:

ID_NOTIFICATION

Int(11) UNSIGNED

Unique identifier.

ID_PARENT

Int(11)

ID parent.

ID_PROFIL

Int(11)

TAB_PROFIL.ID_PROFIL.

ID profil.

NOTIFICATION_CATEGORY

Enum

Notification category.

  • activity
  • thread

NOTIFICATION_CREATEDAT

DATETIME

Date of creation.


Default: CURRENT_TIMESTAMP

NOTIFICATION_CREATEDBY

Int(11)

TAB_PROFIL.ID_PROFIL.

ID Profil créateur de la notification. 0 Quand système

NOTIFICATION_PARAMS

JSON

List of parameter (json format)

NOTIFICATION_PARENT_TYPE

Enum

Parent type.

  • absencesreport
  • contract
  • delivery
  • positioning
  • contact
  • opportunity
  • company
  • project
  • order
  • invoice
  • purchase
  • payment
  • inactivity
  • groupment
  • advantage
  • action
  • timesreport
  • expensesreport
  • candidate
  • resource
  • product
  • quotation
  • app:celebrations
  • followeddocument
  • appentity

NOTIFICATION_STATE

Enum UNSIGNED

State of notification

  • new
  • read


Default: read

NOTIFICATION_TYPE

Enum

Notification type

  • autotimesheet
  • autoexpense
  • autotimeexpense
  • pending
  • validated
  • rejected
  • refused
  • deleted
  • created
  • shared
  • mention
  • daily
  • weekly
  • response
  • monthly