observacaopagamento


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idobservacaopagamento int8 19 null
observacaopagamento_aud.idobservacaopagamento Implied Constraint R
observacao varchar 4000 null
idpedidopagamento int8 19 null
pedidopagamento.idpedidopagamento fk_sx4xih67iyknbk770ah3ru0hv R
idtiposituacaopagamento int8 19 null
tiposituacaopagamento.idtiposituacaopagamento fk_6xddiphc0nggsrt6ac2gb2b0w R
idusuario int8 19 null
usuario.idusuario fk_eu6q7kgfd0yx43ucoa8dkj3wh R
datahora timestamp 29,6 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk681ca34d Primary key Asc idobservacaopagamento
idx2aa6a900 Performance Asc idpedidopagamento
idxd5613537 Performance Asc idusuario
idxfa9df8e5 Performance Asc idtiposituacaopagamento
idxwsversao_681ca34d Performance Desc wsversao
uc709da0ef Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation