viagemnotafiscal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idviagemnotafiscal int8 19 null
viagemnotafiscal_aud.idviagemnotafiscal Implied Constraint R
idviagem int8 19 null
viagem.idviagem fk_8dc77a8puhf2yhsj0c9hc9mq5 R
numeronota varchar 80 null
dataemissao date 13 √ null
datavencimento date 13 √ null
datarecebimento date 13 √ null
idnexportadoerp int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkeef882cd Primary key Asc idviagemnotafiscal
idx84fec9d8 Performance Asc idviagem
idxwsversao_eef882cd Performance Desc wsversao
uc674a946d 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.