projetoagrareaplanta


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprojetoagrareaplanta int8 19 null
ocorrenciaidentificada.idprojetoagrareaplanta fk_2noivmkvy2igm7flinm1xsvrd R
ocorrenciaidentificada_aud.idprojetoagrareaplanta Implied Constraint R
projetoagrareaplanta_aud.idprojetoagrareaplanta Implied Constraint R
idprojetoagricolaarea int8 19 null
projetoagricolaarea.idprojetoagricolaarea fk_fuajhrdq1as60l8qbj3bryyf R
idpontogpsarea int8 19 √ null
pontogpsarea.idpontogpsarea fk_k3ur38kv1jm9xggukod79q8sv R
idusuario int8 19 √ null
usuario.idusuario fk_h78e6nsry0cyy31h5kldfomrw R
idatendimento int8 19 √ null
atendimento.idatendimento fk_ldbssrevoknb7efituref0d04 R
idvistoria int8 19 √ null
vistoria.idvistoria fk_jqyt9juwursiqnaf1ubomhh5r R
data date 13 √ null
codigo varchar 20 √ null
descricao varchar 80 √ null
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkd798102c Primary key Asc idprojetoagrareaplanta
idx3d292adb Performance Asc idpontogpsarea
idx53122dc Performance Asc idprojetoagricolaarea
idxa38d57d0 Performance Asc idusuario
idxeefd8d75 Performance Asc idvistoria
idxf6a18876 Performance Asc idatendimento
idxwsversao_d798102c Performance Desc wsversao
uc4c59b5ce Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation