observacaoaprovacaodesconto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idobservacaoaprovacaodesconto int8 19 null
observacaoaprovacaodesconto.idobservacaosuperior fk_t5b3fdbph38g8wa1jakkru4vb R
observacaoaprovacaodesconto_aud.idobservacaoaprovacaodesconto Implied Constraint R
observacao varchar 4000 √ null
datacadastro date 13 null
horacadastro varchar 8 √ null
iddescontoaprovacao int8 19 null
descontoaprovacao.iddescontoaprovacao fk_qngb13a0164gp7wrbppou2ehw R
idusuario int8 19 null
usuario.idusuario fk_egstfb3g2k63k727679mvm9vx R
idtiposituacaoaprovacao int8 19 null
tiposituacaoaprovacao.idtiposituacaoaprovacao fk_jo7ihueugqrvx6liwuoab6fj5 R
idobservacaosuperior int8 19 √ null
observacaoaprovacaodesconto.idobservacaoaprovacaodesconto fk_t5b3fdbph38g8wa1jakkru4vb R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk689d000c Primary key Asc idobservacaoaprovacaodesconto
idx98d02ae5 Performance Asc idobservacaosuperior
idxe91933ad Performance Asc iddescontoaprovacao
idxed68457b Performance Asc idusuario
idxfd77e956 Performance Asc idtiposituacaoaprovacao
idxwsversao_689d000c Performance Desc wsversao
uc2ef4f1b0 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.