Audit_AuditEvent and UserNotificationEvent tables in the database

Issue

• I would like to understand the purpose of eventType column in Audit_AuditEvent and deliveryType in UserNotificationEvent tables. In deliveryType column what is the meaning of the values e.g. 10000,10002 etc. ?

Environment

• Liferay DXP 7.0+

Resolution

• The eventType represents the Resource Action from the portal, which means, it shows what happened to certain objects.
  
  
• https://help.liferay.com/hc/en-us/articles/360028822152-Viewing-Audit-Events
  Resource Action: An action performed on the resource. This could be any of these: add, assign, delete, impersonate, login, login_failure, logout, unassign, or update.
   
• The relation between the database columns and the audit message: https://github.com/liferay/liferay-portal/blob/master/portal-kernel/src/com/liferay/portal/kernel/audit/AuditMessage.java
   
• The meaning of the values in deliveryType column. User Notification Delivery Constants
  https://github.com/liferay/liferay-portal/blob/master/portal-kernel/src/com/liferay/portal/kernel/model/UserNotificationDeliveryConstants.java