viagemadiantamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idviagemadiantamento int8 19 null
viagemadiantamento_aud.idviagemadiantamento Implied Constraint R
idnadiantamentoacertado int2 5 √ null
valor numeric 18,6 null
data date 13 null
dataacerto date 13 √ null
idviagem int8 19 null
viagem.idviagem fk_qres6fn318bqa6dd47i9462a7 R
idtiposituacaoaprovacao int8 19 √ null
tiposituacaoaprovacao.idtiposituacaoaprovacao fk_a7shla3pqgiggunu420mvubdf R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk2ccd3912 Primary key Asc idviagemadiantamento
idx109fd08a Performance Asc idviagem
idxdcd054aa Performance Asc idtiposituacaoaprovacao
idxwsversao_2ccd3912 Performance Desc wsversao
uceef1ea68 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.