localtipopedido


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocaltipopedido int8 19 null
localtipopedido_aud.idlocaltipopedido Implied Constraint R
idlocal int8 19 √ null
local.idlocal fk_rn0fg5dpmcu8x2lvvrb9c2bxb R
idusuario int8 19 √ null
usuario.idusuario fk_43boikg9wfvmw5vv4xxhe16u2 R
idtipopedido int8 19 null
tipopedido.idtipopedido fk_ljh4jiblobo2v1r3odyxybq5x R
idsegmento int8 19 √ null
segmento.idsegmento fk_v1tt4yjj8ejtwmvmj6ji0uof R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnpadrao int2 5 √ null
valorminimo numeric 18,6 √ null
idlocalfilial int8 19 √ null
localfilial.idlocalfilial fk_1ek3d37025fows8nmagr56vr1 R
idtipologia int8 19 √ null
tipologia.idtipologia fk_roplfohglgxglbkgh0xyikce7 R
idparceiro int8 19 √ null
parceiro.idparceiro fk_hcfomggetom9a6w9smqfejol4 R

Table contained 2 rows

Indexes

Constraint Name Type Sort Column(s)
pk7c888944 Primary key Asc idlocaltipopedido
idx4440f4d8 Performance Asc idtipopedido
idx57331425 Performance Asc idsegmento
idx5f7c1587 Performance Asc idlocal
idx92a2f499 Performance Asc idlocalfilial
idx96276775 Performance Asc idusuario
idxa0babcef Performance Asc idparceiro
idxf922d433 Performance Asc idtipologia
idxwsversao_7c888944 Performance Desc wsversao
uc30c9d938 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.