localareasubarea


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalareasubarea int8 19 null
localareasubarea_aud.idlocalareasubarea Implied Constraint R
localareasubareacultura.idlocalareasubarea fk_gbm8r7nwhcfdmu1f0a02gigun R
localareasubareacultura_aud.idlocalareasubarea Implied Constraint R
projetoagricolaarea.idlocalareasubareaorigem fk_gp2myti2xvhj1sqcnftm9qkjh R
observacaointegracao varchar 80 √ null
idnexportadoerp int2 5 √ null
data date 13 √ null
tamanhoarea numeric 18,6 √ null
tamanhoareanecessario numeric 18,6 √ null
observacao varchar 4000 √ null
descricao varchar 80 √ null
idlocalarea int8 19 null
localarea.idlocalarea fk_bdk77imvladyqparivsytjy39 R
idpontogpsarea int8 19 √ null
pontogpsarea.idpontogpsarea fk_axc0dcbo5rbh2w3vq3mg4fttj R
idusuario int8 19 √ null
usuario.idusuario fk_5apeq4kda139gm6sausvxv9gq R
idtipoarea int8 19 √ null
tipoarea.idtipoarea fk_fr4qsve1apf3geap5kqt2x2ox R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk4ab52d55 Primary key Asc idlocalareasubarea
idx25ce7e7 Performance Asc idpontogpsarea
idx73404501 Performance Asc idtipoarea
idx9e9a653e Performance Asc idusuario
idxa9df6ed9 Performance Asc idlocalarea
idxwsversao_4ab52d55 Performance Desc wsversao
ucd0ee4e85 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation