MTRFREC

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MTAREFA.CODCOLIGADA FKMTRFREC_MTAREFAR
MCMP.CODCOLIGADA FKMTRFREC_MCMPR
MPRJ.CODCOLIGADA FKMTRFREC_MPRJR
MPERIODO.CODCOLIGADA FKMTRFREC_MPERIODOR
MISM.CODCOLIGADA FKMTRFREC_MISMR
IDPRJ int 4 null
MPERIODO.IDPRJ FKMTRFREC_MPERIODOR
MISM.IDPRJ FKMTRFREC_MISMR
MTAREFA.IDPRJ FKMTRFREC_MTAREFAR
MCMP.IDPRJ FKMTRFREC_MCMPR
MPRJ.IDPRJ FKMTRFREC_MPRJR
IDTRFREC int 4 null
IDTRF int 4 null
MTAREFA.IDTRF FKMTRFREC_MTAREFAR
IDPRJREC int 4 null
IDCMP int 4 √ null
MCMP.IDCMP FKMTRFREC_MCMPR
IDISM int 4 √ null
MISM.IDISM FKMTRFREC_MISMR
QUANTIDADE numeric 23,8 null
IDPERIODO int 4 null
MPERIODO.IDPERIODO FKMTRFREC_MPERIODOR
ATIVO int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null

Indexes

Constraint Name Type Sort Column(s)
PKMTRFREC Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDTRFREC

Relationships

Close relationships within degrees of separation