VNIVEISTABSALARIAISLOTACAO

8 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
VLOTACAO.CODCOLIGADA FKVNIVEISTABSALLOT_VLOTACAOR
VNIVEISTABSALARIAIS.CODCOLIGADA FKVNIVTABSALLOT_VNIVEISTABSALR
CODTABELA varchar 10 null
VNIVEISTABSALARIAIS.CODTABELA FKVNIVTABSALLOT_VNIVEISTABSALR
CODNIVEL varchar 10 null
VNIVEISTABSALARIAIS.CODNIVEL FKVNIVTABSALLOT_VNIVEISTABSALR
CODSECAO varchar 35 null
VLOTACAO.CODSECAO FKVNIVEISTABSALLOT_VLOTACAOR
CODFUNCAO varchar 10 null
VLOTACAO.CODFUNCAO FKVNIVEISTABSALLOT_VLOTACAOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
DATAVINCULO DDATETIME 16,3 √ null

Indexes

Constraint Name Type Sort Column(s)
PKVNIVEISTABSALARIAISLOTACAO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + CODTABELA + CODNIVEL + CODSECAO + CODFUNCAO

Relationships

Close relationships within degrees of separation