planitemhierarquia


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idplanitemhierarq int8 19 null
planitemhierarquia_aud.idplanitemhierarq Implied Constraint R
idplanitemsup int8 19 √ null
planejamentoitem.idplanejamentoitem fk_ptv74tx16p3p8ykak688gj0t3 R
idplanejamentoitem int8 19 √ null
planejamentoitem.idplanejamentoitem fk_gwi82q4uiagxm0dvv57qa3to2 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk2ef8f3f7 Primary key Asc idplanitemhierarq
idxa8a88a95 Performance Asc idplanejamentoitem
idxdfae1a03 Performance Asc idplanitemsup
idxwsversao_2ef8f3f7 Performance Desc wsversao
uc24d56bc3 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation