projetoagrareasemente


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprojetoagrareasemente int8 19 null
projetoagrareasemente_aud.idprojetoagrareasemente Implied Constraint R
idnexportadoerp int2 5 √ null
idprojetoagricolaarea int8 19 null
projetoagricolaarea.idprojetoagricolaarea fk_sdfh2qj73xhxo2ew5drn6dova R
idlocalfilial int8 19 √ null
local.idlocal fk_j02nk3mneo6xyj9lywhob6s0 R
idvistoria int8 19 √ null
vistoria.idvistoria fk_p7itu6qky2ogqox0pnvby52nd R
idusuario int8 19 √ null
usuario.idusuario fk_fq7ljaa542fgtvxdrvh5ufw60 R
idtipoclassesemente int8 19 √ null
tipoclassesemente.idtipoclassesemente fk_63foupp19m2kmnp3ghr70kvu3 R
idtiposituacaosemente int8 19 √ null
tiposituacaosemente.idtiposituacaosemente fk_alx9vphi4aregi1ar4nddkpbm R
data date 13 √ null
numeroareasemente varchar 80 √ null
tamanhoareasituacao numeric 18,6 √ null
observacao varchar 4000 √ null
descricaonaoconformidade varchar 4000 √ null
descricaomedidacorretiva varchar 4000 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkaecfa99f Primary key Asc idprojetoagrareasemente
idx44a3db1d Performance Asc idusuario
idx6537ceab Performance Asc idlocalfilial
idx6b7ea266 Performance Asc idtipoclassesemente
idx6edbe2be Performance Asc idprojetoagricolaarea
idx7c8cb309 Performance Asc idtiposituacaosemente
idxbf9c2f4 Performance Asc idvistoria
idxwsversao_aecfa99f Performance Desc wsversao
ucc2c43f9d 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.