rotalocal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idrotalocal int8 19 null
rotalocal_aud.idrotalocal Implied Constraint R
idlocal int8 19 null
local.idlocal fk_q9g3n733n745qh0d1lh6cdvyw R
idrota int8 19 null
rota.idrota fk_otf68xthpb5rxj7rh0rh0pxyp R
idparceiro int8 19 null
parceiro.idparceiro fk_suwcl6ibbl3r2e4p8g027348d R
idtipoatendimento int8 19 √ null
tipoatendimento.idtipoatendimento fk_nnr5s4sluwvaci88rf6j8frjc R
dia varchar 45 √ null
semana int8 19 √ null
ordem int8 19 null
datafixa date 13 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 60 rows

Indexes

Constraint Name Type Sort Column(s)
pk2ac9e001 Primary key Asc idrotalocal
idxb51ce5fe Performance Asc idlocal
idxb5fcd9f2 Performance Asc idrota
idxbd91296b Performance Asc idtipoatendimento
idxed9d2570 Performance Asc idparceiro
idxwsversao_2ac9e001 Performance Desc wsversao
ucbd8a15fb 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.