obsaprovacaodesconto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idobsaprovacaodesconto int8 19 null
obsaprovacaodesconto.idobssuperior fk_7val44fqvpcsvll1xvkomnbmj R
obsaprovacaodesconto_aud.idobsaprovacaodesconto Implied Constraint R
observacao varchar 4000 √ null
datacadastro date 13 null
horacadastro varchar 8 √ null
iddescontoaprovacao int8 19 null
descontoaprovacao.iddescontoaprovacao fk_9w08xkgiv36hrrn9906u0xa2y R
idusuario int8 19 null
usuario.idusuario fk_e2wgee9yxmyadjo80ufgk7ly1 R
idtiposituacaoaprovacao int8 19 null
tiposituacaoaprovacao.idtiposituacaoaprovacao fk_rmw89178tkepuy21sbpggru3h R
idobssuperior int8 19 √ null
obsaprovacaodesconto.idobsaprovacaodesconto fk_7val44fqvpcsvll1xvkomnbmj R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk2ab4ede5 Primary key Asc idobsaprovacaodesconto
idx2a45efe8 Performance Asc idobssuperior
idx8a016b25 Performance Asc idtiposituacaoaprovacao
idx9cab0ffb Performance Asc iddescontoaprovacao
idxb1896d4f Performance Asc idusuario
idxwsversao_2ab4ede5 Performance Desc wsversao
uc91d0c95 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation