contatoidentificacao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcontatoidentificacao int8 19 null
contatoidentificacao_aud.idcontatoidentificacao Implied Constraint R
idtipoidentificacao int8 19 null
tipoidentificacao.idtipoidentificacao fk_4eu06vcmo8lcv3nuk2woe5ne9 R
idcontatopessoa int8 19 null
contatopessoa.idcontatopessoa fk_srm0dk916smb6b2yej8gyd7or R
documentoidentificacao varchar 80 √ null
dataexpedicao date 13 √ null
datavencimento date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk40304f4d Primary key Asc idcontatoidentificacao
idx8f4cac7b Performance Asc idcontatopessoa
idxabc8303f Performance Asc idtipoidentificacao
idxwsversao_40304f4d Performance Desc wsversao
uc5177740d 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.