| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| idoperacaorota | int8 | 19 | null |
|
|
|||||
| descricao | varchar | 45 | null |
|
|
|||||
| observacao | varchar | 4000 | √ | null |
|
|
||||
| datainiciovigencia | date | 13 | √ | null |
|
|
||||
| datafimvigencia | date | 13 | √ | null |
|
|
||||
| valor | numeric | 18,6 | null |
|
|
|||||
| volume | numeric | 18,6 | null |
|
|
|||||
| idoperacao | int8 | 19 | null |
|
|
|||||
| idrota | int8 | 19 | √ | null |
|
|
||||
| idlocal | int8 | 19 | null |
|
|
|||||
| idparceiro | int8 | 19 | null |
|
|
|||||
| idsegmento | int8 | 19 | null |
|
|
|||||
| idusuario | int8 | 19 | √ | null |
|
|
||||
| codigoerp | varchar | 80 | √ | null |
|
|
||||
| wsversao | int8 | 19 | √ | null |
|
|
Showing 1 to 15 of 15 entries
Table contained 0 rows
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk687771c8 | Primary key | Asc | idoperacaorota |
| idx150c1502 | Performance | Asc | idlocal |
| idx1561b4c3 | Performance | Asc | idsegmento |
| idx26f8aed9 | Performance | Asc | idparceiro |
| idx7fb241c1 | Performance | Asc | idrota |
| idxb6466d16 | Performance | Asc | idusuario |
| idxc7b34cc9 | Performance | Asc | idoperacao |
| idxwsversao_687771c8 | Performance | Desc | wsversao |
| uc43e5dcb2 | Must be unique | Asc | codigoerp |
Showing 1 to 9 of 9 entries
Graphviz Needed!
SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.