metricanotafiscal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idmetricanotafiscal int8 19 null
metricanfcondpgto.idmetricanotafiscal fk_mtdpjj9u0qgqnyxdw4vxrb7sv R
metricanfcondpgto_aud.idmetricanotafiscal Implied Constraint R
metricanftipo.idmetricanotafiscal fk_r3ehpa6ojjdxs8npt0uf0877j R
metricanftipo_aud.idmetricanotafiscal Implied Constraint R
metricanotafiscal_aud.idmetricanotafiscal Implied Constraint R
idplanejamentometrica int8 19 null
planejamentometrica.idplanejamentometrica fk_8ks5ee8as36o35lf7wkbfystm R
idtipomascaranotafiscal int8 19 null
tipomascaranotafiscal.idtipomascaranotafiscal fk_y9dcs92bet57dqm8e9lqyiqp R
idmetricanotafiscaltotal int8 19 null
metricanotafiscaltotal.idmetricanotafiscaltotal fk_n18waatx33o6c19mfiqh78vt2 R
idnconsideracanceladas int2 5 null
datainicio date 13 null
datafim date 13 null
codigoerp varchar 80 null
wsversao int8 19 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk18ae9ebd Primary key Asc idmetricanotafiscal
idx39054290 Performance Asc idmetricanotafiscaltotal
idxd39798f5 Performance Asc idplanejamentometrica
idxd58b3da0 Performance Asc idtipomascaranotafiscal
idxwsversao_18ae9ebd Performance Desc wsversao
uc6e27f41f 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.