projetoagrareaproducao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprojetoagrareaproducao int8 19 null
projetoagrareaproducao_aud.idprojetoagrareaproducao Implied Constraint R
idprojetoagricolaarea int8 19 √ null
projetoagricolaarea.idprojetoagricolaarea fk_oh8i7cri1d6mveu39ip7aal6d R
idpontogpsarea int8 19 √ null
pontogpsarea.idpontogpsarea fk_fcj6ay49xk3v2epsijp2gb3mb R
produtividade numeric 18,6 √ null
producao numeric 18,6 √ null
ordem int8 19 √ null
tamanhoarea numeric 18,6 √ null
data date 13 √ null
idtipoproducaoagricola int8 19 √ null
tipoproducaoagricola.idtipoproducaoagricola fk_4udceth8e0972kgrjwjlgp0cr R
idusuario int8 19 √ null
usuario.idusuario fk_hay6j8ga081vl11025m51lq7c R
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idvistoria int8 19 √ null
vistoria.idvistoria fk_pqkq0rmkbd5w6t71c67cat1q7 R
idatendimento int8 19 √ null
atendimento.idatendimento fk_act3olv3g2137j3f35b09lvpv R
idestagio int8 19 √ null
estagio.idestagio fk_qqyr333k35j7ru4u3p3oms96e R
observacao varchar 4000 √ null
hora varchar 8 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pka6918e69 Primary key Asc idprojetoagrareaproducao
idx14eb8c4b Performance Asc idestagio
idx2ff257b1 Performance Asc idatendimento
idx4625a87e Performance Asc idpontogpsarea
idx4de9a081 Performance Asc idtipoproducaoagricola
idx6f854725 Performance Asc idprojetoagricolaarea
idx742a9f08 Performance Asc idvistoria
idx9a241fce Performance Asc idusuario
idxwsversao_a6918e69 Performance Desc wsversao
uc59140ef1 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.