MCMPVERSAO

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MCMP.CODCOLIGADA FKMCMPVERSAO_MCMP_PAIR
MPRJ.CODCOLIGADA FKMCMPVERSAO_MPRJR
MPERIODO.CODCOLIGADA FKMCMPVERSAO_MPERIODOR
IDPRJ int 4 null
MPERIODO.IDPRJ FKMCMPVERSAO_MPERIODOR
MCMP.IDPRJ FKMCMPVERSAO_MCMPR
MPRJ.IDPRJ FKMCMPVERSAO_MPRJR
IDCMP int 4 null
MCMP.IDCMP FKMCMPVERSAO_MCMPR
IDPRJPAI int 4 null
MCMP.IDPRJ FKMCMPVERSAO_MCMP_PAIR
IDCMPPAI int 4 null
MCMP.IDCMP FKMCMPVERSAO_MCMP_PAIR
NUMVERSAO int 4 null
IDPERIODO int 4 null
MPERIODO.IDPERIODO FKMCMPVERSAO_MPERIODOR
RECCREATEDBY varchar 50 √ null
RECCREATEDON datetime2 16,7 √ null
RECMODIFIEDBY varchar 50 √ null
RECMODIFIEDON datetime2 16,7 √ null
PERMITEEDICAO int 4 ((0))

Indexes

Constraint Name Type Sort Column(s)
PKMCMPVERSAO Primary key Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDCMP + IDPRJPAI + IDCMPPAI

Relationships

Close relationships within degrees of separation