vistoria


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idvistoria int8 19 null
ocorrenciaidentificada.idvistoria fk_itn34n6dodjiayy0gb8w6dhdn R
ocorrenciaidentificada_aud.idvistoria Implied Constraint R
produtoaplicacao.idvistoria fk_3onbsjx2ugol5womfgargcfsx R
produtoaplicacao_aud.idvistoria Implied Constraint R
produtorecomendado.idvistoria fk_kpdhkaox69e91xoh97uk0e3su R
produtorecomendado_aud.idvistoria Implied Constraint R
projetoagrareaplanta.idvistoria fk_jqyt9juwursiqnaf1ubomhh5r R
projetoagrareaplanta_aud.idvistoria Implied Constraint R
projetoagrareaproducao.idvistoria fk_pqkq0rmkbd5w6t71c67cat1q7 R
projetoagrareaproducao_aud.idvistoria Implied Constraint R
projetoagrareasemente.idvistoria fk_p7itu6qky2ogqox0pnvby52nd R
projetoagrareasemente_aud.idvistoria Implied Constraint R
servicorealizado.idvistoria fk_kb38tgd2fou7hlbh5gg2oga3 R
servicorealizado_aud.idvistoria Implied Constraint R
vistoria_aud.idvistoria Implied Constraint R
codigo varchar 20 √ null
codigoerp varchar 80 √ null
descricao varchar 80 √ null
wsversao int8 19 √ null
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
idprojetoagricola int8 19 √ null
projetoagricola.idprojetoagricola fk_qe2r3vfouu5eujqyuhp4ddy0w R
idtipovistoria int8 19 √ null
tipovistoria.idtipovistoria fk_jmpin4fw18b0wu16a24enx2ii R
idusuario int8 19 √ null
usuario.idusuario fk_4nt8sj31drbfbloft544whh7k R
idatendimento int8 19 √ null
atendimento.idatendimento fk_fge1tmenx2eoas7ln51q8x6v1 R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk62e784af Primary key Asc idvistoria
idx466b9d8a Performance Asc idusuario
idx7a2b6d42 Performance Asc idprojetoagricola
idx95577876 Performance Asc idatendimento
idxa2b91d41 Performance Asc idtipovistoria
idxwsversao_62e784af Performance Desc wsversao
uc999e608b 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.