localarea


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalarea int8 19 null
localarea_aud.idlocalarea Implied Constraint R
localareasubarea.idlocalarea fk_bdk77imvladyqparivsytjy39 R
localareasubarea_aud.idlocalarea Implied Constraint R
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
data date 13 √ null
tamanhoarea numeric 18,6 √ null
observacao varchar 4000 √ null
idlocal int8 19 null
local.idlocal fk_ea91g798nynemgykqerrvtk0l R
idpontogpsareasede int8 19 √ null
pontogpsarea.idpontogpsarea fk_2b57jyhkr4t76b48lw9ui54qi R
idpontogpsarea int8 19 √ null
pontogpsarea.idpontogpsarea fk_hajsp98tcn7t4vh3xsjkb6wq3 R
idunidademedidaarea int8 19 √ null
unidademedida.idunidademedida fk_pnvml4wi4xhe0v8i9ofw1164j R
idusuario int8 19 √ null
usuario.idusuario fk_24178eh9hs3qtwfmooijbveam R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 4210 rows

Indexes

Constraint Name Type Sort Column(s)
pk2f939678 Primary key Asc idlocalarea
idx372c11e4 Performance Asc idunidademedidaarea
idx574093a9 Performance Asc idusuario
idx886525f3 Performance Asc idpontogpsarea
idxa07215e6 Performance Asc idpontogpsareasede
idxc295704a Performance Asc idlocal
idxwsversao_2f939678 Performance Desc wsversao
ucb5d05524 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.