tabelakm


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtabelakm int8 19 null
tabelakm_aud.idtabelakm Implied Constraint R
datafimvigencia date 13 null
datainiciovigencia date 13 null
faixakminicial int8 19 null
faixakmfinal int8 19 null
idnativo int2 5 null
valorkm numeric 18,6 null
idtipopavimentacao int8 19 null
tipopavimentacao.idtipopavimentacao fk_7qjc2lbiolba9k729w6jej5m1 R
idtipoviagem int8 19 null
tipoviagem.idtipoviagem fk_ho221d4dhpsdnoofh850f0j9n R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkce1bed47 Primary key Asc idtabelakm
idx87dcaed5 Performance Asc idtipoviagem
idx924f9c8b Performance Asc idtipopavimentacao
idxwsversao_ce1bed47 Performance Desc wsversao
uc73eff713 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.