visitaprod


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitaprod int8 19 null
visitaprod_aud.idvisitaprod Implied Constraint R
idvisita int8 19 null
visita.idvisita fk_lppkumvvon71vmynb63b51ob5 R
idproduto int8 19 √ null
produto.idproduto fk_lsqvuxf7tjidi141do60ucul7 R
idvisitacampo int8 19 √ null
visitacampo.idvisitacampo fk_6usl2lytd39evjbhna2cci4yv R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idprodutoconcorrente int8 19 √ null
produtoconcorrente.idprodutoconcorrente fk_s6eey74fnnr964w4kiolmrpa R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk8c2250d Primary key Asc idvisitaprod
idx5de0da3d Performance Asc idproduto
idx8b68ef80 Performance Asc idprodutoconcorrente
idxb035998d Performance Asc idvisita
idxf04f9a8b Performance Asc idvisitacampo
idxwsversao_8c2250d Performance Desc wsversao
ucbc1e7d4d Must be unique Asc codigoerp

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.