projetoagricola


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprojetoagricola int8 19 null
projetoagrareaimg.idprojetoagricola fk_bqy69bchbpjk63fckag91toa8 R
projetoagrareaimg_aud.idprojetoagricola Implied Constraint R
projetoagricola_aud.idprojetoagricola Implied Constraint R
projetoagricolaarea.idprojetoagricola fk_gjkmwlb9cm5xmnsp7qabs7d0c R
projetoagricolaarea_aud.idprojetoagricola Implied Constraint R
projetoagricolausuario.idprojetoagricola fk_h4qm9rwbhnwkmhjnmb1qdhr64 R
projetoagricolausuario_aud.idprojetoagricola Implied Constraint R
vistoria.idprojetoagricola fk_qe2r3vfouu5eujqyuhp4ddy0w R
vistoria_aud.idprojetoagricola Implied Constraint R
data date 13 √ null
idusuario int8 19 null
usuario.idusuario fk_ck0hekaqkfcftr5bu38d29djl R
idcultura int8 19 null
cultura.idcultura fk_p4eyoxw4ln1jmattkn364197 R
idlocal int8 19 null
local.idlocal fk_5vcix54cmqtut9u2pkw742orh R
idparceiro int8 19 null
parceiro.idparceiro fk_88sgubhlg8g57t8yve9mfqcl R
idsafra int8 19 null
safra.idsafra fk_4tgays0oh2wpng9rbw513uf5u R
idatendimento int8 19 √ null
atendimento.idatendimento fk_mb9hw214dk48fjeec60bs7sx5 R
idfilial int8 19 √ null
local.idlocal fk_n5neklbjpwu0nbjg4dcap1p0 R
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
idnimagematualizada int2 5 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk6e2e3761 Primary key Asc idprojetoagricola
idx1103e6d3 Performance Asc idparceiro
idx41fd55f1 Performance Asc idsafra
idx4735e99c Performance Asc idatendimento
idx8b60a38 Performance Asc idlocal
idxb3bbe95c Performance Asc idusuario
idxd2bbe48 Performance Asc idcultura
idxdfed7003 Performance Asc idfilial
idxwsversao_6e2e3761 Performance Desc wsversao
ucc00e121b 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.