wsconfigcampovinculo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idwsconfigcampovinculo int8 19 null
wsconfigcampovinculo_aud.idwsconfigcampovinculo Implied Constraint R
idwsconfigcampo int8 19 null
wsconfigcampo.idwsconfigcampo fk_90cnmfhkhquujojii02oyrl7t R
idtipopedido int8 19 √ null
tipopedido.idtipopedido fk_73661c0msy56h6ol61ffyj1nf R
idparceiro int8 19 √ null
parceiro.idparceiro fk_kktq04sja54h0nnra53y6gxyf R
idlocal int8 19 √ null
local.idlocal fk_qvq22qyjkvpty0y1clwf2ysgb R
idusuarioprofissional int8 19 √ null
usuario.idusuario fk_o2uxeyck3i9nxrpn38i3ml1gb R
idlocalfilialvenda int8 19 √ null
local.idlocal fk_e8yv8k6xnp753anvo6638cn50 R
idtabelapreco int8 19 √ null
tabelapreco.idtabelapreco fk_51nm7kkr1tcv36r7iupmwygfe R
idcondicaopagamento int8 19 √ null
condicaopagamento.idcondicaopagamento fk_hik96i96i44hpxrtufnyol6l6 R
idsegmento int8 19 √ null
segmento.idsegmento fk_qok62ewwb2ji96ch8li3o0a25 R
idgrupoparceiro int8 19 √ null
grupoparceiro.idgrupoparceiro fk_fpmt3b4h7pbk8unc4wioorbp9 R
idtipocobranca int8 19 √ null
tipocobranca.idtipocobranca fk_o2rquepny6k7hnennaq174ud9 R
idtipologia int8 19 √ null
tipologia.idtipologia fk_el4umj4ulj95yl40bk639brpi R
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idwsconfigcampovinculado int8 19 √ null
wsconfigcampo.idwsconfigcampo fk_hrmb7fp8djfn6hoqongy4joy2 R

Table contained 3 rows

Indexes

Constraint Name Type Sort Column(s)
pkb4e802a0 Primary key Asc idwsconfigcampovinculo
idx26090933 Performance Asc idtipologia
idx348dbffe Performance Asc idparceiro
idx437b4981 Performance Asc idlocal
idx485d5cbf Performance Asc idusuarioprofissional
idx53c17378 Performance Asc idtipocobranca
idx6151d5e6 Performance Asc idtipopedido
idx6ec1de9d Performance Asc idgrupoparceiro
idxba27162d Performance Asc idtabelapreco
idxce1cc27e Performance Asc idsegmento
idxd5b7f3c7 Performance Asc idwsconfigcampo
idxda10dc05 Performance Asc idcondicaopagamento
idxe8e2bf85 Performance Asc idlocalfilialvenda
idxed6f97cf Performance Asc idwsconfigcampovinculado
idxwsversao_b4e802a0 Performance Desc wsversao
uca9360fda 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.