planejamentoperiodo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idplanejamentoperiodo int8 19 null
planejamentoperiodo_aud.idplanejamentoperiodo Implied Constraint R
datainicio date 13 √ null
datafim date 13 √ null
acao varchar 4000 √ null
resultadoesperado varchar 4000 √ null
resultadoobtido varchar 4000 √ null
idplanejamentoitem int8 19 null
planejamentoitem.idplanejamentoitem fk_emj8pf47aoppg6qbx2853bmct R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk79b56ab0 Primary key Asc idplanejamentoperiodo
idxc927ba21 Performance Asc idplanejamentoitem
idxwsversao_79b56ab0 Performance Desc wsversao
uc9a08aa6c Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation