bempatrimonialanimal_aud


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 null
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 19,2 √ null
capacidadeprodutiva numeric 19,2 √ null
altura numeric 19,2 √ null
peso numeric 19,2 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idtipoanimal int8 19 √ null
tipoanimal.idtipoanimal Implied Constraint R
idanimalfinprodutiva int8 19 √ null
animalfinprodutiva.idanimalfinprodutiva Implied Constraint R
idanimalestagio int8 19 √ null
animalestagio.idanimalestagio Implied Constraint R
idanimalraca int8 19 √ null
animalraca.idanimalraca Implied Constraint R
idanimalgrausangue int8 19 √ null
animalgrausangue.idanimalgrausangue Implied Constraint R
idanimalcoloracao int8 19 √ null
animalcoloracao.idanimalcoloracao Implied Constraint R
idunidademedida int8 19 √ null
unidademedida.idunidademedida Implied Constraint R
idbempatrimonialanimal int8 19 √ null
bempatrimonialanimal.idbempatrimonialanimal Implied Constraint R
rev int8 19 √ null
revtype int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk2f06e785 Primary key Asc id
idxwsversao_2f06e785 Performance Desc wsversao

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.