Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| serialnumber | text | 2147483647 | √ | null |
|
|
GPS device serialnumber |
||||
| erpid | varchar | 20 | √ | null |
|
|
Netsuite customer identifier |
||||
| producto | text | 2147483647 | √ | null |
|
|
Product name |
||||
| alias | varchar | 128 | √ | null |
|
|
Economic number |
||||
| tmc | varchar | 20 | √ | null |
|
|
Tmc (Antena) identifier |
||||
| ultima_posicion | timestamp | 29,6 | √ | null |
|
|
Last time it sent a positioning message |
||||
| status | text | 2147483647 | √ | null |
|
|
If serialnumber and unit are both enabled = Active |
||||
| iddevice | int4 | 10 | √ | null |
|
|
Device database identifier |
||||
| idtechnicalaccount | int4 | 10 | √ | null |
|
|
Technicalaccount database identifier |
||||
| idproduct | int4 | 10 | √ | null |
|
|
Product database identifier |
||||
| idunit | int4 | 10 | √ | null |
|
|
Unit database identifier |
||||
| clientcode | varchar | 16 | √ | null |
|
|
Command Center customer identifier |
||||
| custname | varchar | 256 | √ | null |
|
|
Customer name |
||||
| pais | text | 2147483647 | √ | null |
|
|
Contry |
||||
| latitude | numeric | 10,7 | √ | null |
|
|
Last knwon latitude |
||||
| longitude | numeric | 10,7 | √ | null |
|
|
Last knwon longitude |
||||
| linea | varchar | 32 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
