metafilial


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmetafilial int8 19 null
metafilial_aud.idmetafilial Implied Constraint R
valor numeric 18,6 √ null
idmeta int8 19 √ null
meta.idmeta fk_katnn1rxgeqhiaweqcinl4cy4 R
datacadastro date 13 √ null
dataatualizacao date 13 √ null
idlocalfilial int8 19 √ null
local.idlocal fk_p145qoikufdovmvil0u6eq0p6 R
idusuarioresponsavel int8 19 √ null
usuario.idusuario fk_9h2mq0h7h4lxrelfbvp11goq6 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk93c92830 Primary key Asc idmetafilial
idx3ab6e703 Performance Asc idlocalfilial
idx3ce04831 Performance Asc idmeta
idx918cfbf2 Performance Asc idusuarioresponsavel
idxwsversao_93c92830 Performance Desc wsversao
ucaf37630a Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation