Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idecmevent | int8 | 19 | null |
|
|
||||||
| idevent | int8 | 19 | null |
|
|
||||||
| idunit | int4 | 10 | null |
|
|
||||||
| idecmeventtype | int4 | 10 | null |
|
|
||||||
| idecmperiodicity | int4 | 10 | null |
|
|
||||||
| idecmreason | int4 | 10 | null |
|
|
||||||
| idecmbus | int4 | 10 | null |
|
|
||||||
| rawstring | varchar | 2147483647 | null |
|
|
||||||
| clid | int4 | 10 | null |
|
|
||||||
| senddate | timestamptz | 35,6 | null |
|
|
||||||
| receivedate | timestamptz | 35,6 | null |
|
|
||||||
| latitude | numeric | 10,7 | null |
|
|
||||||
| longitude | numeric | 10,7 | null |
|
|
||||||
| ignition_on | bool | 1 | √ | null |
|
|
|||||
| iddevice | int4 | 10 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| current_ecmevent_parameter_pkey | Primary key | Asc | idunit |
Relationships
Close relationships within degrees of separation
