eventlogs

486665 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ComputerID INT 10 null
LogName VARCHAR 100 null
EventType INT 10 null
labtechlogmessages.EventType Implied ConstraintR
Source VARCHAR 100 null
TimeGen DATETIME 19 null
Message VARCHAR 1000 null
EventID INT 10 null
Last_date TIMESTAMP 19 CURRENT_TIMESTAMP
blacklistID INT UNSIGNED 10 0

Indexes

Constraint Name Type Sort Column(s)
blacklistID Performance Asc blacklistID
ComputerID Performance Asc ComputerID
EventID Performance Asc EventID
EventType Performance Asc EventType
LogName Performance Asc LogName
Source Performance Asc Source
TimeGen Performance Asc TimeGen

Relationships