localentrega


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idlocalentrega int8 19 null
localentrega_aud.idlocalentrega Implied Constraint R
pedidoentrega_aud.idlocalentrega Implied Constraint R
vinculolocalentrega_aud.idlocalentrega Implied Constraint R
idlocalfilial int8 19 √ null
local.idlocal fk_l2gh29e3xs9jc6qb3jp0fr85m R
idlocal int8 19 √ null
local.idlocal fk_pd62sdedyryblcghwckabog38 R
idsegmento int8 19 √ null
segmento.idsegmento fk_jje5df6fy9bn8qjxewwgyk91p R
idparceiro int8 19 √ null
parceiro.idparceiro fk_a5kqtkomiuvln1tyd3jmurm6s R
idcontatopessoa int8 19 √ null
contatopessoa.idcontatopessoa fk_q9a5ab58bjdhd6di9p7g6ly7f R
idusuario int8 19 √ null
usuario.idusuario fk_m9rocsbyqqp03qiiktibur2n4 R
numerodiasminimo numeric 18,6 √ null
numerodiaspadrao numeric 18,6 √ null
idnrecebedomingo int2 5 null
idnrecebesegunda int2 5 null
idnrecebeterca int2 5 null
idnrecebequarta int2 5 null
idnrecebequinta int2 5 null
idnrecebesexta int2 5 null
idnrecebesabado int2 5 null
horainicio varchar 8 √ null
horafim varchar 8 √ null
cepinicial varchar 10 √ null
cepfinal varchar 10 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idparceiroentrega int8 19 √ null
parceiro.idparceiro fk_e3jyvmwmibs4brweylbwkoja1 R

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
pk559563ed Primary key Asc idlocalentrega
idx105100d5 Performance Asc idsegmento
idx15e59a31 Performance Asc idusuario
idx692320e8 Performance Asc idparceiro
idx954b112e Performance Asc idcontatopessoa
idxb0b49ef2 Performance Asc idparceiroentrega
idxb7ef7629 Performance Asc idlocal
idxf514ade7 Performance Asc idlocalfilial
idxwsversao_559563ed Performance Desc wsversao
uc7a8e5a6d 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.