tabelacomissao


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idtabelacomissao int8 19 null
comissao.idtabelacomissao fk_oebyiysrs58mkfqn0cdb5614y R
comissao_aud.idtabelacomissao Implied Constraint R
localtabelacomissao.idtabelacomissao fk_emfp3lavukf4niyadatod1io7 R
localtabelacomissao_aud.idtabelacomissao Implied Constraint R
tabelacomissao_aud.idtabelacomissao Implied Constraint R
descricao varchar 80 null
sgltipotabela varchar 10 √ null
codigo varchar 20 √ null
datainiciovigencia date 13 √ null
datafimvigencia date 13 √ null
idnativo int2 5 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk49518dbb Primary key Asc idtabelacomissao
idxwsversao_49518dbb Performance Desc wsversao
uc5d4fc7df 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.