Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| CODCOLIGADA | DCODCOLIGADA | 2 | null |
|
|
|||
| IDLOGATIVIDADEPROF | int | 4 | null |
|
|
|||
| IDATIVIDADEPROF | int | 4 | null |
|
|
|||
| CODPROF | varchar | 10 | null |
|
|
|||
| CARGAHORARIA | RMDVALOR4 | 17,4 | √ | null |
|
|
||
| CARGAHORARIAANT | RMDVALOR4 | 17,4 | √ | null |
|
|
||
| EQUIVHORAAULA | int | 4 | √ | null |
|
|
||
| EQUIVHORAAULAANT | int | 4 | √ | null |
|
|
||
| VALORHORA | RMDVALOR4 | 17,4 | √ | null |
|
|
||
| VALORHORAANT | RMDVALOR4 | 17,4 | √ | null |
|
|
||
| DTINICIO | DDATETIME | 16,3 | √ | null |
|
|
||
| DTINICIOANT | DDATETIME | 16,3 | √ | null |
|
|
||
| DTTERMINO | DDATETIME | 16,3 | √ | null |
|
|
||
| DTTERMINOANT | DDATETIME | 16,3 | √ | null |
|
|
||
| CODCCUSTO | varchar | 25 | √ | null |
|
|
||
| CODCCUSTOANT | varchar | 25 | √ | null |
|
|
||
| REMUNERADA | varchar | 1 | √ | null |
|
|
||
| REMUNERADAANT | varchar | 1 | √ | null |
|
|
||
| IDATIVIDADEEXTRA | int | 4 | √ | null |
|
|
||
| IDATIVIDADEEXTRAANT | int | 4 | √ | null |
|
|
||
| IDOFERTA | int | 4 | √ | null |
|
|
||
| DESCONSIDERAPONTO | varchar | 1 | √ | null |
|
|
||
| DESCONSIDERAPONTOANT | varchar | 1 | √ | null |
|
|
||
| COMPOESALARIO | varchar | 1 | √ | null |
|
|
||
| COMPOESALARIOANT | varchar | 1 | √ | null |
|
|
||
| TIPOALTERACAO | varchar | 1 | null |
|
|
|||
| RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
| RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
| RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
| RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||
| STATUS | int | 4 | √ | null |
|
|
||
| STATUSANT | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PKSLOGATIVIDADEPROFESSOR | Primary key | Asc/Asc/Asc | CODCOLIGADA + IDATIVIDADEPROF + IDLOGATIVIDADEPROF |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| CK__SLOGATIVI__DESCO__6799E021 | ([DESCONSIDERAPONTOANT]='S' OR [DESCONSIDERAPONTOANT]='N') |
| CK__SLOGATIVI__DESCO__66A5BBE8 | ([DESCONSIDERAPONTO]='S' OR [DESCONSIDERAPONTO]='N') |
Diagram producer might be missing
No diagrams were produced please see application output for any errors