prodlancalocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idprodlancalocal int8 19 null
prodlancalocal_aud.idprodlancalocal Implied Constraint R
idproduto int8 19 null
produto.idproduto fk_ok3c31wuirvaeosvv3j6hw4dx R
idlocal int8 19 null
local.idlocal fk_2pq3oevfh2cjtf3fi59bi44vr R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pkc07348cb Primary key Asc idprodlancalocal
idxd7ff078d Performance Asc idproduto
idxec3ff8fa Performance Asc idlocal
idxwsversao_c07348cb Performance Desc wsversao
uca94342af Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation