bempatrimonialanimal


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idbempatrimonialanimal int8 19 null
bempatrimonialanimal_aud.idbempatrimonialanimal Implied Constraint R
bempatrimonial.idbempatrimonial fk_3b7hp9oiqveibjstnjaimoe63 R
idtipoanimal int8 19 null
tipoanimal.idtipoanimal fk_ifl5v27j29myt10ij7s18eo5b R
idanimalfinprodutiva int8 19 null
animalfinprodutiva.idanimalfinprodutiva fk_chsmut80dbiy8q5p88uth06lu R
idanimalestagio int8 19 √ null
animalestagio.idanimalestagio fk_k2r19v79vmnxk7mqh9mvmegcp R
idanimalraca int8 19 √ null
animalraca.idanimalraca fk_rt2qym492u7u8u20scdb393lc R
idanimalgrausangue int8 19 √ null
animalgrausangue.idanimalgrausangue fk_rh0j1sgoi4jif10hnmdqp790n R
idanimalcoloracao int8 19 √ null
animalcoloracao.idanimalcoloracao fk_sfrk2jkg1xnpsmr72acakbjcd R
sglsexo varchar 10 √ null
brinco varchar 80 √ null
semen varchar 80 √ null
registro varchar 80 √ null
nomepai varchar 80 √ null
nomemae varchar 80 √ null
datanascimento date 13 √ null
datainicioestagio date 13 √ null
quantidadeconsumodiaracao numeric 18,6 √ null
capacidadeprodutiva numeric 18,6 √ null
idunidademedida int8 19 √ null
unidademedida.idunidademedida fk_fjbiyyapox6kncc6fsnb4omtk R
altura numeric 18,6 √ null
peso numeric 18,6 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk1b61afb4 Primary key Asc idbempatrimonialanimal
idx165a8bd2 Performance Asc idanimalestagio
idx33066f4c Performance Asc idtipoanimal
idx6b8104c3 Performance Asc idanimalgrausangue
idx6f502b86 Performance Asc idanimalraca
idxddbb0366 Performance Asc idanimalfinprodutiva
idxf0a7d4e Performance Asc idunidademedida
idxf485545 Performance Asc idanimalcoloracao
idxwsversao_1b61afb4 Performance Desc wsversao
uc89757b26 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.