Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
AgentID | INT | 10 | 0 |
|
|
|||
ClientID | INT | 10 | √ | 0 |
|
|
||
LocationID | INT | 10 | √ | 0 |
|
|
||
ComputerID | INT | 10 | √ | 0 |
|
|
||
MonitorName | VARCHAR | 100 | null |
|
|
|||
MonitorType | VARCHAR | 8 |
|
|
||||
MonitorStatus | VARCHAR | 20 |
|
|
||||
MonitorLastFailDate | DATETIME | 19 | 1979-01-01 01:01:01 |
|
|
|||
MonitorNextScan | DATETIME | 19 | √ | null |
|
|
||
MonitorAddress | VARCHAR | 255 | √ | null |
|
|
||
MonitorCheckAction | VARCHAR | 266 | √ | null |
|
|
||
MonitorCheckActionDetails | MEDIUMTEXT | 16777215 | √ | null |
|
|
||
MonitorAlertActions | VARCHAR | 107 | √ | null |
|
|
||
MonitorAlertActionTitle | VARCHAR | 200 | null |
|
|
|||
MonitorAlertActionComment | VARCHAR | 255 | null |
|
|
|||
MonitorAlertMessage | TEXT | 65535 | null |
|
|
|||
MonitorIntervalSec | INT | 10 | null |
|
|