chamadoreabertura


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idchamadoreabertura int8 19 null
chamadoreabertura_aud.idchamadoreabertura Implied Constraint R
obschamadoreabertura varchar 200 null
idchamado int8 19 null
chamado.idchamado fk_g644fum97e4g9m4jbq33s7ic5 R
idusuarioreabertura int8 19 null
usuario.idusuario fk_3qoeqyqdjksrq8t7acn10q20i R
iddeptusureabertura int8 19 null
departamento.iddepartamento fk_g3fw44clb9cqlpk9dr2cc4b4e R
datareabertura timestamp 29,6 null
datareaberturafechada timestamp 29,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkf54e0f2c Primary key Asc idchamadoreabertura
idx3c3ffb6c Performance Asc iddeptusureabertura
idx6ef0999 Performance Asc idchamado
idxb677cf32 Performance Asc idusuarioreabertura
idxwsversao_f54e0f2c Performance Desc wsversao
uc8dfcb7f0 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.