custousuario


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcustousuario int8 19 null
custousuario_aud.idcustousuario Implied Constraint R
datalancamento date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idtipocusto int8 19 √ null
tipocusto.idtipocusto fk_rqsclma7ebi28ty5u5j13n7sh R
valor numeric 18,6 null
idlocal int8 19 √ null
local.idlocal fk_1xi2y2tm3hx78369fa83ib1i9 R
idnativo int2 5 √ null
idusuario int8 19 null
usuario.idusuario fk_s2it9l5xlffk2g2lh3jo82ysb R

Indexes

Constraint Name Type Sort Column(s)
pk61f41732 Primary key Asc idcustousuario
idx13b052d6 Performance Asc idusuario
idx258eebec Performance Asc idtipocusto
idxc66551c4 Performance Asc idlocal
idxwsversao_61f41732 Performance Desc wsversao
ucebb1df48 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation