Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| IDLOG | DTIDENTIFICADOR | 4 | null |
|
|
|||
| CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
| IDMOV | DINTEGER | 4 | null |
|
|
|||
| NUMALTERACAO | DINTEGER | 4 | √ | null |
|
|
||
| DSCNOMETABELA | DTDESCRICAO | 100 | √ | null |
|
|
||
| DSCNOMECAMPO | DTDESCRICAO | 100 | √ | null |
|
|
||
| NSEQITMMOV | DINTEGER | 4 | √ | null |
|
|
||
| CODTRB | varchar | 10 | √ | null |
|
|
||
| CODUSUARIO | varchar | 20 | √ | null |
|
|
||
| DTHALTERACAO | DDATETIME | 16,3 | √ | null |
|
|
||
| VALANTSTRING | DTDESCRICAO | 100 | √ | null |
|
|
||
| VALANTCURRENCY | RMDVALOR4 | 17,4 | √ | null |
|
|
||
| VALANTDATAHORA | DDATETIME | 16,3 | √ | null |
|
|
||
| VALANTMEMO | MEMO | 2147483647 | √ | null |
|
|
||
| RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
| RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
| RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
| RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PKTITMLOG | Primary key | Asc/Asc | IDLOG + CODCOLIGADA |
| TXTTITMLOG | Performance | Asc/Asc/Asc | CODCOLIGADA + IDMOV + NUMALTERACAO |
Diagram producer might be missing
No diagrams were produced please see application output for any errors