Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idmessage | int8 | 19 | null |
|
|
||||||
| iddevice | int4 | 10 | √ | null |
|
|
|||||
| enabled | bool | 1 | true |
|
|
||||||
| messagetype | int4 | 10 | 0 |
|
|
||||||
| senddate | timestamptz | 35,6 | null |
|
|
||||||
| conversation_id | varchar | 2147483647 | √ | null |
|
|
|||||
| idevent | int8 | 19 | √ | null |
|
|
|||||
| longitude | numeric | 10,7 | √ | null |
|
|
|||||
| latitude | numeric | 10,7 | √ | null |
|
|
|||||
| messagestatus | int2 | 5 | √ | null |
|
|
|||||
| idmayauser | int4 | 10 | √ | null |
|
|
|||||
| device_aknowledge | varchar | 2147483647 | √ | null |
|
|
|||||
| devmessageid | int4 | 10 | 0 |
|
|
Identifier to be send to the device. We need to use an identifier within a constrained range that gets reused |
|||||
| location | varchar | 2147483647 | √ | null |
|
|
|||||
| body | varchar | 2147483647 | √ | null |
|
|
|||||
| viewed | bool | 1 | √ | false |
|
|
|||||
| receiveddate | timestamptz | 35,6 | √ | null |
|
|
|||||
| creationdate | timestamptz | 35,6 | now() |
|
|
||||||
| viewed_by_user | int4 | 10 | √ | null |
|
|
|||||
| viewed_at_time | timestamptz | 35,6 | √ | null |
|
|
|||||
| iddriver | int4 | 10 | √ | null |
|
|
The driver who sent the message |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_message | Primary key | Asc | idmessage |
| idx_message_conversation_id | Must be unique | Asc | conversation_id |
| idx_message_device | Performance | Asc | iddevice |
| idx_message_idmayauser | Performance | Asc | idmayauser |
| idx_message_messagetype | Performance | Asc | messagetype |
| idx_message_senddate | Performance | Asc | senddate |
| idx_message_status | Performance | Asc | messagestatus |
| UQ_message_idmessage | Must be unique | Asc | idmessage |
Relationships
Close relationships within degrees of separation
