Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
IDTURMADISC | int | 4 | null |
|
|
|||
CODETAPA | smallint | 2 | null |
|
|
|||
TIPOETAPA | varchar | 1 | null |
|
|
|||
CODPROVA | smallint | 2 | null |
|
|
|||
USUARIO | varchar | 20 | null |
|
|
|||
DATA | DDATETIME | 16,3 | null |
|
|
|||
DESCRICAOATUAL | varchar | 100 | √ | null |
|
|
||
DESCRICAOANTERIOR | varchar | 100 | √ | null |
|
|
||
VALORATUAL | RMDVALOR4 | 17,4 | √ | null |
|
|
||
VALORANTERIOR | RMDVALOR4 | 17,4 | √ | null |
|
|
||
DTPREVISTAATUAL | DDATETIME | 16,3 | √ | null |
|
|
||
DTPREVISTAANTERIOR | DDATETIME | 16,3 | √ | null |
|
|
||
DTPROVAATUAL | DDATETIME | 16,3 | √ | null |
|
|
||
DTPROVAANTERIOR | DDATETIME | 16,3 | √ | null |
|
|
||
MEDIAATUAL | RMDVALOR4 | 17,4 | √ | null |
|
|
||
MEDIAANTERIOR | RMDVALOR4 | 17,4 | √ | null |
|
|
||
NUMQUESTOESATUAL | int | 4 | √ | null |
|
|
||
NUMQUESTOESANTERIOR | int | 4 | √ | null |
|
|
||
CODPROVATESTISATUAL | varchar | 16 | √ | null |
|
|
||
CODPROVATESTISANTERIOR | varchar | 16 | √ | null |
|
|
||
IDOUTLOOKLIVEATUAL | varchar | 2147483647 | √ | null |
|
|
||
IDOUTLOOKLIVEANTERIOR | varchar | 2147483647 | √ | null |
|
|
||
DTDEVOLUCAOAVALIACAOATUAL | DDATETIME | 16,3 | √ | null |
|
|
||
DTDEVOLUCAOAVALIACAOANTERIOR | DDATETIME | 16,3 | √ | null |
|
|
||
DTLIMITEENTREGAAVALATUAL | DDATETIME | 16,3 | √ | null |
|
|
||
DTLIMITEENTREGAAVALANTERIOR | DDATETIME | 16,3 | √ | null |
|
|
||
PERMITEENTREGAWEBATUAL | varchar | 1 | √ | null |
|
|
||
PERMITEENTREGAWEBANTERIOR | varchar | 1 | √ | null |
|
|
||
DISPONIVELALUNOSATUAL | varchar | 1 | √ | null |
|
|
||
DISPONIVELALUNOSANTERIOR | varchar | 1 | √ | null |
|
|
||
TIPOMODIFICACAO | varchar | 1 | √ | null |
|
|
||
FORMA | varchar | 1 | √ | 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) |
---|---|---|---|
PKSLOGPROVA | Primary key | Asc/Asc/Asc/Asc/Asc/Asc/Asc | CODCOLIGADA + IDTURMADISC + CODETAPA + TIPOETAPA + CODPROVA + USUARIO + DATA |
Diagram producer might be missing
No diagrams were produced please see application output for any errors