visitacmpd


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitacmpd int8 19 null
visitacmpd_aud.idvisitacmpd Implied Constraint R
visitaprod_aud.idvisitacmpd Implied Constraint R
visitaprodconcorr_aud.idvisitacmpd Implied Constraint R
idvisita int8 19 null
visita.idvisita fk_quskbb7ms8t61kf25tr3jiiia R
idcampo int8 19 null
campo.idcampo fk_afevd6owhj8236f91g1e57i3v R
valor varchar 4000 null
codigoerp varchar 80 null
wsversao int8 19 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk8bbad74 Primary key Asc idvisitacmpd
idx362ac744 Performance Asc idcampo
idx4ffcc189 Performance Asc idvisita
idxwsversao_8bbad74 Performance Desc wsversao
uc95804c26 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.