parceirolocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idparceirolocal int8 19 null
demanda.idparceirolocal fk_eclns8h8jsme7ebroualcopln R
demanda_aud.idparceirolocal Implied Constraint R
parceirolocal_aud.idparceirolocal Implied Constraint R
visita.idparceirolocal fk_3baep6gwvtn4awpbt5tw9otlt R
visita_aud.idparceirolocal Implied Constraint R
idparceiro int8 19 √ null
parceiro.idparceiro fk_97vg7kb26r0x86y0bqrbklga0 R
idlocal int8 19 √ null
local.idlocal fk_ju6n793y49xtt9yf2vr3yk0l1 R
idnexportadoerp int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 16317 rows

Indexes

Constraint Name Type Sort Column(s)
pka42e7c48 Primary key Asc idparceirolocal
idx3028b1a6 Performance Asc idlocal
idxe0db6c30 Performance Asc idparceiro
idxwsversao_a42e7c48 Performance Desc wsversao
ucf7571c94 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.