MCNTPDOMOV

11 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MPDO.CODCOLIGADA FKMCNTPDOMOV_MPDOR
TMOV.CODCOLIGADA FKMCNTPDOMOV_TMOVR
IDPRJ int 4 null
MPDO.IDPRJ FKMCNTPDOMOV_MPDOR
IDCNT int 4 null
MPDO.IDCNT FKMCNTPDOMOV_MPDOR
PERIODOMED varchar 10 null
MPDO.PERIODOMED FKMCNTPDOMOV_MPDOR
CLASSIFICACAO smallint 2 null
MPDO.CLASSIFICACAO FKMCNTPDOMOV_MPDOR
IDMOV int 4 null
TMOV.IDMOV FKMCNTPDOMOV_TMOVR
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)
PKMCNTPDOMOV Primary key Asc/Asc/Asc/Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDCNT + PERIODOMED + CLASSIFICACAO + IDMOV

Relationships

Close relationships within degrees of separation