tipoaprovacaousuario


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtipoaprovacaousuario int8 19 null
tipoaprovacaousuario_aud.idtipoaprovacaousuario Implied Constraint R
limiteminimo numeric 18,6 null
limitemaximo numeric 18,6 null
idtipoaprovacao int8 19 null
tipoaprovacao.idtipoaprovacao fk_2onmq08e8vxqi0vklxa3jsl1t R
idusuario int8 19 null
usuario.idusuario fk_rahn6gqfb67y73rh28v48xyc7 R
codigoerp varchar 80 null
wsversao int8 19 null
valor numeric 18,6 null

Table contained 5 rows

Indexes

Constraint Name Type Sort Column(s)
pkede0cf28 Primary key Asc idtipoaprovacaousuario
idx32a34c33 Performance Asc idtipoaprovacao
idxd8be0ecc Performance Asc idusuario
idxwsversao_ede0cf28 Performance Desc wsversao
uc8495c832 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.