rotaindicador_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
data date 13 null
dia int8 19 null
mes int8 19 null
ano int8 19 null
totallocalprevisto int8 19 null
totallocalrealizado int8 19 null
totalatendimento int8 19 null
totallocalforaderota int8 19 null
positivacaodentroderota int8 19 null
positivacaoforaderota int8 19 null
tempomedioatendimento int8 19 null
tempototalatendimento int8 19 null
totaljustificado int8 19 null
totalpedidos int8 19 null
codigoerp varchar 80 null
wsversao int8 19 null
idrota int8 19 null
rota.idrota Implied Constraint R
idrotaindicador int8 19 null
rotaindicador.idrotaindicador Implied Constraint R
rev int8 19 null
revtype int8 19 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkbed9a6e6 Primary key Asc id
idxwsversao_bed9a6e6 Performance Desc wsversao

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.