financeirocheque


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idfinanceirocheque int8 19 null
financeirocheque_aud.idfinanceirocheque Implied Constraint R
idparceiro int8 19 √ null
parceiro.idparceiro fk_khdjq5iwngx764ygv13xcca3h R
idlocal int8 19 √ null
local.idlocal fk_iio6je7ye9phv890qleh8485r R
idusuario int8 19 √ null
usuario.idusuario fk_mhuxqm2kl8c1ubwggdy22c3ti R
nomebanco varchar 80 √ null
numerocheque varchar 20 √ null
numeroagencia varchar 20 √ null
numeroconta varchar 20 √ null
datavencimento date 13 √ null
valor numeric 18,6 √ null
razaosocialnomecheque varchar 80 √ null
cpfcnpjcheque varchar 80 √ null
observacao varchar 4000 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pkb3fc3bad Primary key Asc idfinanceirocheque
idx114c7a63 Performance Asc idparceiro
idxb1ae6118 Performance Asc idlocal
idxdaf806bd Performance Asc idusuario
idxwsversao_b3fc3bad Performance Desc wsversao
uce3ef1f6d 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.