visitatipo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvisitatipo int8 19 null
demtipvisita.idvisitatipo fk_91spx2iy72svml9cqscy4itvf R
demtipvisita_aud.idvisitatipo Implied Constraint R
visita.idvisitatipo fk_b0760rdqpv7qudkybg2lxli34 R
visita_aud.idvisitatipo Implied Constraint R
visitaconfig.idvisitatipo fk_lu2ax5c60qjgdht6cqin53rb0 R
visitaconfig.idvisitatiposuperior fk_et489cqkrlr5tkiyemw1a1con R
visitaconfig_aud.idvisitatipo Implied Constraint R
visitaconfigcampo.idvisitatipo fk_mb0e095p5r26k8x17b706tcdb R
visitaconfigcampo_aud.idvisitatipo Implied Constraint R
visitatipo_aud.idvisitatipo Implied Constraint R
descricao varchar 40 null
observacao varchar 500 √ null
sglvisitatipo varchar 10 null
idnsistema int2 5 null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnmultiplosprodutos int2 5 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk8c3d4ea Primary key Asc idvisitatipo
idxwsversao_8c3d4ea Performance Desc wsversao
uc1f083c90 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.