Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idlocalpositivacao | int8 | 19 | null |
|
|
||||||
| dataultimoatendimento | date | 13 | √ | null |
|
|
|||||
| dataultimopedido | date | 13 | √ | null |
|
|
|||||
| dataultimanotafiscal | date | 13 | √ | null |
|
|
|||||
| dataprimeiracompra | date | 13 | √ | null |
|
|
|||||
| idlocal | int8 | 19 | √ | null |
|
|
|||||
| idparceiro | int8 | 19 | √ | null |
|
|
|||||
| codigoerp | varchar | 80 | √ | null |
|
|
|||||
| wsversao | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk40627171 | Primary key | Asc | idlocalpositivacao |
| idx2ae19f42 | Performance | Asc | idlocal |
| idx36820ee | Performance | Asc | idparceiro |
| idxwsversao_40627171 | Performance | Desc | wsversao |
| ucd0bb0be9 | Must be unique | Asc | codigoerp |



