VMEDIDASESTATISTICAS

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
PFUNCAO.CODCOLIGADA FKVMEDIDASESTATISTICAS_PFUNCAOR
CODFUNCAO varchar 10 null
PFUNCAO.CODIGO FKVMEDIDASESTATISTICAS_PFUNCAOR
CODMEDIDASESTATISTICAS int 4 null
QTDEPESSOAS int 4 √ null
MENSALARIOEMP decimal 20,2 √ null
MAIORSALARIOEMP decimal 20,2 √ null
SALARIOMEDIOEMP decimal 20,2 √ null
PRIMQUARTILEMP decimal 20,2 √ null
MEDIANAEMP decimal 20,2 √ null
TERQUARTILEMP decimal 20,2 √ null
MENSALARIOMERC decimal 20,2 √ null
MAIORSALARIOMERC decimal 20,2 √ null
SALARIOMEDIOMERC decimal 20,2 √ null
PRIMQUARTILMERC decimal 20,2 √ null
MEDIANAMERC decimal 20,2 √ null
TERQUARTILMERC decimal 20,2 √ null
CODPESQUISASALARIAL int 4 null
VPESQUISASALARIAL.CODPESQUISASALARIAL FKVMEDIDASESTAT_VPESQSALARIALR
TIPO varchar 50 √ 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)
PKVMEDIDASESTATISTICAS Primary key Asc CODMEDIDASESTATISTICAS

Relationships

Close relationships within degrees of separation