MPERIODO

1141 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CODCOLIGADA DCODCOLIGADA 2 null
MAVAINDICES.CODCOLIGADA FKMAVAINDICES_MPERIODOR
MAVAINDICESCCUSTO.CODCOLIGADA FKMAVAINDICESCCUSTO_MPERIODOR
MAVAINDICESRECURSO.CODCOLIGADA FKMAVAINDICESRECURSO_MPERIODOR
MAVAINDICESTAREFA.CODCOLIGADA FKMAVAINDICESTAREFA_MPERIODOR
MCMPVERSAO.CODCOLIGADA FKMCMPVERSAO_MPERIODOR
MCURVASISMTRF.CODCOLIGADA FKMCURVASISM_MPERIODOR
MTRFREC.CODCOLIGADA FKMTRFREC_MPERIODOR
MPRJ.CODCOLIGADA FKMPERIODO_MPRJR
IDPRJ int 4 null
MAVAINDICES.IDPRJ FKMAVAINDICES_MPERIODOR
MAVAINDICESCCUSTO.IDPRJ FKMAVAINDICESCCUSTO_MPERIODOR
MAVAINDICESRECURSO.IDPRJ FKMAVAINDICESRECURSO_MPERIODOR
MAVAINDICESTAREFA.IDPRJ FKMAVAINDICESTAREFA_MPERIODOR
MCMPVERSAO.IDPRJ FKMCMPVERSAO_MPERIODOR
MCURVASISMTRF.IDPRJ FKMCURVASISM_MPERIODOR
MTRFREC.IDPRJ FKMTRFREC_MPERIODOR
MPRJ.IDPRJ FKMPERIODO_MPRJR
IDPERIODO int 4 null
MAVAINDICES.IDPERIODO FKMAVAINDICES_MPERIODOR
MAVAINDICESCCUSTO.IDPERIODO FKMAVAINDICESCCUSTO_MPERIODOR
MAVAINDICESRECURSO.IDPERIODO FKMAVAINDICESRECURSO_MPERIODOR
MAVAINDICESTAREFA.IDPERIODO FKMAVAINDICESTAREFA_MPERIODOR
MCMPVERSAO.IDPERIODO FKMCMPVERSAO_MPERIODOR
MCURVASISMTRF.IDPERIODO FKMCURVASISM_MPERIODOR
MTRFREC.IDPERIODO FKMTRFREC_MPERIODOR
DTINICIO datetime 16,3 null
DTFIM datetime 16,3 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)
PKMPERIODO Primary key Asc/Asc/Asc CODCOLIGADA + IDPRJ + IDPERIODO

Relationships

Close relationships within degrees of separation