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

Table contained 0 rows

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

Graphviz Needed!

SchemaSpy was unable to generate a diagram of table relationships.
SchemaSpy requires Graphviz graphvizVersion 2.26 or versions greater than 2.31 from www.graphviz.org.