Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ID | int identity | 4 | √ | null |
|
|
||
| IDLOCALIZACAO | int | 4 | null |
|
|
|||
| CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
| CHAPA | DCHAPA | 16 | null |
|
|
|||
| OPERACAO | char | 1 | null |
|
|
|||
| DATA_LOG | datetime | 16,3 | null |
|
|
|||
| USUARIO | varchar | 20 | null |
|
|
|||
| USUARIODB | varchar | 256 | null |
|
|
|||
| PROCESSOLOG | varchar | 100 | null |
|
|
|||
| LATITUDE | varchar | 30 | √ | null |
|
|
||
| LONGITUDE | varchar | 30 | √ | null |
|
|
||
| RUA | varchar | 100 | √ | null |
|
|
||
| NUMERO | varchar | 8 | √ | null |
|
|
||
| COMPLEMENTO | DCOMPLEMENTO | 60 | √ | null |
|
|
||
| BAIRRO | DBAIRRO | 80 | √ | null |
|
|
||
| ESTADO | varchar | 2 | √ | null |
|
|
||
| CIDADE | DCIDADE | 32 | √ | null |
|
|
||
| CEP | DCEP | 9 | √ | null |
|
|
||
| PAIS | varchar | 16 | √ | null |
|
|
||
| RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
| RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
| RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
| RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||
| CODLOCALIZACAO | varchar | 250 | √ | null |
|
|
||
| CONTROLE | smallint | 2 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PKALOCALIZACAOLOG | Primary key | Asc | ID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors