Skip to content

Latest commit

 

History

History
51 lines (37 loc) · 1.29 KB

log-events.md

File metadata and controls

51 lines (37 loc) · 1.29 KB
uid title description so.generated keywords so.topic so.envir
table-log_events
log_events table
System log
true
database table log_events
reference
onsite, online

log_events Table (364)

System log

Fields

Name Description Type Null
id Primary key PK
time_of_event When did the event take place DateTime
event_type Notification=1, warning=2, error=3, critical error=4 Int
event_group See NewLog::EventGroup Int
event_id See NewLog::EventId Int
target_id The id of the target entity (ticket.id, customer.id etc) Int
var1 Dynamic info Clob
var2 Dynamic info Clob
var3 Dynamic info Clob
var4 Dynamic info Clob
var5 Dynamic info Clob
source_user The user generating the event. 1=system, other=ejuser.id Int
source_user_desc Describing the id in source_user. eg user name or customer name or (System) Clob

log_events table relationship diagram

[!includedetails]

Indexes

Fields Types Description
id PK Clustered, Unique

Replication Flags

  • None

Security Flags

  • No access control via user's Role.