wsconfigcampo


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idwsconfigcampo int8 19 null
pedidocabecalhocampo.idwsconfigcampo fk_2yboybr791dwx33yt2s828nvo R
pedidocabecalhocampo_aud.idwsconfigcampo Implied Constraint R
pedidocomplementocampo.idwsconfigcampo fk_fid3jb4h1f46bujj0pdhd75u7 R
pedidocomplementocampo_aud.idwsconfigcampo Implied Constraint R
pedidoentregacampo.idwsconfigcampo fk_7s1mcbjefgs614xil5loidp07 R
pedidoentregacampo_aud.idwsconfigcampo Implied Constraint R
pedidoprodutocampo.idwsconfigcampo fk_ldnmxjmv9boeeww679vjxdoyo R
pedidoprodutocampo_aud.idwsconfigcampo Implied Constraint R
pedidoresumocampo.idwsconfigcampo fk_rfu34eebl6tb2prigwg1g4qwb R
pedidoresumocampo_aud.idwsconfigcampo Implied Constraint R
wsconfigcampo_aud.idwsconfigcampo Implied Constraint R
wsconfigcampoopcaofixo.idwsconfigcampo fk_7953rh4x6gotj8f4dc8o1dhrv R
wsconfigcampoopcaofixo_aud.idwsconfigcampo Implied Constraint R
wsconfigcampovinculo.idwsconfigcampo fk_90cnmfhkhquujojii02oyrl7t R
wsconfigcampovinculo.idwsconfigcampovinculado fk_hrmb7fp8djfn6hoqongy4joy2 R
wsconfigcampovinculo_aud.idwsconfigcampo Implied Constraint R
wsconfigpedidoregra.idwsconfigcampo fk_j5ualne7ruwhvw3oxpyah4pxu R
wsconfigpedidoregra_aud.idwsconfigcampo Implied Constraint R
identidade int8 19 √ null
entidade.identidade fk_lvrll80gyarvvsj6uve0880vn R
idwsconfigcampotipo int8 19 null
campotipo.idcampotipo fk_tgs23l2e66vhpwlrj0sjcw1si R
idtipodado int8 19 √ null
tipodado.idtipodado fk_sn5msd9s8ykg8o0tccsihotju R
idndinamico int2 5 √ null
descricao varchar 40 null
observacao varchar 500 √ null
mascara varchar 4000 √ null
tamanhomin numeric 18 √ null
tamanhomax numeric 18 √ null
valormin numeric 18,6 √ null
valormax numeric 18,6 √ null
precisamilhar numeric 18 √ null
precisaodecimal numeric 18 √ null
idnchaveprimaria int2 5 √ null
idnobrigatorio int2 5 null
idnpermitevisualizar int2 5 null
idnpermitecadastrar int2 5 null
idnpermiteeditar int2 5 null
idnativo int2 5 null
idnexpressao int2 5 null
idusuariocadastro int8 19 √ null
usuario.idusuario fk_lyrn83xw2wlaotmjolxl85gax R
datacadastro date 13 null
valorpadrao varchar 5000 √ null
expressao varchar 4000 √ null
idnopcaofixa int2 5 null
sgltabela varchar 10 √ null
sglentidade varchar 25 null
sglidentificador varchar 40 null
nometabela varchar 23 √ null
ordem int8 19 null
codigoerp varchar 80 √ null
wsversao int8 19 √ null
idnexiberelatorio int2 5 null
idcampo int8 19 √ null
campo.idcampo fk_k8hrarvh2kuu7ltkharls8y3n R
idnexibeandcard int2 5 null
idnexibeandcarrinho int2 5 null
idnexibeandnegociacao int2 5 null
idnexibewebgrid int2 5 null
idnpersistir int2 5 √ '0'::smallint

Table contained 24 rows

Indexes

Constraint Name Type Sort Column(s)
pke6364350 Primary key Asc idwsconfigcampo
idx9d31e8a3 Performance Asc idcampo
idxad7ead32 Performance Asc idtipodado
idxd29a0a86 Performance Asc identidade
idxd47fc15f Performance Asc idwsconfigcampotipo
idxeb56ff77 Performance Asc idusuariocadastro
idxwsversao_e6364350 Performance Desc wsversao
uc6f8ade6c 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.