operacaocadastro


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idoperacaocadastro int8 19 null
operacaocadastro_aud.idoperacaocadastro Implied Constraint R
operacaocadopcoes.idoperacaocadastro fk_dpjup8dyor6n6214lhvmaer9y R
operacaocadopcoes_aud.idoperacaocadastro Implied Constraint R
operacaocadresposta.idoperacaocadastro fk_hfu28jy99nhumpbx25mda2kqu R
operacaocadresposta_aud.idoperacaocadastro Implied Constraint R
descricao varchar 80 null
quantidademaxcaracteres numeric 18,6 √ null
sgltipocomponente varchar 80 null
sgllocalexibicao varchar 80 null
sglambienteexibicao varchar 80 null
idnobrigatorio int2 5 null
idnativo int2 5 null
idnexportadoerp int2 5 null
ordem int8 19 null
idoperacao int8 19 √ null
operacao.idoperacao fk_h233ma6f8qgeak5vphuxst3rr R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk8278ed97 Primary key Asc idoperacaocadastro
idx39e42ced Performance Asc idoperacao
idxwsversao_8278ed97 Performance Desc wsversao
uc29e6d1c3 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.