MAVAINDICESTAREFA

828 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTAREFA.CODCOLIGADA FKMAVAINDICESTAREFA_MTAREFAR
GCOLIGADA.CODCOLIGADA FKMAVAINDICESTAREFA_GCOLIGADAR
MPRJ.CODCOLIGADA FKMAVAINDICESTAREFA_MPRJR
MAVA.CODCOLIGADA FKMAVAINDICESTAREFA_MAVAR
MPERIODO.CODCOLIGADA FKMAVAINDICESTAREFA_MPERIODOR
IDTRF int 4 null
MTAREFA.IDTRF FKMAVAINDICESTAREFA_MTAREFAR
IDPRJ int 4 null
MAVA.IDPRJ FKMAVAINDICESTAREFA_MAVAR
MPERIODO.IDPRJ FKMAVAINDICESTAREFA_MPERIODOR
MTAREFA.IDPRJ FKMAVAINDICESTAREFA_MTAREFAR
MPRJ.IDPRJ FKMAVAINDICESTAREFA_MPRJR
IDPERIODO int 4 null
MPERIODO.IDPERIODO FKMAVAINDICESTAREFA_MPERIODOR
IDAVA int 4 null
MAVA.IDAVA FKMAVAINDICESTAREFA_MAVAR
COTA numeric 40,4 √ null
COTR numeric 40,4 √ null
CRTR numeric 40,4 √ null
VC numeric 40,4 √ null
VC1 numeric 40,4 √ null
PV numeric 40,4 √ null
PV1 numeric 40,4 √ null
IDC numeric 40,4 √ null
IDP numeric 40,4 √ null
IDD numeric 40,4 √ null
EPT numeric 40,4 √ null
EPT1 numeric 40,4 √ null
ENT numeric 40,4 √ null
ENT1 numeric 40,4 √ null
ENT2 numeric 40,4 √ 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)
PKMAVAINDICESTAREFA Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDTRF + IDPRJ + IDPERIODO + IDAVA
MXMAVAINDICESTAREFATRF Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRF

Relationships

Close relationships within degrees of separation