log_events Table (364)
•
Environment: onsite, online
Some tooltip text!
• 1 minute to read
• 1 minute to read
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 | ● |
Indexes
| Fields | Types | Description |
|---|---|---|
| id | PK | Clustered, Unique |
Replication Flags
- None
Security Flags
- No access control via user's Role.