campoopcaofixo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcampoopcaofixo int8 19 null
campoopcaofixo_aud.idcampoopcaofixo Implied Constraint R
camporesposta.idcampoopcaofixo fk_pkkb75yqt329rw92uaga0dckl R
camporesposta_aud.idcampoopcaofixo Implied Constraint R
idcampo int8 19 null
campo.idcampo fk_1swa8lxvix9mh2ivvllhtqnwp R
valor varchar 100 √ null
descricao varchar 80 null
idnpadrao int2 5 √ null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
mensagem varchar 120 √ null
idnativo int2 5 √ '1'::smallint

Table contained 8 rows

Indexes

Constraint Name Type Sort Column(s)
pk27a9631c Primary key Asc idcampoopcaofixo
idxcb69426 Performance Asc idcampo
idxwsversao_27a9631c Performance Desc wsversao
uc34f7dbfe 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.