Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CODPESSOA | int | 4 | null |
|
|
|||||
| CODEXPPROF | int | 4 | null |
|
|
|||||
| CODDETEXPPROF | int | 4 | null |
|
|
|||||
| CARGO | varchar | 70 | √ | null |
|
|
||||
| SETOR | varchar | 70 | √ | null |
|
|
||||
| MESINICIO | smallint | 2 | √ | null |
|
|
||||
| ANOINICIO | smallint | 2 | √ | null |
|
|
||||
| MESTERMINO | smallint | 2 | √ | null |
|
|
||||
| ANOTERMINO | smallint | 2 | √ | null |
|
|
||||
| SALARIO | RMDVALOR2 | 17,2 | √ | null |
|
|
||||
| REFERENCIANOME | varchar | 32 | √ | null |
|
|
||||
| REFERENCIAFONE | varchar | 15 | √ | null |
|
|
||||
| CODNIVELHIERARQUICO | int | 4 | √ | null |
|
|
||||
| DIAINICIO | int | 4 | √ | null |
|
|
||||
| DIATERMINO | int | 4 | √ | null |
|
|
||||
| RECCREATEDBY | varchar | 50 | √ | null |
|
|
||||
| RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||||
| RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||||
| RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
||||
| DTINICIO | DDATETIME | 16,3 | √ | null |
|
|
||||
| DTTERMINO | DDATETIME | 16,3 | √ | null |
|
|
||||
| DESCATIV | varchar | 4000 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PKVDETEXPPROF | Primary key | Asc/Asc/Asc | CODPESSOA + CODEXPPROF + CODDETEXPPROF |
Relationships
Close relationships within degrees of separation
