localidentificacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalidentificacao int8 19 null
localidentificacao_aud.idlocalidentificacao Implied Constraint R
idnexportadoerp int2 5 null
idtipoidentificacao int8 19 null
tipoidentificacao.idtipoidentificacao fk_78mxp8klsqo2givauf2modc5j R
idlocal int8 19 null
local.idlocal fk_5nvj4ws4q7i862oahyr26lua0 R
documentoidentificacao varchar 80 √ null
dataexpedicao date 13 √ null
datavencimento date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
pk3784efac Primary key Asc idlocalidentificacao
idxed54936f Performance Asc idlocal
idxff62361a Performance Asc idtipoidentificacao
idxwsversao_3784efac Performance Desc wsversao
uc877e01ce 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.