Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ComputerID | INT | 10 | null |
|
|
|||||
| LogName | VARCHAR | 100 | null |
|
|
|||||
| EventType | INT | 10 | null |
|
|
|||||
| 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
Close relationships within degrees of separation
