estagio


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idestagio int8 19 null
estagio.idestagioposterior fk_l7eqvyyvt93mf01j4fd1lxku6 R
estagio_aud.idestagio Implied Constraint R
estagiovinculo.idestagio fk_27xrmmnw6t3gwymqvhs9mvcj2 R
estagiovinculo_aud.idestagio Implied Constraint R
ocorrenciaidentificada.idestagio fk_lhy63tikl0c31e2fo10l982ea R
ocorrenciaidentificada_aud.idestagio Implied Constraint R
pedidoproduto.idestagio fk_o6lso1jgd0ytd5yg56w75eppv R
pedidoproduto_aud.idestagio Implied Constraint R
projetoagrareaproducao.idestagio fk_qqyr333k35j7ru4u3p3oms96e R
projetoagrareaproducao_aud.idestagio Implied Constraint R
projetoagricolaarea.idestagio fk_jn9q2cl536yupc9h02ybr1vp9 R
projetoagricolaarea_aud.idestagio Implied Constraint R
servico.idestagioposterior fk_n8pn8adwl8o4ybgbj2su3jlsp R
servicorealizado.idestagio fk_r4y6vjli9svnp7kmhbvg2rfyy R
servicorealizado_aud.idestagio Implied Constraint R
idnativo int2 5 null
descricao varchar 80 null
numerodiasestagio int8 19 √ null
sglestagio varchar 20 √ null
idcultura int8 19 null
cultura.idcultura fk_2oar9qx54j7hs7fpracwv1bcr R
idestagioposterior int8 19 √ null
estagio.idestagio fk_l7eqvyyvt93mf01j4fd1lxku6 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idndisponivelagricola int2 5 √ '0'::smallint
idndisponivelpedido int2 5 √ '0'::smallint

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkcdb9632 Primary key Asc idestagio
idx16795ac1 Performance Asc idcultura
idx7b427eae Performance Asc idestagioposterior
idxwsversao_cdb9632 Performance Desc wsversao
uc8061efca 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.