notafiscal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idnotafiscal int8 19 null
cfopnotafiscal.idnotafiscal fk_d1vp15j1kwml45nt0tvtx19ji R
cfopnotafiscal_aud.idnotafiscal Implied Constraint R
financeirotitulo.idnotafiscal fk_60dub401t6nchpvdlab4ssudu R
financeirotitulo_aud.idnotafiscal Implied Constraint R
nfvinculonf.idnfvinculonf fk_nt7bsr8jlnljsd17agn1r2f2n R
nfvinculonf.idnotafiscalentrada fk_m2m4dkx74sk1c14s4q4w50xyo R
nfvinculonf.idnotafiscalsaida fk_sux4shuhxcpt475ndh7gk7qxv R
notafiscal_aud.idnotafiscal Implied Constraint R
notafiscalproduto.idnotafiscal fk_pcjg04jejs6hxbdkfwykm1evv R
notafiscalproduto.idnotafiscalorigem fk_g9vpwm4mc2tvvh0lojblpr3jl R
notafiscalproduto_aud.idnotafiscal Implied Constraint R
parceiropositivacao.idnotafiscal fk_7493en0inedffxkjnmh9utv27 R
parceiropositivacao_aud.idnotafiscal Implied Constraint R
produtopositivacao.idnotafiscal fk_3duuvrv8567rxynukkq79ag0r R
produtopositivacao_aud.idnotafiscal Implied Constraint R
wagrnotafiscal.idwagrnotafiscal fk_nf8cyttut7918fs2t9fvyyxbb R
idsegmento int8 19 √ null
segmento.idsegmento fk_599238veerhq023c96ynncfls R
idncancelada int2 5 √ null
numeronotafiscal varchar 80 √ null
observacao varchar 4000 √ null
serie varchar 20 √ null
horaatualizacao varchar 8 √ null
dataatualizacao date 13 √ null
dataemissao date 13 √ null
quantidadefaturada numeric 18,6 √ null
valorfaturado numeric 18,6 √ null
idlocalfilialfaturamento int8 19 √ null
local.idlocal fk_rs9pfpy92nt38u32inm4dsh6m R
idlocalfilialretirada int8 19 √ null
local.idlocal fk_i6istu7gidlu2dd7qa2kfityf R
idlocalfilialvenda int8 19 √ null
local.idlocal fk_suximlvaglfuxdigeyh6hmmn4 R
idlocal int8 19 null
local.idlocal fk_3r5dbo35q3ek4v6xpdoms3a8u R
idparceiro int8 19 null
parceiro.idparceiro fk_bxu7gy5snkk2ure4i689tl5dw R
idparceirotransportadora int8 19 √ null
parceiro.idparceiro fk_cmdh9d52wsxbna7brkkyuw27q R
idcondicaopagamento int8 19 √ null
condicaopagamento.idcondicaopagamento fk_d0bl9h76blfqewhn34veeku8 R
idusuario int8 19 √ null
usuario.idusuario fk_t7pef5iudjeaklurq9jvvucx R
idcentrocusto int8 19 √ null
centrocusto.idcentrocusto fk_sko4y8v8upgygm0o3qab977hc R
idtiponotafiscal int8 19 √ null
tiponotafiscal.idtiponotafiscal fk_2gkldkdjm1ovuvd1g8a56iot9 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null
valorfrete numeric 18,6 √ null
valorseguro numeric 18,6 √ null
complemento varchar 4000 √ null
arquivo bytea 2147483647 √ null

Table contained 9897 rows

Indexes

Constraint Name Type Sort Column(s)
pk52c2076c Primary key Asc idnotafiscal
idx28df7469 Performance Asc idlocal
idx56b1d1cf Performance Asc idparceirotransportadora
idx69ea1030 Performance Asc idparceiro
idx7433ceb5 Performance Asc idusuario
idx7b242557 Performance Asc idlocalfilialvenda
idx991773ab Performance Asc idcentrocusto
idx9e853706 Performance Asc idtiponotafiscal
idxa5c38373 Performance Asc idsegmento
idxc8ca81e4 Performance Asc idcondicaopagamento
idxda410b4a Performance Asc idlocalfilialretirada
idxe797eeb1 Performance Asc idlocalfilialfaturamento
idxwsversao_52c2076c Performance Desc wsversao
uc25dc254e 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.