Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idalert | int8 | 19 | null |
|
|
||||||
| relevantinfo | varchar | 2000 | null |
|
|
||||||
| enabled | bool | 1 | true |
|
|
||||||
| active | bool | 1 | √ | true |
|
|
|||||
| alert_type | int4 | 10 | √ | null |
|
|
|||||
| idalertconf | int4 | 10 | null |
|
|
||||||
| alertdate | timestamptz | 35,6 | now() |
|
|
||||||
| iddevice | int4 | 10 | √ | null |
|
|
|||||
| creationdate | timestamptz | 35,6 | √ | now() |
|
|
|||||
| additionalinfo | hstore | 2147483647 | √ | null |
|
|
|||||
| latitude | numeric | 10,7 | √ | null |
|
|
|||||
| longitude | numeric | 10,7 | √ | null |
|
|
|||||
| odometer | numeric | 10,2 | √ | null |
|
|
|||||
| location | hstore | 2147483647 | √ | null |
|
|
|||||
| speed | float4 | 8,8 | √ | null |
|
|
|||||
| ackcomment | varchar | 280 | √ | null |
|
|
The comment made on an acknowledged alert |
||||
| ackcommentuser | int4 | 10 | √ | null |
|
|
The user who made the ackcomment the alert |
||||
| ackcommentdate | timestamptz | 35,6 | √ | null |
|
|
The date when the ackcomment was made |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_alertconfuserdata | Primary key | Asc | idalert |
| idx_alert_alertdate | Performance | Asc | alertdate |
| idx_alert_creationdate | Performance | Asc | creationdate |
| idx_alert_device | Performance | Asc | iddevice |
| idx_alert_idalertconf | Performance | Asc | idalertconf |
| UQ_alert_idalert | Must be unique | Asc | idalert |
Relationships
Close relationships within degrees of separation
