atendimentoitem


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idatendimentoitem int8 19 null
atendimentoitem_aud.idatendimentoitem Implied Constraint R
idatendimento int8 19 null
atendimento.idatendimento fk_sgc5as8bkwuutpcd0ihuu89fn R
idproduto int8 19 null
produto.idproduto fk_j878h3fs8mf72j3acork0koip R
idtipojustificativaitem int8 19 √ null
tipojustificativaitem.idtipojustificativaitem fk_9dc0fnc9nu568bf3qgkxq2uws R
idngeragarantia int2 5 null
observacao varchar 4000 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk90c9e4e3 Primary key Asc idatendimentoitem
idx406f1b7e Performance Asc idtipojustificativaitem
idxb91aa353 Performance Asc idatendimento
idxbc879049 Performance Asc idproduto
idxwsversao_90c9e4e3 Performance Desc wsversao
uc750f7d9 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation