centrocusto


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcentrocusto int8 19 null
centrocusto.idcentrocustosuperior fk_rj3kaghkyo1vnnymw29s433sx R
centrocusto_aud.idcentrocusto Implied Constraint R
notafiscal.idcentrocusto fk_sko4y8v8upgygm0o3qab977hc R
notafiscal_aud.idcentrocusto Implied Constraint R
notafiscalproduto.idcentrocusto fk_foyf8emlbn1ryuplu0tin97j6 R
notafiscalproduto_aud.idcentrocusto Implied Constraint R
pedido.idcentrocusto fk_59dp6ia8ot0i4nnlgvtbdsqgg R
pedido_aud.idcentrocusto Implied Constraint R
pedidoproduto.idcentrocusto fk_l93y8c7ex48w5k0gm0gpmw0ai R
pedidoproduto_aud.idcentrocusto Implied Constraint R
pedidoprodutogradev2.idcentrocusto fk_l7b0mh7bn67acdmjh922xn3c8 R
pedidoprodutogradev2_aud.idcentrocusto Implied Constraint R
produto.idcentrocusto fk_6kapx1u42jhfyoqxrjjr7unnh R
descricao varchar 80 null
codigo varchar 80 √ null
idcentrocustosuperior int8 19 √ null
centrocusto.idcentrocusto fk_rj3kaghkyo1vnnymw29s433sx R
idnativo int2 5 null
nivel int8 19 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk701bd577 Primary key Asc idcentrocusto
idx69c1ca22 Performance Asc idcentrocustosuperior
idxwsversao_701bd577 Performance Desc wsversao
ucdbfcc405 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.