Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idconversasituacao | int8 | 19 | null |
|
|
||||||
| idconversa | int8 | 19 | null |
|
|
||||||
| idconversamensagem | int8 | 19 | √ | null |
|
|
|||||
| idusuariogerador | int8 | 19 | null |
|
|
||||||
| idusuariodestinatario | int8 | 19 | √ | null |
|
|
|||||
| datavizualizacao | int8 | 19 | √ | null |
|
|
|||||
| idnvizualizado | int2 | 5 | null |
|
|
||||||
| idnnotificado | int2 | 5 | null |
|
|
||||||
| idnativo | int2 | 5 | null |
|
|
||||||
| codigoerp | varchar | 80 | √ | null |
|
|
|||||
| wsversao | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk6bdbd5d6 | Primary key | Asc | idconversasituacao |
| idx2083a7aa | Performance | Asc | idusuariogerador |
| idx56ed7fe0 | Performance | Asc | idconversa |
| idx66f771f0 | Performance | Asc | idconversamensagem |
| idxb5730b93 | Performance | Asc | idusuariodestinatario |
| idxwsversao_6bdbd5d6 | Performance | Desc | wsversao |
| uca41187e4 | Must be unique | Asc | codigoerp |
Relationships
Close relationships within degrees of separation
