fluxocontrole


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idfluxocontrole int8 19 null
fluxocontroatualizacao.idfluxocontroatualizacao fk_sr56ps5rdip0pi2gynpkyv424 R
fluxocontroatualizacao.idfluxocontrole fk_26yn4a5ei54mxxr8onn0fbkve R
fluxocontroatualizacao_aud.idfluxocontrole Implied Constraint R
fluxocontrole_aud.idfluxocontrole Implied Constraint R
fluxocontroleregistro.idfluxocontrole fk_1kusdx8tgupnhfnv67qtt0pxd R
fluxocontroleregistro_aud.idfluxocontrole Implied Constraint R
fluxocontrregvinculado.idfluxocontrole fk_1eyijqu1xyofh5801yry08m35 R
fluxocontrregvinculado_aud.idfluxocontrole Implied Constraint R
idnfluxofinalizado int2 5 null
datafluxofinalizado timestamp 29,6 √ null
descricao varchar 80 √ null
idfluxo int8 19 null
fluxo.idfluxo fk_ln7kjipmim1jun6kyk5rf4li8 R
idcontroledocumento int8 19 √ null
controledocumento.idcontroledocumento fk_in85ee6rwnc4pi5bxnol37qa8 R
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk3174104e Primary key Asc idfluxocontrole
idx58a826c7 Performance Asc idfluxo
idxe1b9ff0b Performance Asc idcontroledocumento
idxwsversao_3174104e Performance Desc wsversao
uc66d72e8e 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.