visitasituacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitasituacao int8 19 null
visita.idvisitasituacao fk_7rjbdfr4qph2har5ryi6rbme8 R
visita_aud.idvisitasituacao Implied Constraint R
visitasituacao_aud.idvisitasituacao Implied Constraint R
descricao varchar 100 null
observacao varchar 500 √ null
sglvisitasituacao varchar 10 null
idnsistema int2 5 null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 4 rows

Indexes

Constraint Name Type Sort Column(s)
pk470faa5d Primary key Asc idvisitasituacao
idxwsversao_470faa5d Performance Desc wsversao
uc54b8c27d 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.