ofertalocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idofertalocal int8 19 null
ofertalocal_aud.idofertalocal Implied Constraint R
idoferta int8 19 null
oferta.idoferta fk_lmcyenn4v6s0gprsw6t9s18x5 R
idlocal int8 19 null
local.idlocal fk_3p97eh4wpeavthttau9jhlvs R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkab57df9a Primary key Asc idofertalocal
idx6769307f Performance Asc idlocal
idx86855fec Performance Asc idoferta
idxwsversao_ab57df9a Performance Desc wsversao
uc4d738ac2 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.