NotifcationEntity
Table: notification. Import the misspelled class name NotifcationEntity.
- id: number — primary key
- topic: string — topic or category
- title: string
- body: string
- targetType: ALL | SPECIFIC_ROLES | SPECIFIC_USERS
- data: jsonb — custom payload
AuditLogEntity
Table: audit_log — tracks user actions across the system.
ChangeLogEntity / ChangeLogReactionsEntity
Tables: change_log, change_log_reactions — activity feed keyed by pluginName + referencePrefix + referenceNumber. Prefer ChangeLogService for writes/reads.
- message, metadata, isCreatedBySystem
- createdBy → UserEntity; replyTo → parent ChangeLogEntity
- reactions → ChangeLogReactionsEntity (reaction, reactBy)
TagEntity
Table: tags — generic tagging across the ERP.
- id: number — primary key
- name: string — unique tag name
- userId: number — creator