MISMDERIVACAO

14 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MGIS.CODCOLIGADA FKMISMDERIVACAO_MGISR
MCMP.CODCOLIGADA FKMISMDERIVACAO_MCMPR
MCNT.CODCOLIGADA FKMISMDERIVACAO_MCNTR
MISM.CODCOLIGADA FKMISMDERIVACAO_MISMR
IDPRJ int 4 null
MISM.IDPRJ FKMISMDERIVACAO_MISMDR
MCMP.IDPRJ FKMISMDERIVACAO_MCMPR
MGIS.IDPRJ FKMISMDERIVACAO_MGISR
IDISM int 4 null
MISM.IDISM FKMISMDERIVACAO_MISMR
ID int 4 null
IDISMD int 4 √ null
MISM.IDISM FKMISMDERIVACAO_MISMDR
IDGISD int 4 √ null
MGIS.IDGIS FKMISMDERIVACAO_MGISR
PERCENTUAL RMDVALOR4 17,4 null
ATIVO int 4 null
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime 16,3 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime 16,3 √ null
IDCNTD int 4 √ null
MCNT.IDCNT FKMISMDERIVACAO_MCNTR
IDPRJD int 4 √ null
MCNT.IDPRJ FKMISMDERIVACAO_MCNTR
IDCMPD int 4 √ null
MCMP.IDCMP FKMISMDERIVACAO_MCMPR

Indexes

Constraint Name Type Sort Column(s)
PKMISMDERIVACAO Primary key Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDISM + ID
IXMISMDERIVACAO_MCMP Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDCMPD
IXMISMDERIVACAO_MCNT Performance Asc/Asc/Asc CODCOLIGADA + IDPRJD + IDCNTD
IXMISMDERIVACAO_MGIS Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDGISD
IXMISMDERIVACAO_MISM Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDISM
IXMISMDERIVACAO_MISMD Performance Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDISMD
MISMDERIVACAOINDEX Performance Asc/Asc/Asc/Asc/Asc IDISM + ATIVO + IDCMPD + IDISMD + IDGISD

Relationships

Close relationships within degrees of separation