relatorio


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idrelatorio int8 19 null
relatorio_aud.idrelatorio Implied Constraint R
relatoriodado.idrelatorio fk_r6dtu7u67um1kqx6xk7dsdada R
relatoriodado_aud.idrelatorio Implied Constraint R
relatoriousuario.idrelatorio fk_qmvel5bk9hwc52fb52lhuq29y R
relatoriousuario_aud.idrelatorio Implied Constraint R
descricao varchar 80 null
observacao varchar 4000 √ null
iniciovigencia date 13 √ null
fimvigencia date 13 √ null
dataultimaatualizacao date 13 √ null
horaultimaatualizacao varchar 8 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk77002ab5 Primary key Asc idrelatorio
idxwsversao_77002ab5 Performance Desc wsversao
ucd3118be7 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.