visitaprodconcorr


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitaprodconcorr int8 19 null
visitaprodconcorr_aud.idvisitaprodconcorr Implied Constraint R
idvisita int8 19 null
visita.idvisita fk_fcklrcokpbdxta9xh1advg506 R
idprodutoconcorrente int8 19 null
produtoconcorrente.idprodutoconcorrente fk_f2kfi15ccyvddrafmo5fba3un R
idvisitacampo int8 19 √ null
visitacampo.idvisitacampo fk_rtpu5enx8469inemw3opmxeo4 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk66d1ba61 Primary key Asc idvisitaprodconcorr
idx8d32cfec Performance Asc idprodutoconcorrente
idxc08efbdb Performance Asc idvisitacampo
idxdb6b54e7 Performance Asc idvisita
idxwsversao_66d1ba61 Performance Desc wsversao
uc2b2a7b Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation