controlecotasupervisor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcontrolecotasupervisor int8 19 null
controlecotasupervisor_aud.idcontrolecotasupervisor Implied Constraint R
controlecotausuario.idcontrolecotasupervisor fk_sr5lww84dx2ci31menxv4agwb R
controlecotausuario_aud.idcontrolecotasupervisor Implied Constraint R
cotasupervisobservacao.idcontrolecotasupervisor fk_1lvgihuoqr54mdbm91dd78w59 R
cotasupervisobservacao_aud.idcontrolecotasupervisor Implied Constraint R
quantidadecedida numeric 18,6 √ null
quantidadedisponivel numeric 18,6 √ null
datacadastro date 13 √ null
dataatualizacao date 13 √ null
idusuariosupervisor int8 19 √ null
usuario.idusuario fk_n08dd98pwuwirlqea4ngeen46 R
idcontrolecota int8 19 √ null
controlecota.idcontrolecota fk_congvf31wi35ruibfheou653a R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
pk4739d09 Primary key Asc idcontrolecotasupervisor
idx5147d279 Performance Asc idcontrolecota
idxea798211 Performance Asc idusuariosupervisor
idxwsversao_4739d09 Performance Desc wsversao
uca322c871 Must be unique Asc codigoerp

Relationships

Close relationships within degrees of separation